View: EAM_SERVICE_REQUEST_DETAILS_V

Product:	EAM - Enterprise Asset Management
Description:	View for service request details
Implementation/DBA Data:	APPS.EAM_SERVICE_REQUEST_DETAILS_V

View Text

SELECT CIA.INCIDENT_ID
, CIA.INCIDENT_NUMBER
, CIA.INCIDENT_STATUS_ID
, CIS.NAME STATUS
, CIA.INCIDENT_SEVERITY_ID
, CISE.NAME SEVERITY
, CIA.ORG_ID
, CIA.INV_ORGANIZATION_ID
, CIA.INVENTORY_ITEM_ID
, CIA.ORG_ID AS OPERATING_UNIT
, MSIBKFV.CONCATENATED_SEGMENTS AS ITEM_NAME
, CIA.CREATION_DATE AS REQUEST_DATE
, CIA.EXPECTED_RESOLUTION_DATE AS REQUEST_BY_DATE
, CIA.SUMMARY
, BD.DEPARTMENT_CODE AS DEPARTMENT
, CIA.OWNING_DEPARTMENT_ID
, CIA.STATUS_FLAG
, NVL(TYPE.MAINTENANCE_FLAG
, 'N') MAINTENANCE_FLAG
, CIA.MAINT_ORGANIZATION_ID
, TO_NUMBER(DECODE(CIA.CUSTOMER_PRODUCT_ID
, NULL
, (DECODE(CIA.INVENTORY_ITEM_ID
, NULL
, NULL
, 2))
, 3))
, NVL(CIA.CUSTOMER_PRODUCT_ID
, CIA.INVENTORY_ITEM_ID)
, CII.INSTANCE_NUMBER
FROM CS_INCIDENTS_VL_SEC CIA
, CS_INCIDENT_STATUSES_B CIS
, CS_INCIDENT_SEVERITIES_B CISE
, BOM_DEPARTMENTS BD
, CS_INCIDENT_TYPES_VL_SEC TYPE
, MTL_SYSTEM_ITEMS_B_KFV MSIBKFV
, CSI_ITEM_INSTANCES CII
WHERE CIA.OWNING_DEPARTMENT_ID = BD.DEPARTMENT_ID(+)
AND CIA.MAINT_ORGANIZATION_ID = BD.ORGANIZATION_ID (+)
AND CIA.INCIDENT_STATUS_ID = CIS.INCIDENT_STATUS_ID
AND CIA.INCIDENT_SEVERITY_ID = CISE.INCIDENT_SEVERITY_ID
AND CIA.INCIDENT_TYPE_ID = TYPE.INCIDENT_TYPE_ID
AND CIA.INVENTORY_ITEM_ID = MSIBKFV.INVENTORY_ITEM_ID(+)
AND CIA.INV_ORGANIZATION_ID = MSIBKFV.ORGANIZATION_ID(+)
AND CIA.CUSTOMER_PRODUCT_ID = CII.INSTANCE_ID(+)

Columns