CM_PO_HDR_VW (SQL View)	Index Back
Received POs All distinct POs for which shipments have been received.

CM_PO_HDR_VW

(SQL View)

Received POs

All distinct POs for which shipments have been received.

SELECT DISTINCT A.BUSINESS_UNIT , A.PO_ID , A.PO_DT , A.VENDOR_ID FROM PS_PO_HDR A , PS_RECV_LN_SHIP B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT_PO AND A.PO_ID = B.PO_ID

# 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 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

#	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	VENDOR_ID	Character(10)	VARCHAR2(10) NOT NULL	Vendor Identifier