BUSINESS_UNITGL_JSRC_BU_VW(SQL View) |
Index Back |
|---|---|
Business Unit ViewBusiness Unit View for Journal Source Security |
| SELECT A.BUSINESS_UNIT ,(SELECT B.DESCR FROM PS_BUS_UNIT_TBL_FS B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT) FROM PS_BUS_UNIT_TBL_GL A WHERE EXISTS ( SELECT 'X' FROM PS_SET_CNTRL_GROUP B WHERE A.BUSINESS_UNIT = B.SETCNTRLVALUE AND B.REC_GROUP_ID = 'FS_11' AND B.SETID IN ( SELECT C.SETID FROM PS_GL_JSRC_SETID C )) 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 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |