PO_L2_CNTRCT_VW

(SQL View)
Index Back

PO Line Release Number Prompt


SELECT DISTINCT A.CNTRCT_SETID , A.CNTRCT_ID , A.BUSINESS_UNIT , A.RELEASE_NBR ,B.RELEASE_DTTM FROM PS_PO_LINE A , PS_CNTRCT_EVT_PO B WHERE A.CNTRCT_ID <> ' ' AND A.CNTRCT_SETID = B.SETID AND A.BUSINESS_UNIT = A.BUSINESS_UNIT AND A.CNTRCT_ID = B.CNTRCT_ID AND A.RELEASE_NBR = B.RELEASE_NBR AND A.PO_ID = B.PO_ID AND A.LINE_NBR = B.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

Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT

4 RELEASE_NBR Number(5,0) INTEGER NOT NULL Release Number
5 RELEASE_DTTM DateTime(26) TIMESTAMP Release Date/Time