SETID_BU_GL_VW

(SQL View)
Index Back

SetId BU General Ledger View

SetId BU General Ledger View

SELECT A.SETID, B.BUSINESS_UNIT_GL FROM PS_SET_CNTRL_GROUP A, PS_BUS_UNIT_TBL_HR B WHERE REC_GROUP_ID = 'PY_03' AND A.SETCNTRLVALUE = B.BUSINESS_UNIT AND B.BUSINESS_UNIT_GL <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL General Ledger Unit