REQ_ACC_GL_VW2

(SQL View)
 Index Back

Requisition Accounting GL

Requisition Accounting GL

SELECT DISTINCT B.WORKBENCH_ID , A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL FROM PS_REQ_LN_DISTRIB A , PS_REQ_RC_WB_EXP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND B.LINE_NBR = 0 AND B.SCHED_NBR = 0 UNION SELECT DISTINCT B.WORKBENCH_ID , A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL FROM PS_REQ_LN_DISTRIB A , PS_REQ_RC_WB_EXP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.LINE_NBR = B.LINE_NBR AND B.SCHED_NBR = 0 UNION SELECT DISTINCT B.WORKBENCH_ID , A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL FROM PS_REQ_LN_DISTRIB A , PS_REQ_RC_WB_EXP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.LINE_NBR = B.LINE_NBR AND A.SCHED_NBR = B.SCHED_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 WORKBENCH_ID Character(10) VARCHAR2(10) NOT NULL WorkBench ID
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 BUSINESS_UNIT_GL Character(5) VARCHAR2(5) NOT NULL GL Business Unit