VIEW: APPS.CS_NEW_INCIDENTS_V

Source

View Text - Preformatted

SELECT INC.incident_id, INC.problem_code, INC.resolution_code, INC.customer_product_id, INC.inv_organization_id, INC.cp_component_id, INC.cp_subcomponent_id, INC.inventory_item_id, INC.inv_component_id, INC.inv_component_version, INC.inv_subcomponent_id, INC.inv_subcomponent_version, INC.current_serial_number current_serial_number_nv, INC.platform_id, INC.platform_version_id, STATUS.name status_code, TYPE.name incident_type, SEV.name severity, URGENCY.name urgency, OWN.resource_name owner, PARTY.party_name company_name, ACCOUNT.account_number account, INC.customer_id, INC.customer_ticket_number, SR_PARTY.sub_first_name person_first_name, SR_PARTY.sub_last_name person_last_name, INC.incident_date, INC.close_date date_closed, KFV.CONCATENATED_SEGMENTS PRODUCT_NAME, KFV.DESCRIPTION PRODUCT_DESCRIPTION, TL.SUMMARY FROM cs_incidents_all_b INC, CS_INCIDENT_STATUSES_VL STATUS, CS_INCIDENT_TYPES_VL TYPE, CS_INCIDENT_SEVERITIES_VL SEV, CS_INCIDENT_URGENCIES_VL URGENCY, CS_SR_OWNERS_V OWN, JTF_PARTIES_ALL_V PARTY, JTF_CUST_ACCOUNTS_ALL_V ACCOUNT, CS_HZ_SR_CONTACT_POINTS SR_CONT, CSC_HZ_PARTIES_SELF_V SR_PARTY, MTL_SYSTEM_ITEMS_KFV KFV, CS_INCIDENTS_ALL_TL TL WHERE INC.INCIDENT_ID = TL.INCIDENT_ID AND TL.LANGUAGE = userenv('LANG') AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID (+) AND INC.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID AND INC.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID (+) AND KFV.ORGANIZATION_ID (+) = CS_STD.Get_Item_Valdn_Orgzn_Id AND INC.INCIDENT_OWNER_ID = OWN.RESOURCE_ID(+) AND INC.RESOURCE_TYPE = OWN.RESOURCE_TYPE(+) AND INC.CUSTOMER_ID = PARTY.PARTY_ID (+) AND INC.ACCOUNT_ID = ACCOUNT.CUST_ACCOUNT_ID (+) AND SR_CONT.INCIDENT_ID (+) = INC.INCIDENT_ID AND SR_CONT.PARTY_ID = SR_PARTY.PARTY_ID (+) AND SR_CONT.PRIMARY_FLAG (+) = 'Y'

View Text - HTML Formatted

SELECT INC.INCIDENT_ID
, INC.PROBLEM_CODE
, INC.RESOLUTION_CODE
, INC.CUSTOMER_PRODUCT_ID
, INC.INV_ORGANIZATION_ID
, INC.CP_COMPONENT_ID
, INC.CP_SUBCOMPONENT_ID
, INC.INVENTORY_ITEM_ID
, INC.INV_COMPONENT_ID
, INC.INV_COMPONENT_VERSION
, INC.INV_SUBCOMPONENT_ID
, INC.INV_SUBCOMPONENT_VERSION
, INC.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER_NV
, INC.PLATFORM_ID
, INC.PLATFORM_VERSION_ID
, STATUS.NAME STATUS_CODE
, TYPE.NAME INCIDENT_TYPE
, SEV.NAME SEVERITY
, URGENCY.NAME URGENCY
, OWN.RESOURCE_NAME OWNER
, PARTY.PARTY_NAME COMPANY_NAME
, ACCOUNT.ACCOUNT_NUMBER ACCOUNT
, INC.CUSTOMER_ID
, INC.CUSTOMER_TICKET_NUMBER
, SR_PARTY.SUB_FIRST_NAME PERSON_FIRST_NAME
, SR_PARTY.SUB_LAST_NAME PERSON_LAST_NAME
, INC.INCIDENT_DATE
, INC.CLOSE_DATE DATE_CLOSED
, KFV.CONCATENATED_SEGMENTS PRODUCT_NAME
, KFV.DESCRIPTION PRODUCT_DESCRIPTION
, TL.SUMMARY
FROM CS_INCIDENTS_ALL_B INC
, CS_INCIDENT_STATUSES_VL STATUS
, CS_INCIDENT_TYPES_VL TYPE
, CS_INCIDENT_SEVERITIES_VL SEV
, CS_INCIDENT_URGENCIES_VL URGENCY
, CS_SR_OWNERS_V OWN
, JTF_PARTIES_ALL_V PARTY
, JTF_CUST_ACCOUNTS_ALL_V ACCOUNT
, CS_HZ_SR_CONTACT_POINTS SR_CONT
, CSC_HZ_PARTIES_SELF_V SR_PARTY
, MTL_SYSTEM_ITEMS_KFV KFV
, CS_INCIDENTS_ALL_TL TL
WHERE INC.INCIDENT_ID = TL.INCIDENT_ID
AND TL.LANGUAGE = USERENV('LANG')
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND INC.INCIDENT_STATUS_ID = STATUS.INCIDENT_STATUS_ID
AND INC.INCIDENT_URGENCY_ID = URGENCY.INCIDENT_URGENCY_ID (+)
AND INC.INCIDENT_SEVERITY_ID = SEV.INCIDENT_SEVERITY_ID
AND INC.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID (+)
AND KFV.ORGANIZATION_ID (+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND INC.INCIDENT_OWNER_ID = OWN.RESOURCE_ID(+)
AND INC.RESOURCE_TYPE = OWN.RESOURCE_TYPE(+)
AND INC.CUSTOMER_ID = PARTY.PARTY_ID (+)
AND INC.ACCOUNT_ID = ACCOUNT.CUST_ACCOUNT_ID (+)
AND SR_CONT.INCIDENT_ID (+) = INC.INCIDENT_ID
AND SR_CONT.PARTY_ID = SR_PARTY.PARTY_ID (+)
AND SR_CONT.PRIMARY_FLAG (+) = 'Y'