PO_APPR_VW2

(SQL View)
Index Back

PO Approval view

Purchase Order Approval view.

SELECT H.BUSINESS_UNIT , H.PO_ID , H.PO_DT , H.CURRENCY_CD , SUM (S.MERCHANDISE_AMT) FROM PS_PO_HDR H , PS_PO_LINE_SHIP S WHERE H.BUSINESS_UNIT = S.BUSINESS_UNIT AND H.PO_ID = S.PO_ID AND S.CANCEL_STATUS <> 'X' GROUP BY H.BUSINESS_UNIT, H.PO_ID, H.PO_DT, H.CURRENCY_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 PO_DT Date(10) DATE Date
4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
5 PO_TOTAL Signed Number(28,3) DECIMAL(26,3) NOT NULL PO Total