Product: | CSD - Depot Repair |
---|---|
Description: | View that displays the mapping between Service Codes and Task Template Groups. |
Implementation/DBA Data: | APPS.CSD_SC_TASK_TEMP_GROUP_V |
SELECT CSCWE.ROWID
, CSCWE.SC_WORK_ENTITY_ID
, CSCWE.OBJECT_VERSION_NUMBER
, CSCWE.SERVICE_CODE_ID
, CSCWE.CREATED_BY
, CSCWE.CREATION_DATE
, CSCWE.LAST_UPDATED_BY
, CSCWE.LAST_UPDATE_DATE
, CSCWE.LAST_UPDATE_LOGIN
, CSCWE.WORK_ENTITY_ID1
, JTT.TEMPLATE_GROUP_NAME
, JTT.DESCRIPTION
FROM CSD_SC_WORK_ENTITIES CSCWE
, JTF_TASK_TEMP_GROUPS_VL JTT
WHERE CSCWE.WORK_ENTITY_TYPE_CODE = 'TASK'
AND CSCWE.WORK_ENTITY_ID1 = JTT.TASK_TEMPLATE_GROUP_ID