VIEW: APPS.CS_SR_RES_CODE_MAPPING_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)