RTV_RECV_PO_VW (SQL View)	Index Back
Recv Line Ship View for RTV

RTV_RECV_PO_VW

(SQL View)

Recv Line Ship View for RTV

SELECT DISTINCT S.BUSINESS_UNIT_PO , S.PO_ID FROM PS_RECV_LN_SHIP S WHERE S.AMT_ONLY_FLG = 'N' AND S.MOVE_STAT_INV <> 'P'

# 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

#	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