VIEW: APPS.CSM_INCIDENTS_ALL_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER(A.ACCESS_ID) , B.INCIDENT_ID ,CSM_UTIL_PKG.GET_VARCHAR(B.INCIDENT_NUMBER) , B.CALLER_TYPE , CSM_UTIL_PKG.GET_NUMBER(B.INCIDENT_SEVERITY_ID) , CSM_UTIL_PKG.GET_NUMBER(B.INCIDENT_STATUS_ID) , CSM_UTIL_PKG.GET_NUMBER(B.INCIDENT_TYPE_ID) , B.INCIDENT_URGENCY_ID , B.INCIDENT_DATE , CSM_UTIL_PKG.GET_VARCHAR(TL.SUMMARY) , B.ORG_ID , B.CUSTOMER_ID , B.INSTALL_SITE_USE_ID , B.CUSTOMER_PRODUCT_ID , B.INVENTORY_ITEM_ID , B.CURRENT_SERIAL_NUMBER , B.INV_ORGANIZATION_ID , csm_util_pkg.item_name(MSIK.CONCATENATED_SEGMENTS), MSIK.DESCRIPTION, B.PROBLEM_CODE , B.RESOLUTION_CODE , B.CONTRACT_SERVICE_ID , B.INV_ITEM_REVISION , B.CUSTOMER_PO_NUMBER , B.credit_card_number, B.credit_card_type_code, B.credit_card_expiration_date, B.credit_card_holder_fname, B.credit_card_holder_mname, B.credit_card_holder_lname, B.INCIDENT_ATTRIBUTE_1 , B.INCIDENT_ATTRIBUTE_2 , B.INCIDENT_ATTRIBUTE_3 , B.INCIDENT_ATTRIBUTE_4 , B.INCIDENT_ATTRIBUTE_5 , B.INCIDENT_ATTRIBUTE_6 , B.INCIDENT_ATTRIBUTE_7 , B.INCIDENT_ATTRIBUTE_8 , B.INCIDENT_ATTRIBUTE_9 , B.INCIDENT_ATTRIBUTE_10 , B.INCIDENT_ATTRIBUTE_11 , B.INCIDENT_ATTRIBUTE_12 , B.INCIDENT_ATTRIBUTE_13 , B.INCIDENT_ATTRIBUTE_14 , B.INCIDENT_ATTRIBUTE_15 , B.INCIDENT_CONTEXT , CSM_UTIL_PKG.GET_DATE(B.LAST_UPDATE_DATE), CSM_UTIL_PKG.GET_NUMBER(B.CREATED_BY), B.INSTALL_SITE_ID, NVL(B.incident_location_id,B.INSTALL_SITE_ID) AS INCIDENT_LOCATION_ID, B.incident_location_type, B.INCIDENT_OCCURRED_DATE, B.INCIDENT_RESOLVED_DATE, B.INC_RESPONDED_BY_DATE, B.OBLIGATION_DATE, B.EXPECTED_RESOLUTION_DATE, B.EXTERNAL_ATTRIBUTE_1, B.EXTERNAL_ATTRIBUTE_2, B.EXTERNAL_ATTRIBUTE_3, B.EXTERNAL_ATTRIBUTE_4, B.EXTERNAL_ATTRIBUTE_5, B.EXTERNAL_ATTRIBUTE_6, B.EXTERNAL_ATTRIBUTE_7, B.EXTERNAL_ATTRIBUTE_8, B.EXTERNAL_ATTRIBUTE_9, B.EXTERNAL_ATTRIBUTE_10, B.EXTERNAL_ATTRIBUTE_11, B.EXTERNAL_ATTRIBUTE_12, B.EXTERNAL_ATTRIBUTE_13, B.EXTERNAL_ATTRIBUTE_14, B.EXTERNAL_ATTRIBUTE_15, B.EXTERNAL_CONTEXT, NVL(B.OBJECT_VERSION_NUMBER,B.OBJECT_VERSION_NUMBER), B.CREDIT_CARD_ID, TL.RESOLUTION_SUMMARY, B.CUSTOMER_TICKET_NUMBER , B.PROJECT_NUMBER, B.INCIDENT_OWNER_ID, B.TIME_ZONE_ID, B.TIME_DIFFERENCE, B.CUST_PREF_LANG_ID, B. CUST_PREF_LANG_CODE, B.EXTERNAL_REFERENCE,B.ACCOUNT_ID, B.OWNER_GROUP_ID, CSM_UTIL_PKG.GET_NUMBER(B.LAST_UPDATED_BY), CSM_UTIL_PKG.get_group_name(B.OWNER_GROUP_ID,ASG_BASE.GET_LANGUAGE) AS OWNER_GROUP_NAME, CSM_UTIL_PKG.GET_DATE(B.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE FROM CSM_INCIDENTS_ALL_ACC A , CS_INCIDENTS_ALL_B B , CS_INCIDENTS_ALL_TL TL, MTL_SYSTEM_ITEMS_KFV MSIK WHERE A.INCIDENT_ID = B.INCIDENT_ID AND B.INCIDENT_ID = TL.INCIDENT_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND A.USER_ID = ASG_BASE.GET_USER_ID AND B.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID (+) AND B.INV_ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(A.ACCESS_ID)
, B.INCIDENT_ID
, CSM_UTIL_PKG.GET_VARCHAR(B.INCIDENT_NUMBER)
, B.CALLER_TYPE
, CSM_UTIL_PKG.GET_NUMBER(B.INCIDENT_SEVERITY_ID)
, CSM_UTIL_PKG.GET_NUMBER(B.INCIDENT_STATUS_ID)
, CSM_UTIL_PKG.GET_NUMBER(B.INCIDENT_TYPE_ID)
, B.INCIDENT_URGENCY_ID
, B.INCIDENT_DATE
, CSM_UTIL_PKG.GET_VARCHAR(TL.SUMMARY)
, B.ORG_ID
, B.CUSTOMER_ID
, B.INSTALL_SITE_USE_ID
, B.CUSTOMER_PRODUCT_ID
, B.INVENTORY_ITEM_ID
, B.CURRENT_SERIAL_NUMBER
, B.INV_ORGANIZATION_ID
, CSM_UTIL_PKG.ITEM_NAME(MSIK.CONCATENATED_SEGMENTS)
, MSIK.DESCRIPTION
, B.PROBLEM_CODE
, B.RESOLUTION_CODE
, B.CONTRACT_SERVICE_ID
, B.INV_ITEM_REVISION
, B.CUSTOMER_PO_NUMBER
, B.CREDIT_CARD_NUMBER
, B.CREDIT_CARD_TYPE_CODE
, B.CREDIT_CARD_EXPIRATION_DATE
, B.CREDIT_CARD_HOLDER_FNAME
, B.CREDIT_CARD_HOLDER_MNAME
, B.CREDIT_CARD_HOLDER_LNAME
, B.INCIDENT_ATTRIBUTE_1
, B.INCIDENT_ATTRIBUTE_2
, B.INCIDENT_ATTRIBUTE_3
, B.INCIDENT_ATTRIBUTE_4
, B.INCIDENT_ATTRIBUTE_5
, B.INCIDENT_ATTRIBUTE_6
, B.INCIDENT_ATTRIBUTE_7
, B.INCIDENT_ATTRIBUTE_8
, B.INCIDENT_ATTRIBUTE_9
, B.INCIDENT_ATTRIBUTE_10
, B.INCIDENT_ATTRIBUTE_11
, B.INCIDENT_ATTRIBUTE_12
, B.INCIDENT_ATTRIBUTE_13
, B.INCIDENT_ATTRIBUTE_14
, B.INCIDENT_ATTRIBUTE_15
, B.INCIDENT_CONTEXT
, CSM_UTIL_PKG.GET_DATE(B.LAST_UPDATE_DATE)
, CSM_UTIL_PKG.GET_NUMBER(B.CREATED_BY)
, B.INSTALL_SITE_ID
, NVL(B.INCIDENT_LOCATION_ID
, B.INSTALL_SITE_ID) AS INCIDENT_LOCATION_ID
, B.INCIDENT_LOCATION_TYPE
, B.INCIDENT_OCCURRED_DATE
, B.INCIDENT_RESOLVED_DATE
, B.INC_RESPONDED_BY_DATE
, B.OBLIGATION_DATE
, B.EXPECTED_RESOLUTION_DATE
, B.EXTERNAL_ATTRIBUTE_1
, B.EXTERNAL_ATTRIBUTE_2
, B.EXTERNAL_ATTRIBUTE_3
, B.EXTERNAL_ATTRIBUTE_4
, B.EXTERNAL_ATTRIBUTE_5
, B.EXTERNAL_ATTRIBUTE_6
, B.EXTERNAL_ATTRIBUTE_7
, B.EXTERNAL_ATTRIBUTE_8
, B.EXTERNAL_ATTRIBUTE_9
, B.EXTERNAL_ATTRIBUTE_10
, B.EXTERNAL_ATTRIBUTE_11
, B.EXTERNAL_ATTRIBUTE_12
, B.EXTERNAL_ATTRIBUTE_13
, B.EXTERNAL_ATTRIBUTE_14
, B.EXTERNAL_ATTRIBUTE_15
, B.EXTERNAL_CONTEXT
, NVL(B.OBJECT_VERSION_NUMBER
, B.OBJECT_VERSION_NUMBER)
, B.CREDIT_CARD_ID
, TL.RESOLUTION_SUMMARY
, B.CUSTOMER_TICKET_NUMBER
, B.PROJECT_NUMBER
, B.INCIDENT_OWNER_ID
, B.TIME_ZONE_ID
, B.TIME_DIFFERENCE
, B.CUST_PREF_LANG_ID
, B. CUST_PREF_LANG_CODE
, B.EXTERNAL_REFERENCE
, B.ACCOUNT_ID
, B.OWNER_GROUP_ID
, CSM_UTIL_PKG.GET_NUMBER(B.LAST_UPDATED_BY)
, CSM_UTIL_PKG.GET_GROUP_NAME(B.OWNER_GROUP_ID
, ASG_BASE.GET_LANGUAGE) AS OWNER_GROUP_NAME
, CSM_UTIL_PKG.GET_DATE(B.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE
FROM CSM_INCIDENTS_ALL_ACC A
, CS_INCIDENTS_ALL_B B
, CS_INCIDENTS_ALL_TL TL
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE A.INCIDENT_ID = B.INCIDENT_ID
AND B.INCIDENT_ID = TL.INCIDENT_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND A.USER_ID = ASG_BASE.GET_USER_ID
AND B.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID (+)
AND B.INV_ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)