PV_REQCHNG_VW

(SQL View)
Index Back

Sourceable Requisition's View

POs that cann't be sourced to inventory

SELECT DISTINCT H.BUSINESS_UNIT , H.REQ_ID , H.REQUESTOR_ID FROM PS_REQ_HDR H , PS_REQ_CHNG_ORD C WHERE H.ORIG_TRAN = 'EPO' AND H.BUSINESS_UNIT = C.BUSINESS_UNIT AND H.REQ_ID = C.REQ_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID
3 REQUESTOR_ID Character(30) VARCHAR2(30) NOT NULL Requestor id