EM_VNDR_LOC_VW2

(SQL View)
 Index Back

Supplier Location View

Used as a search record for Load Invoices

SELECT DISTINCT D.OPRID , A.SETID , A.VENDOR_ID , C.VNDR_LOC , A.VENDOR_NAME_SHORT , A.NAME1 , B.DESCR AS VNDR_LOC_DESCR FROM PS_VENDOR A , PS_VNDR_LOC_SCROL B , PS_VENDOR_LOC C ,PS_VENDOR_USER D , PS_EM_AGREEMENT AG WHERE B.SETID = A.SETID AND B.VENDOR_ID = A.VENDOR_ID AND C.SETID = A.SETID AND C.VENDOR_ID = A.VENDOR_ID AND C.VNDR_LOC = B.VNDR_LOC AND C.EFFDT = ( SELECT MAX(I.EFFDT) FROM PS_VENDOR_LOC I WHERE I.SETID = C.SETID AND I.VENDOR_ID = C.VENDOR_ID AND I.VNDR_LOC = C.VNDR_LOC AND I.EFFDT <= %CurrentDateIn) AND C.EFF_STATUS = 'A' AND A.SETID = D.SETID AND A.VENDOR_ID = D.VENDOR_ID AND A.VENDOR_STATUS = 'A' AND AG.VENDOR_SETID = C.SETID AND AG.VENDOR_ID = C.VENDOR_ID AND AG.VNDR_LOC = C.VNDR_LOC AND AG.EM_AGREE_BUYER = 'Y' AND AG.EM_AGREE_SELLER = 'Y' AND EXISTS ( SELECT 'X' FROM PS_EM_VENDOR_REG E WHERE E.SETID = B.SETID AND E.VENDOR_ID = B.VENDOR_ID)

  • Related Language Record: EM_VNR_LO_VWLN2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SP_SETVC_NONVW

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

    Prompt Table: VENDOR_VW

    4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    5 VENDOR_NAME_SHORT Character(14) VARCHAR2(14) NOT NULL Short Vendor Name
    6 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1
    7 VNDR_LOC_DESCR Character(30) VARCHAR2(30) NOT NULL Supplier Location Description