VIEW: APPS.CSL_CS_INCIDENTS_ALL_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.INCIDENT_ID , B.OBJECT_VERSION_NUMBER , B.CALLER_TYPE , B.INCIDENT_NUMBER , B.INCIDENT_SEVERITY_ID , B.INCIDENT_STATUS_ID , B.INCIDENT_TYPE_ID , B.INCIDENT_URGENCY_ID , B.INCIDENT_DATE , TL.SUMMARY , B.ORG_ID , B.CUSTOMER_ID , B.INSTALL_SITE_USE_ID , B.CUSTOMER_PRODUCT_ID , B.INVENTORY_ITEM_ID , B.INV_ORGANIZATION_ID , B.PROBLEM_CODE , B.RESOLUTION_CODE , B.CONTRACT_SERVICE_ID , B.CURRENT_SERIAL_NUMBER , B.INV_ITEM_REVISION , TL.LANGUAGE , 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 , B.CUSTOMER_PO_NUMBER , B.LAST_UPDATE_DATE , 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.CREDIT_CARD_ID , B.INSTALL_SITE_ID , B.OBLIGATION_DATE , B.EXPECTED_RESOLUTION_DATE , B.INCIDENT_LOCATION_ID , B.INCIDENT_ADDRESS , B.INCIDENT_CITY , B.INCIDENT_STATE , B.INCIDENT_COUNTRY , B.INCIDENT_PROVINCE , B.INCIDENT_POSTAL_CODE , B.INCIDENT_COUNTY , B.INCIDENT_LOCATION_TYPE , MSIK.CONCATENATED_SEGMENTS , MSIK.DESCRIPTION ITEM_DESCRIPTION , EXTERNAL_ATTRIBUTE_1 , EXTERNAL_ATTRIBUTE_2 , EXTERNAL_ATTRIBUTE_3 , EXTERNAL_ATTRIBUTE_4 , EXTERNAL_ATTRIBUTE_5 , EXTERNAL_ATTRIBUTE_6 , EXTERNAL_ATTRIBUTE_7 , EXTERNAL_ATTRIBUTE_8 , EXTERNAL_ATTRIBUTE_9 , EXTERNAL_ATTRIBUTE_10 , EXTERNAL_ATTRIBUTE_11 , EXTERNAL_ATTRIBUTE_12 , EXTERNAL_ATTRIBUTE_13 , EXTERNAL_ATTRIBUTE_14 , EXTERNAL_ATTRIBUTE_15 , EXTERNAL_CONTEXT FROM CSL_CS_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.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID AND B.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID (+) AND B.INV_ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.INCIDENT_ID
, B.OBJECT_VERSION_NUMBER
, B.CALLER_TYPE
, B.INCIDENT_NUMBER
, B.INCIDENT_SEVERITY_ID
, B.INCIDENT_STATUS_ID
, B.INCIDENT_TYPE_ID
, B.INCIDENT_URGENCY_ID
, B.INCIDENT_DATE
, TL.SUMMARY
, B.ORG_ID
, B.CUSTOMER_ID
, B.INSTALL_SITE_USE_ID
, B.CUSTOMER_PRODUCT_ID
, B.INVENTORY_ITEM_ID
, B.INV_ORGANIZATION_ID
, B.PROBLEM_CODE
, B.RESOLUTION_CODE
, B.CONTRACT_SERVICE_ID
, B.CURRENT_SERIAL_NUMBER
, B.INV_ITEM_REVISION
, TL.LANGUAGE
, 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
, B.CUSTOMER_PO_NUMBER
, B.LAST_UPDATE_DATE
, 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.CREDIT_CARD_ID
, B.INSTALL_SITE_ID
, B.OBLIGATION_DATE
, B.EXPECTED_RESOLUTION_DATE
, B.INCIDENT_LOCATION_ID
, B.INCIDENT_ADDRESS
, B.INCIDENT_CITY
, B.INCIDENT_STATE
, B.INCIDENT_COUNTRY
, B.INCIDENT_PROVINCE
, B.INCIDENT_POSTAL_CODE
, B.INCIDENT_COUNTY
, B.INCIDENT_LOCATION_TYPE
, MSIK.CONCATENATED_SEGMENTS
, MSIK.DESCRIPTION ITEM_DESCRIPTION
, EXTERNAL_ATTRIBUTE_1
, EXTERNAL_ATTRIBUTE_2
, EXTERNAL_ATTRIBUTE_3
, EXTERNAL_ATTRIBUTE_4
, EXTERNAL_ATTRIBUTE_5
, EXTERNAL_ATTRIBUTE_6
, EXTERNAL_ATTRIBUTE_7
, EXTERNAL_ATTRIBUTE_8
, EXTERNAL_ATTRIBUTE_9
, EXTERNAL_ATTRIBUTE_10
, EXTERNAL_ATTRIBUTE_11
, EXTERNAL_ATTRIBUTE_12
, EXTERNAL_ATTRIBUTE_13
, EXTERNAL_ATTRIBUTE_14
, EXTERNAL_ATTRIBUTE_15
, EXTERNAL_CONTEXT
FROM CSL_CS_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.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
AND B.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID (+)
AND B.INV_ORGANIZATION_ID = MSIK.ORGANIZATION_ID (+)