SPB_INV_BU_VW

(SQL View)
Index Back

Supplier Invoice BU Search Rcd

Filters the Business Units for Supplier Invoice Approval page ************************************************************************************ ICE# 559811000: Apply BU Security ************************************************************************************

SELECT DISTINCT A.OPRID , B.BUSINESS_UNIT , C.DESCR FROM PSOPRALIAS A , PS_SPF_INVOICE_DTL B , PS_BUS_UNIT_TBL_FS C 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

  • Related Language Record: SPB_INV_BU_L_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description