SPB_INV_BU_L_VW

(SQL View)
 Index Back

Supplier Invoice BU Lang Srch

Language View for Supplier Invoice BU Search Record to Filter the Business Units for Supplier Invoice Approval page

SELECT DISTINCT A.OPRID , B.BUSINESS_UNIT , L.LANGUAGE_CD , L.DESCR FROM PSOPRALIAS A , PS_SPF_INVOICE_DTL B , PS_BUS_UNIT_TBL_FS C , PS_BUS_UNIT_LANG L WHERE (A.OPRID = B.SP_SUP_INVAPPROVER OR (A.PERSON_ID = B.SP_SUP_INVAPPROVER AND A.OPRALIASTYPE = 'SPP')) AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND %Join (COMMON_KEYS, BUS_UNIT_LANG L, BUS_UNIT_TBL_FS C)

  • Related Language Record for SPB_INV_BU_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 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description