VIEW: APPS.CS_SR_DUPLICATE_CHECK_V

Source

View Text - Preformatted

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 NVL(stat.dup_chk_flag,'N')='Y' AND INC.CUSTOMER_ID = PARTY.PARTY_ID

View Text - HTML Formatted

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 NVL(STAT.DUP_CHK_FLAG
, 'N')='Y'
AND INC.CUSTOMER_ID = PARTY.PARTY_ID