SCP_POLSTBUY1FL

(SQL View)
 Index Back

POA Buyer Tile Count View

Primary view for POA Buyer landing page customized for Tile count

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.PO_POA_STATUS , %DatePart(A.DATETIME_DISP) , OP.OPRID , A.EIP_CTL_ID FROM PS_PO_HDR_EC A , PS_PO_HDR B , PSOPRDEFN OP , PS_OPR_DEF_TBL_PM PM WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND B.PO_STATUS = 'D' AND B.RECV_STATUS IN ('N', 'O', 'P', 'H', 'R') AND A.PROCESS_FLG IN ('N', ' ') AND A.PO_ACK_SOURCE IN('SUP','BUY','EDI') AND (OP.OPRID =PM.OPRID AND PM.ALL_BUYERS_FLG = 'Y' ) AND A.PO_ID NOT IN ( SELECT X.PO_ID FROM PS_PO_DISPATCHED X WHERE A.BUSINESS_UNIT = X.BUSINESS_UNIT AND A.PO_ID = X.PO_ID AND X.DATETIME_DISP > A.DATETIME_CREATE) UNION SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.PO_POA_STATUS , %DatePart(A.DATETIME_DISP) , OP.OPRID , A.EIP_CTL_ID FROM PS_PO_HDR_EC A , PS_PO_HDR B , PSOPRDEFN OP , PS_OPR_PO_BUYER OPR WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND B.PO_STATUS = 'D' AND B.RECV_STATUS IN ('N', 'O', 'P', 'H', 'R') AND A.PROCESS_FLG IN ('N', ' ') AND A.PO_ACK_SOURCE IN('SUP','BUY','EDI') AND ( OP.OPRID =OPR.OPRID AND B.BUYER_ID=OPR.BUYER_ID AND UPDATE_AUTH ='Y') AND A.PO_ID NOT IN ( SELECT X.PO_ID FROM PS_PO_DISPATCHED X WHERE A.BUSINESS_UNIT = X.BUSINESS_UNIT AND A.PO_ID = X.PO_ID AND X.DATETIME_DISP > A.DATETIME_CREATE)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 PO_POA_STATUS Character(3) VARCHAR2(3) NOT NULL 08/07/01 RML Created for Supplier Portal Acknowledgment
BAC=Buyer Accepted
CMP=EDX compare needed
NEW=New
SRP=Supplier Responded
SRV=Supplier Review
4 SCP_DISPATCHED_DT Date(10) DATE Dispatched Date
5 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
6 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field