CHANGE_REQUEST_IDBUSINESS_UNITLANGUAGE_CDRG_TSK_HIER_LVW(SQL View) |
Index Back |
|---|---|
View Tasks of Change RequestRelated language record for RG_TASK_HIER_VW |
| SELECT DISTINCT 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_RG_CHANGE_STATE TP ,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 TP.CHANGE_REQUEST_ID = TL.CHANGE_REQUEST_ID AND TP.BUSINESS_UNIT = TL.BUSINESS_UNIT AND TP.RG_CHANGE_STATE = TL.RG_CHANGE_STATE 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 |