VENDOR_WTHD_VW2

(SQL View)
 Index Back

Supplier Withold View

Supplier Withold View

SELECT a.setid , a.vendor_id , a.vndr_loc , b.name1 FROM PS_VENDOR_WTHD a , ps_vendor b WHERE a.effdt = ( SELECT MAX(c.effdt) FROM ps_vendor_loc c WHERE c.setid = a.setid AND c.vendor_id = a.vendor_id AND c.vndr_loc = a.vndr_loc AND c.effdt <= %CurrentDateIn AND c.eff_status = 'A') AND b.setid = a.setid AND b.vendor_id = a.vendor_id AND b.wthd_sw = 'Y'

  • Related Language Record: VNDR_WTH_LG_VW2

    • # 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_SETVND_NONVW

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1