ITM_VNDR_HDR_VW

(SQL View)
 Index Back

SELECT DISTINCT A.SETID , B.INV_ITEM_ID , A.VENDOR_SETID , A.VENDOR_ID , E.NAME1 , A.CNTRCT_ID , B.DESCR254_MIXED , A.VNDR_CNTRCT_REF FROM PS_CNTRCT_HDR A , PS_CNTRCT_LINE B , PS_VENDOR E WHERE A.VERSION_STATUS = 'C' AND A.SETID = B.SETID AND A.CNTRCT_ID = B.CNTRCT_ID AND A.VERSION_NBR = B.VERSION_NBR AND A.VENDOR_SETID = E.SETID AND A.VENDOR_ID = E.VENDOR_ID AND EXISTS ( SELECT 'X' FROM PS_CNTRCT_LINE_UOM C , PS_CNTRCT_LN_SHIP D WHERE C.SETID = B.SETID AND C.CNTRCT_ID = B.CNTRCT_ID AND C.VERSION_NBR = B.VERSION_NBR AND C.CNTRCT_LINE_NBR = B.CNTRCT_LINE_NBR AND D.SETID = B.SETID AND D.CNTRCT_ID = B.CNTRCT_ID AND D.VERSION_NBR = B.VERSION_NBR AND D.CNTRCT_LINE_NBR = B.CNTRCT_LINE_NBR)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
5 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
6 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
7 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
8 VNDR_CNTRCT_REF Character(30) VARCHAR2(30) NOT NULL Supplier Contract Ref