DEMAND_RTVID_VW

(SQL View)
Index Back

Pick Batch ID Prompt View

08/30/04 tw Updated to use IN_DEMAND.

SELECT DISTINCT BUSINESS_UNIT , RTV_ID , BUSINESS_UNIT_PO FROM PS_IN_DEMAND WHERE IN_FULFILL_STATE = '60' AND RTV_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RTV_ID Character(10) VARCHAR2(10) NOT NULL Return To Vendor ID
3 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit