REQ_CHNG_L_FLD

(SQL View)
 Index Back

Req Change Order

Requisition Line Fields that are eligible for Change Order Tracking

SELECT A.BUSINESS_UNIT , B.FIELDNAME FROM PS_BUS_UNIT_TBL_PM A , PS_CHNG_TMPLT_FLD B , PSDBFIELD C WHERE A.CHNG_TMPLT_ID_REQ = B.CHNG_TMPLT_ID AND B.RECNAME = 'REQ_LINE' AND B.FIELDNAME = C.FIELDNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).