BUSINESS_UNITPrompt Table: SP_BU_GL_NONVW
LANGUAGE_CDRS_BUEX_LNG(SQL View) |
Index Back |
|---|---|
EX Business Units RelLang ViewReturns Expenses Business Units that have not yet been linked to a Region in Utilization Percentage setup. Related Language View. |
| SELECT A.BUSINESS_UNIT , B.LANGUAGE_CD , B.DESCR FROM %Table(BUS_UNIT_TBL_GL) A , %Table(BUS_UNIT_LANG) B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT NOT IN ( SELECT DISTINCT BUSINESS_UNIT FROM %Table(RS_REGION_BUEX)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_GL_NONVW |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |