CM_TRN_FS_OPRVW

(SQL View)
Index Back

Transfer Copy From Source BU


SELECT DISTINCT TR.BUSINESS_UNIT FROM PS_SP_BUIN_OPRVW BU , PS_CM_TRAN_PRC_HDR TR , PS_BUS_UNIT_TBL_IN OPT WHERE BU.BUSINESS_UNIT = TR.BUSINESS_UNIT AND BU.BUSINESS_UNIT = OPT.BUSINESS_UNIT AND OPT.IN_IUT_PRICE_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit