SP_BURCSLLOPRVW

(SQL View)
Index Back

Business Units for Sales Lead

Business Units for creating Sales Lead

SELECT DISTINCT A.SETID , E.OPRID , C.BUSINESS_UNIT , F.LANGUAGE_CD , D.DESCR FROM PS_SET_CNTRL_REC A , PS_BUS_UNIT_TBLRSF C , PS_BUS_UNIT_TBL_FS D , PS_SEC_BU_OPR E , PS_BUS_UNIT_LANG F WHERE A.SETCNTRLVALUE = C.BUSINESS_UNIT AND A.SETCNTRLVALUE = D.BUSINESS_UNIT AND A.SETCNTRLVALUE = E.BUSINESS_UNIT AND A.SETCNTRLVALUE = F.BUSINESS_UNIT AND A.RECNAME = 'BC' AND C.BU_STATUS = '1'

  • Related Language Record for SP_BU_RCSLOPRVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID
    2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description