PO_ACC_GL_VW2

(SQL View)
Index Back

Distinct GL BU view

Biew used on receipt accrual run control page that selects distinct GL BUs from PO_LINE_DISTRIB table.

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT_GL FROM PS_PO_LINE_DISTRIB A , PS_PO_RC_WB_OK B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID

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