CHANGE_REQUEST_IDBUSINESS_UNITLANGUAGE_CDRG_CHG_TASK_LVW(SQL View) |
Index Back |
|---|---|
View Tasks of Change RequestRelated Language record for RG_CHG_TASK_VW |
| SELECT TL.CHANGE_REQUEST_ID , TL.BUSINESS_UNIT , TTL.LANGUAGE_CD , TTL.DESCR60 FROM PS_RG_CHG_PHS_TSK TL , PS_RB_TGRP_TSK TT , PS_RB_TSK T , PS_RB_TSK_LANG TTL WHERE TL.TASK_GRP_ID = TT.TASK_GRP_ID AND TTL.TASK_ID = T.TASK_ID AND TT.TASK_ID = T.TASK_ID AND T.TASK_STATUS <> 'CNCL' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CHANGE_REQUEST_ID |
Character(15) | VARCHAR2(15) NOT NULL | change request identification is key to change request |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |