PO_POA_PEND_VW

(SQL View)
 Index Back

Pending POA's for the buyer

cel 5/6/2003 - new view for the buyer side poa pagelet.

SELECT B.BUYER_ID , EIP_CTL_ID , A.BUSINESS_UNIT , A.PO_ID , A.ACKNOWLEGE_DT , A.PO_POA_STATUS , A.PO_ACK_SOURCE , B.VENDOR_SETID , B.VENDOR_ID FROM PS_PO_HDR_EC A , PS_PO_HDR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PO_ID = B.PO_ID AND A.PO_POA_STATUS = 'SRP'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer
2 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
5 ACKNOWLEGE_DT Date(10) DATE Acknowledge Date
6 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
7 PO_ACK_SOURCE Character(3) VARCHAR2(3) NOT NULL Created on 08/09/01 CN#WV840-4.0 - Purchase Order Acknowledgment source used in PO_HDR_EC
BUY=Online (Buyer)
EDI=EDX
SUP=Online (Supplier)
8 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
9 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier