DBA Data[Home] [Help]

APPS.CSL_CSI_ITEM_INSTANCES_ACC_PKG dependencies on CS_INCIDENTS_ALL_B

Line 1574: FROM CS_INCIDENTS_ALL_B inc

1570: AND ii.INSTANCE_STATUS_ID = iis.INSTANCE_STATUS_ID
1571: AND NVL(iis.TERMINATED_FLAG,'N') = 'Y'
1572: AND NOT EXISTS
1573: ( SELECT null
1574: FROM CS_INCIDENTS_ALL_B inc
1575: , CSL_CS_INCIDENTS_ALL_ACC inac
1576: WHERE inc.incident_id = inac.incident_id
1577: AND inc.customer_product_id = iiac.instance_id
1578: AND inac.resource_id = iiac.resource_id