SPM_BU_SNW_LVW

(SQL View)
 Index Back

Supplier Info by BU

SELECT A.BUSINESS_UNIT, B.VENDOR_ID, B.NAME1, A.NOTIFY_BY, A.PERSON_ID, A.SPM_SOURCETYPE, A.SUBMITAL_LIMIT FROM PS_SPM_BU_SUPPLIER A, PS_VENDOR_SPRO_VW B WHERE A.EFFDT = (SELECT MAX(A_ED.EFFDT) FROM PS_SPM_BU_SUPPLIER A_ED WHERE A.BUSINESS_UNIT = A_ED.BUSINESS_UNIT AND A.VENDOR_ID = A_ED.VENDOR_ID AND A_ED.EFFDT <= SUBSTRING(CONVERT(CHAR,GETDATE(),121), 1, 10)) AND A.VENDOR_ID = B.VENDOR_ID AND A.EFF_STATUS = 'A'

SELECT A.BUSINESS_UNIT , B.VENDOR_ID ,B.LANGUAGE_CD , B.NAME1 FROM PS_SPM_BU_SUPPLIER A , PS_VENDOR_SPRO_LVW B , PS_SET_CNTRL_GROUP S WHERE A.VENDOR_ID = B.VENDOR_ID AND A.EFF_STATUS = 'A' AND A.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'FS_38' AND B.SETID = S.SETID

  • Related Language Record for SPM_BU_SNW_D_VW SPM_BU_SNW_R_VW SPM_BU_SNW_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Prompt Table: BUS_UNIT_SP_VW

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

    Prompt Table: VENDOR_SP_VW
    Set Control Field: BUSINESS_UNIT

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1