FO_VENDOR_LSCH

(SQL View)
 Index Back

Supplier Search Record

Supplier Search Record

SELECT A.FO_OI_VENDOR_ID , A.FO_OI_VERSION , B.LANGUAGE_CD , B.FO_OI_VENDOR_LNAME , B.FO_OI_VENDOR_SNAME , B.FO_OI_VENDOR_DESCR , C.FO_OI_TG_NAME FROM PS_FO_VENDOR A , PS_FO_VENDOR_LNG B , PS_FO_TGROUP C WHERE A.FO_OI_TG_ID=C.FO_OI_TG_ID AND A.FO_OI_VENDOR_ID=B.FO_OI_VENDOR_ID AND A.FO_OI_VERSION=B.FO_OI_VERSION AND A.FO_OI_VERSION = ( SELECT MAX (B.FO_OI_VERSION) FROM PS_FO_VENDOR B WHERE B.FO_OI_VENDOR_ID=A.FO_OI_VENDOR_ID)

  • Related Language Record for FO_VENDOR_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FO_OI_VENDOR_ID Number(15,0) DECIMAL(15) NOT NULL Integration Vendor ID
    2 FO_OI_VERSION Number(15,0) DECIMAL(15) NOT NULL used as version for numerous integration objects
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 FO_OI_VENDOR_LNAME Character(30) VARCHAR2(30) NOT NULL Integration Vendor Long Name
    5 FO_OI_VENDOR_SNAME Character(10) VARCHAR2(10) NOT NULL Integration Vendor Short Name
    6 FO_OI_VENDOR_DESCR Character(254) VARCHAR2(254) NOT NULL Integration Vendor Description
    7 FO_OI_TG_NAME Character(15) VARCHAR2(15) NOT NULL Transaction Group Name