VNDR_LOC_SR_EF

(SQL View)
 Index Back

Supplier Loc EffDt Search VW


SELECT a.setid , a.vendor_id , a.vndr_loc , a.effdt , a.eff_status , a.comments_2000 , b.descr , b.ccr_addr_type FROM PS_VENDOR_LOC a , PS_VNDR_LOC_SCROL b WHERE a.effdt = ( SELECT MAX(i.effdt) FROM PS_VENDOR_LOC i WHERE i.setid = a.setid AND i.vendor_id = a.vendor_id AND i.vndr_loc = a.vndr_loc AND i.eff_status = 'A' AND i.effdt <= %CurrentDateIn) AND a.setid = b.setid AND a.vendor_id = b.vendor_id AND a.vndr_loc = b.vndr_loc

  • Parent record: VENDOR

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

    Prompt Table: SETID_TBL

    2 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    3 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    6 COMMENTS_2000 Long Character CLOB Comment Text
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 CCR_ADDR_TYPE Character(3) VARCHAR2(3) NOT NULL SAM Address Type