View: CS_SR_DUPLICATE_CHECK_V

Product:	CS - Service
Description:	This view will be used as the base view for the duplicate check window in SR and SR tab
Implementation/DBA Data:	APPS.CS_SR_DUPLICATE_CHECK_V

View Text

SELECT INC.INCIDENT_ID
, INC.SUMMARY
, STAT.NAME STATUS
, INC.INCIDENT_NUMBER
, INC.CREATION_DATE
, TYPE.NAME TYPE
, INC.PROBLEM_CODE
, PARTY.PARTY_NAME
, INC.CUSTOMER_PRODUCT_ID
, INC.INVENTORY_ITEM_ID
, TYPE.MAINTENANCE_FLAG
, INC.INV_ORGANIZATION_ID
FROM CS_INCIDENTS_ALL_VL INC
, CS_INCIDENT_STATUSES_VL STAT
, CS_INCIDENT_TYPES_VL TYPE
, HZ_PARTIES PARTY
WHERE INC.INCIDENT_STATUS_ID = STAT.INCIDENT_STATUS_ID
AND INC.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND INC.CUSTOMER_ID = PARTY.PARTY_ID

Columns