[Home] [Help]
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
Name |
INCIDENT_ID |
SUMMARY |
STATUS |
INCIDENT_NUMBER |
CREATION_DATE |
TYPE |
PROBLEM_CODE |
PARTY_NAME |
CUSTOMER_PRODUCT_ID |
INVENTORY_ITEM_ID |
MAINTENANCE_FLAG |
INV_ORGANIZATION_ID |