View: CS_SR_RES_CODE_MAPPING_V

Product:	CS - Service
Description:	This view lists the mapping of resolution codes to service request types and inventory items.
Implementation/DBA Data:	APPS.CS_SR_RES_CODE_MAPPING_V

View Text

SELECT RESMAP.ROWID
, RESMAP.RESOLUTION_MAP_ID
, RESMAP.RESOLUTION_MAP_DETAIL_ID
, RESMAP.RESOLUTION_CODE
, RESMAP.INCIDENT_TYPE_ID
, RESMAP.INVENTORY_ITEM_ID
, RESMAP.ORGANIZATION_ID
, MTLCSET.CATEGORY_ID
, RESMAP.PROBLEM_CODE
, RESMAP.MAP_START_DATE_ACTIVE
, RESMAP.MAP_END_DATE_ACTIVE
, RESMAP.START_DATE_ACTIVE
, RESMAP.END_DATE_ACTIVE
, RESMAP.OBJECT_VERSION_NUMBER
, RESMAP.LAST_UPDATE_DATE
, RESMAP.LAST_UPDATED_BY
, RESMAP.CREATION_DATE
, RESMAP.CREATED_BY
, RESMAP.LAST_UPDATE_LOGIN
, RESMAP.ATTRIBUTE1
, RESMAP.ATTRIBUTE2
, RESMAP.ATTRIBUTE3
, RESMAP.ATTRIBUTE4
, RESMAP.ATTRIBUTE5
, RESMAP.ATTRIBUTE6
, RESMAP.ATTRIBUTE7
, RESMAP.ATTRIBUTE8
, RESMAP.ATTRIBUTE9
, RESMAP.ATTRIBUTE10
, RESMAP.ATTRIBUTE11
, RESMAP.ATTRIBUTE12
, RESMAP.ATTRIBUTE13
, RESMAP.ATTRIBUTE14
, RESMAP.ATTRIBUTE15
, RESMAP.ATTRIBUTE_CATEGORY
, CSLKP.MEANING RESOLUTION_MEANING
, CSLKP_1.MEANING PROBLEM_MEANING
, INTYP.NAME INCIDENT_TYPE
, MTLKFV.CONCATENATED_SEGMENTS INVENTORY_ITEM
, CSLKP.DESCRIPTION
, MTLCSET.CONCATENATED_SEGMENTS CATEGORY_NAME
FROM CS_SR_RES_CODE_MAPPING_DETAIL RESMAP
, CS_LOOKUPS CSLKP
, CS_LOOKUPS CSLKP_1
, CS_INCIDENT_TYPES_VL INTYP
, MTL_SYSTEM_ITEMS_KFV MTLKFV
, MTL_CATEGORIES_KFV MTLCSET
WHERE RESMAP.PROBLEM_CODE = CSLKP_1.LOOKUP_CODE
AND CSLKP_1.LOOKUP_TYPE = 'REQUEST_PROBLEM_CODE'
AND RESMAP.PROBLEM_CODE = CSLKP.LOOKUP_CODE
AND CSLKP.LOOKUP_TYPE = 'REQUEST_RESOLUTION_CODE'
AND CSLKP.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(CSLKP.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(CSLKP.END_DATE_ACTIVE
, SYSDATE))
AND RESMAP.INCIDENT_TYPE_ID = INTYP.INCIDENT_TYPE_ID(+)
AND RESMAP.INVENTORY_ITEM_ID = MTLKFV.INVENTORY_ITEM_ID(+)
AND RESMAP.ORGANIZATION_ID = MTLKFV.ORGANIZATION_ID(+)
AND RESMAP.CATEGORY_ID = MTLCSET.CATEGORY_ID(+)

Columns