View: CS_SR_SEARCH_NO_CONT_V

Product:	CS - Service
Description:	This view is used in the SR find window on Bali spread table and in the Service History Bali Spreadtable of SR Tab
Implementation/DBA Data:	APPS.CS_SR_SEARCH_NO_CONT_V

View Text

SELECT INC.ROWID ROW_ID
, INC.INCIDENT_ID
, INC.ORG_ID
, INC.LAST_UPDATE_DATE
, INC.LAST_UPDATED_BY
, INC.CREATION_DATE
, INC.CREATED_BY
, INC.LAST_UPDATE_LOGIN
, INC.INCIDENT_NUMBER
, INC.INCIDENT_NUMBER INCIDENT_NUMBER_N
, INC.INCIDENT_STATUS_ID
, INC.INCIDENT_TYPE_ID
, INC.INCIDENT_URGENCY_ID
, INC.INCIDENT_SEVERITY_ID
, TL.SUMMARY
, INC.INCIDENT_OWNER_ID
, INC.RESOURCE_TYPE
, INC.RESOURCE_SUBTYPE_ID
, INC.INVENTORY_ITEM_ID
, INC.SHIP_TO_SITE_USE_ID
, INC.SHIP_TO_CONTACT_ID
, INC.BILL_TO_SITE_USE_ID
, INC.BILL_TO_CONTACT_ID
, INC.INSTALL_SITE_USE_ID
, INC.PROBLEM_CODE
, INC.EXPECTED_RESOLUTION_DATE
, INC.ACTUAL_RESOLUTION_DATE
, INC.INCIDENT_DATE
, INC.CUSTOMER_PRODUCT_ID
, INC.RESOLUTION_CODE
, (SELECT TYPE.NAME
FROM CS_INCIDENT_TYPES_TL TYPE
WHERE TYPE.INCIDENT_TYPE_ID = INC.INCIDENT_TYPE_ID
AND TYPE.LANGUAGE = USERENV('LANG')) INCIDENT_TYPE
, (SELECT SEV.NAME
FROM CS_INCIDENT_SEVERITIES_TL SEV
WHERE SEV.INCIDENT_SEVERITY_ID = INC.INCIDENT_SEVERITY_ID
AND SEV.LANGUAGE = USERENV('LANG')) SEVERITY
, (SELECT STATUS.NAME
FROM CS_INCIDENT_STATUSES_TL STATUS
WHERE STATUS.INCIDENT_STATUS_ID = INC.INCIDENT_STATUS_ID
AND STATUS.LANGUAGE = USERENV('LANG') ) STATUS_CODE
, (SELECT URGENCY.NAME
FROM CS_INCIDENT_URGENCIES_TL URGENCY
WHERE URGENCY.INCIDENT_URGENCY_ID = INC.INCIDENT_URGENCY_ID
AND URGENCY.LANGUAGE(+) = USERENV('LANG')) URGENCY
, INC.CUSTOMER_ID
, INC.ACCOUNT_ID
, INC.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER_NV
, INC.PURCHASE_ORDER_NUM
, INC.ORIGINAL_ORDER_NUMBER
, INC.WORKFLOW_PROCESS_ID
, INC.CLOSE_DATE DATE_CLOSED
, INC.PUBLISH_FLAG
, INC.CONTRACT_SERVICE_ID
, INC.TIME_ZONE_ID
, INC.CUSTOMER_PO_NUMBER
, INC.CUSTOMER_TICKET_NUMBER
, INC.OBLIGATION_DATE
, INC.SITE_ID
, INC.CUSTOMER_SITE_ID
, (SELECT MEANING
FROM CS_LOOKUPS
WHERE LOOKUP_TYPE = 'CS_SR_CREATION_CHANNEL'
AND LOOKUP_CODE(+) =INC.SR_CREATION_CHANNEL ) SR_CREATION_CHANNEL_MEANING
, INC.SR_CREATION_CHANNEL
, INC.PLATFORM_VERSION_ID
, PARTY.PARTY_NUMBER CUSTOMER_NUMBER
, INC.CALLER_TYPE
, INC.CP_COMPONENT_ID
, INC.CP_COMPONENT_VERSION_ID
, INC.CP_SUBCOMPONENT_ID
, INC.CP_SUBCOMPONENT_VERSION_ID
, INC.CP_REVISION_ID
, INC.INV_ITEM_REVISION
, INC.INV_COMPONENT_ID
, INC.INV_COMPONENT_VERSION
, INC.INV_SUBCOMPONENT_ID
, INC.INV_SUBCOMPONENT_VERSION
, INC.PLATFORM_ID
, INC.LANGUAGE_ID
, INC.TERRITORY_ID
, INC.TIME_DIFFERENCE
, INC.INV_ORGANIZATION_ID
, KFV.CONCATENATED_SEGMENTS PRODUCT_NAME
, KFV.DESCRIPTION PRODUCT_DESCRIPTION
, PARTY.PARTY_NAME COMPANY_NAME
, (SELECT ACCOUNT.ACCOUNT_NUMBER
FROM HZ_CUST_ACCOUNTS ACCOUNT
WHERE ACCOUNT.CUST_ACCOUNT_ID = INC.ACCOUNT_ID) ACCOUNT
, INC.OBJECT_VERSION_NUMBER
, (SELECT LOOK5.MEANING
FROM CS_LOOKUPS LOOK5
WHERE LOOK5.LOOKUP_TYPE = 'CS_SR_CALLER_TYPE'
AND LOOK5.LOOKUP_CODE = INC.CALLER_TYPE ) CALLER_TYPE_NAME
, (SELECT LOOK5.DESCRIPTION
FROM CS_LOOKUPS LOOK5
WHERE LOOK5.LOOKUP_TYPE = 'CS_SR_CALLER_TYPE'
AND LOOK5.LOOKUP_CODE = INC.CALLER_TYPE ) CALLER_TYPE_DESCRIPTION
, (SELECT HZ_TIME.GLOBAL_TIMEZONE_NAME
FROM HZ_TIMEZONES HZ_TIME
WHERE HZ_TIME.TIMEZONE_ID = INC.TIME_ZONE_ID) TIME_ZONE_NAME
, KFV.ORGANIZATION_ID ORGANIZATION_ID
, PARTY.COUNTRY
, INC.CONTRACT_NUMBER
, INC.CONTRACT_ID
, INC.PROJECT_NUMBER
, INC.GROUP_TYPE
, INC.OWNER_GROUP_ID
, INC.ERROR_CODE
, INC.SYSTEM_ID
, INC.EXTERNAL_REFERENCE
, INC.INCIDENT_OCCURRED_DATE
, INC.CATEGORY_ID
, INC.INCIDENT_ADDRESS
, INC.INCIDENT_LOCATION_ID
, INC.INCIDENT_COUNTRY
, INC.INCIDENT_POSTAL_CODE
, INC.INCIDENT_STATE
, INC.INCIDENT_LOCATION_TYPE
, INC.STATUS_FLAG
, INC.ITEM_SERIAL_NUMBER
, INC.INCIDENT_ADDRESS2
, INC.INCIDENT_ADDRESS3
, INC.INCIDENT_ADDRESS4
, PARTY.KNOWN_AS
, INC.MAINT_ORGANIZATION_ID
, TL.TEXT_INDEX
FROM CS_INCIDENTS_B_SEC INC
, CS_INCIDENTS_ALL_TL TL
, MTL_SYSTEM_ITEMS_KFV KFV
, HZ_PARTIES PARTY
WHERE INC.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID (+)
AND INC.INV_ORGANIZATION_ID = KFV.ORGANIZATION_ID(+)
AND INC.INCIDENT_ID = TL.INCIDENT_ID
AND TL.LANGUAGE = USERENV('LANG')
AND INC.CUSTOMER_ID = PARTY.PARTY_ID (+)

Columns