EM_SP_RMVELN_VW

(SQL View)
 Index Back

Seller Remit To Lang View

MP - Seller Remit To View

SELECT DISTINCT SEC.OPRID , V.VENDOR_ID , VL.LANGUAGE_CD , VL.NAME1 FROM PS_EM_AGREEMENT AG , PS_SEC_BU_OPR SEC , PS_VENDOR V , PS_VENDOR_LANG VL WHERE SEC.BUSINESS_UNIT = AG.SETID AND V.SETID = AG.VENDOR_SETID AND V.VENDOR_ID = AG.VENDOR_ID AND V.VENDOR_STATUS = 'A' AND %Sql(EM_SET_CNTRL_EXISTS_OR_NOT) AND V.SETID = VL.SETID AND V.VENDOR_ID = VL.VENDOR_ID

  • Related Language Record for EM_SP_RMITVE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 NAME1 Character(40) VARCHAR2(40) NOT NULL Name 1