RTV_PO_VW

(SQL View)

SELECT BUSINESS_UNIT , VENDOR_ID , PO_ID , PO_REF , PO_STATUS , BUYER_ID FROM PS_PO_HDR WHERE PO_ID IN ( SELECT PO_ID FROM PS_RECV_LN_SHIP WHERE receiver_id IN ( SELECT receiver_id FROM PS_RECV_HDR WHERE recv_status IN ('R', 'M', 'P', 'C')))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

3 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
Default Value: NEXT

4 PO_REF Character(30) VARCHAR2(30) NOT NULL Specifies the purchase order number associated with a receivables item.

5 PO_STATUS Character(2) VARCHAR2(2) NOT NULL PO Status
A=Approved
C=Complete
D=Dispatched
DA=Denied
I=Initial
LD=Line Denied
O=Open
PA=Pending Approval/Approved
PX=Pending Cancel
X=Canceled
Default Value: I

6 BUYER_ID Character(30) VARCHAR2(30) NOT NULL Buyer

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
2	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier
3	PO_ID	Character(10)	VARCHAR2(10) NOT NULL	Purchase Order Default Value: NEXT
4	PO_REF	Character(30)	VARCHAR2(30) NOT NULL	Specifies the purchase order number associated with a receivables item.
5	PO_STATUS	Character(2)	VARCHAR2(2) NOT NULL	PO Status A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled Default Value: I
6	BUYER_ID	Character(30)	VARCHAR2(30) NOT NULL	Buyer