PO_AW_DCSN_VW

(SQL View)
 Index Back

Mass approvals Pending

Mass approvals Pending

SELECT A.BUSINESS_UNIT , A.PO_ID , B.EOAWAPPROVER_OPRID FROM PS_PO_AW_ACTION_VW A , PS_EOAW_DECISION B WHERE A.EOAWDEFN_ID = B.EOAWDEFN_ID AND A.EOAWPRCS_ID = B.EOAWPRCS_ID AND A.EOAWTHREAD_ID = B.EOAWTHREAD_ID AND B.EOAWDONE_FLAG = 'N' AND A.OPRID = B.EOAWAPPROVER_OPRID

# 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 APPROVER_OPRID Character(30) VARCHAR2(30) NOT NULL Approver Oprid