PO_LNDSCNTRQ_VW

(SQL View)
Index Back

SELECT DISTINCT PL.CNTRCT_SETID , PL.CNTRCT_ID , PD.BUSINESS_UNIT , PD.REQ_ID FROM PS_PO_LINE_DISTRIB PD , PS_PO_LINE PL WHERE PL.BUSINESS_UNIT = PD.BUSINESS_UNIT AND PL.PO_ID = PD.PO_ID AND PL.LINE_NBR = PD.LINE_NBR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
4 REQ_ID Character(10) VARCHAR2(10) NOT NULL Requisition ID