VNDR_ITM_LNG_VW

(SQL View)
 Index Back

Items by Supplier Language Vie


SELECT A.VENDOR_SETID , A.VENDOR_ID , D.VNDR_LOC , A.SETID , A.INV_ITEM_ID , E.LANGUAGE_CD , E.DESCR , A.ITM_ID_VNDR , A.VNDR_CATALOG_ID , D.USE_STD_LEAD_TIME , B.STOCKLESS_FLG , A.COMMENTS_LONG FROM PS_ITM_VENDOR A , PS_PURCH_ITEM_ATTR B , PS_MASTER_ITEM_TBL C , PS_ITM_VENDOR_LOC D , PS_PURCH_ITEM_LANG E WHERE A.SETID = B.SETID AND A.INV_ITEM_ID = B.INV_ITEM_ID AND B.SETID = C.SETID AND B.INV_ITEM_ID = C.INV_ITEM_ID AND A.SETID = D.SETID AND A.INV_ITEM_ID = D.INV_ITEM_ID AND B.SETID = D.SETID AND B.INV_ITEM_ID = D.INV_ITEM_ID AND C.ITM_STATUS_CURRENT = '1' AND ((%CurrentDateIn >= B.PO_AVAIL_DT) AND (B.PO_UNAVAIL_DT > %CurrentDateIn)) AND C.SETID = E.SETID AND C.INV_ITEM_ID = E.INV_ITEM_ID

  • Related Language Record for EM_VNDR_ITM_VW VENDOR_ITM_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier

    Prompt Table: VNDR_VNDSET_VW

    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
    5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 ITM_ID_VNDR Character(50) VARCHAR2(50) NOT NULL Vendor Item ID
    9 VNDR_CATALOG_ID Character(20) VARCHAR2(20) NOT NULL Vendor's Catalog Number
    10 USE_STD_LEAD_TIME Character(1) VARCHAR2(1) NOT NULL Use Item Standard Lead Time
    11 STOCKLESS_FLG Character(1) VARCHAR2(1) NOT NULL Stockless Item
    N=No
    Y=Yes
    12 COMMENTS_LONG Long Character CLOB Comment Text