View: CS_SR_PROB_CODE_MAPPING_V

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

View Text

SELECT PCMAP.ROWID
, PCMAP.PROBLEM_MAP_ID
, PCMAP.PROBLEM_MAP_DETAIL_ID
, PCMAP.PROBLEM_CODE
, PCMAP.INCIDENT_TYPE_ID
, PCMAP.INVENTORY_ITEM_ID
, PCMAP.ORGANIZATION_ID
, PCMAP.CATEGORY_ID
, PCMAP.START_DATE_ACTIVE
, PCMAP.END_DATE_ACTIVE
, PCMAP.MAP_START_DATE_ACTIVE
, PCMAP.MAP_END_DATE_ACTIVE
, PCMAP.OBJECT_VERSION_NUMBER
, PCMAP.CREATED_BY
, PCMAP.CREATION_DATE
, PCMAP.LAST_UPDATED_BY
, PCMAP.LAST_UPDATE_DATE
, PCMAP.LAST_UPDATE_LOGIN
, PCMAP.ATTRIBUTE_CATEGORY
, PCMAP.ATTRIBUTE1
, PCMAP.ATTRIBUTE2
, PCMAP.ATTRIBUTE3
, PCMAP.ATTRIBUTE4
, PCMAP.ATTRIBUTE5
, PCMAP.ATTRIBUTE6
, PCMAP.ATTRIBUTE7
, PCMAP.ATTRIBUTE8
, PCMAP.ATTRIBUTE9
, PCMAP.ATTRIBUTE10
, PCMAP.ATTRIBUTE11
, PCMAP.ATTRIBUTE12
, PCMAP.ATTRIBUTE13
, PCMAP.ATTRIBUTE14
, PCMAP.ATTRIBUTE15
, CSLKP.MEANING PROBLEM_MEANING
, INTYP.NAME INCIDENT_TYPE
, MTLKFV.CONCATENATED_SEGMENTS INVENTORY_ITEM
, CSLKP.DESCRIPTION
, MTLCSET.CONCATENATED_SEGMENTS CATEGORY_NAME
FROM CS_SR_PROB_CODE_MAPPING_DETAIL PCMAP
, CS_LOOKUPS CSLKP
, CS_INCIDENT_TYPES_VL INTYP
, MTL_SYSTEM_ITEMS_KFV MTLKFV
, MTL_CATEGORIES_KFV MTLCSET
WHERE PCMAP.PROBLEM_CODE = CSLKP.LOOKUP_CODE
AND CSLKP.LOOKUP_TYPE = 'REQUEST_PROBLEM_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 PCMAP.INCIDENT_TYPE_ID = INTYP.INCIDENT_TYPE_ID(+)
AND PCMAP.INVENTORY_ITEM_ID = MTLKFV.INVENTORY_ITEM_ID(+)
AND PCMAP.ORGANIZATION_ID = MTLKFV.ORGANIZATION_ID(+)
AND PCMAP.CATEGORY_ID = MTLCSET.CATEGORY_ID(+)

Columns