VIEW: APPS.CS_SR_PROB_CODE_MAPPING_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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