PO_CNTR_LGSRCH

(SQL View)
 Index Back

Contract Search for PO's

Language record of PO_CNTRCT_SRCH

SELECT DISTINCT A.VENDOR_SETID , A.VENDOR_ID , A.SETID , A.CNTRCT_ID , f.language_cd , f.vendor_name_short FROM PS_CNTRCT_HDR A , PS_VENDOR B , ps_vendor_lang f WHERE A.VENDOR_SETID = B.SETID AND A.VENDOR_ID = B.VENDOR_ID AND b.setid=f.setid AND b.vendor_id=f.vendor_id AND A.CNTRCT_STATUS = 'A' AND A.VERSION_STATUS = 'C' AND A.VCHR_SRC = 'CNTR' AND ((A.CNTRCT_TYPE = 'PO') OR (A.CNTRCT_TYPE = 'GN' AND (A.ALLOW_OPEN_ITEM = 'Y' OR EXISTS ( SELECT 'X' FROM PS_CNTRCT_LINE_UOM C , PS_CNTRCT_LN_SHIP D , PS_CNTRCT_LINE E WHERE E.SETID = A.SETID AND E.CNTRCT_ID = A.CNTRCT_ID AND E.VERSION_NBR = A.VERSION_NBR AND C.SETID = E.SETID AND C.CNTRCT_ID = E.CNTRCT_ID AND C.VERSION_NBR = E.VERSION_NBR AND C.CNTRCT_LINE_NBR = E.CNTRCT_LINE_NBR AND D.SETID = E.SETID AND D.CNTRCT_ID = E.CNTRCT_ID AND D.VERSION_NBR = E.VERSION_NBR AND D.CNTRCT_LINE_NBR = E.CNTRCT_LINE_NBR AND E.DESCR254_MIXED <> ' ' AND E.CATEGORY_ID <> ' ' AND E.UNIT_OF_MEASURE <> ' ' AND C.VNDR_LOC <> ' ' AND C.PRICE_CNTRCT_BASE <> 0 AND D.QTY_SCHED <> 0))))

  • Related Language Record for PO_CNTRCT_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_CNTRCT_SET Character(5) VARCHAR2(5) NOT NULL Supplier Set ID
    2 VENDOR_CNTRCT Character(10) VARCHAR2(10) NOT NULL Supplier ID
    3 CNTRCT_SETID Character(5) VARCHAR2(5) NOT NULL SetID
    4 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name