PV_PERF_V4_LW

(SQL View)
 Index Back

SELECT A.SETID ,A.INV_ITEM_ID ,A.VENDOR_SETID ,A.VENDOR_ID ,A.LANGUAGE_CD ,A.DESCR ,A.DESCR60 , H.NAME1 FROM PS_PV_PERF_V1_LW A , PS_VENDOR_LANG H WHERE A.VENDOR_SETID = H.SETID (+) AND A.VENDOR_ID = H.VENDOR_ID(+) AND A.LANGUAGE_CD = H.LANGUAGE_CD(+)

  • Related Language Record for PV_PERF_M2_VW PV_PERF_M5_VW PV_PERF_MR_VW PV_PERF_MT2_VW PV_PERF_MT5_VW PV_PERF_MTN2_VW PV_PERF_MTN5_VW PV_PERF_MT_N_VW PV_PERF_MT_VW PV_PERF_NR_N_VW PV_PERF_NR_VW PV_PERF_NT_VW PV_PERF_ST_N_VW PV_PERF_ST_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
    2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
    3 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
    4 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    8 VNDR_NAME1 Character(40) VARCHAR2(40) NOT NULL Supplier Name