OPRIDBUSINESS_UNITSP_GL_BU_OPRVW(SQL View) |
Index Back |
|---|---|
Business Unit Dynamic ViewBusiness Unit Dynamic View used in Journal Source Security |
| SELECT DISTINCT E.OPRID ,A.BUSINESS_UNIT ,( SELECT B.DESCR FROM PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT) FROM PS_BU_LED_GRP_TBL A , PS_SEC_BU_OPR E WHERE A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.BUSINESS_UNIT IN ( SELECT C.SETCNTRLVALUE FROM PS_SET_CNTRL_GROUP C WHERE A.BUSINESS_UNIT = C.SETCNTRLVALUE AND C.REC_GROUP_ID = 'FS_11' AND C.SETID IN ( SELECT D.SETID FROM PS_GL_JSRC_SETID D) AND EXISTS ( SELECT 1 FROM PS_GL_JRNL_SRC_BU D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT)) |
| # | 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 |