APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 307: l_stmt := l_stmt || ' cs_incidents_all_b sr ';

303: l_stmt := l_stmt || ' AND acc.inventory_item_id = itemcat.inventory_item_id) ';
304: l_stmt := l_stmt || ' AND NOT EXISTS ';
305: l_stmt := l_stmt || ' (SELECT 1';
306: l_stmt := l_stmt || ' FROM csm_incidents_all_acc sr_acc, ';
307: l_stmt := l_stmt || ' cs_incidents_all_b sr ';
308: l_stmt := l_stmt || ' WHERE sr_acc.incident_id = sr.incident_id ';
309: l_stmt := l_stmt || ' AND sr_acc.user_id = :4 ';
310: l_stmt := l_stmt || ' AND acc.inventory_item_id = sr.inventory_item_id )';
311:

Line 1184: from csm_incidents_all_acc inc_a,cs_incidents_all_b inc

1180: and acc.user_id=au.user_id
1181: and ii.inventory_item_id=a.inventory_item_id
1182: and a.organization_id=NVL(ii.inv_organization_id,ii.LAST_VLD_ORGANIZATION_ID)) --sr instance and its children/parent
1183: and not exists(select 1
1184: from csm_incidents_all_acc inc_a,cs_incidents_all_b inc
1185: where inc_a.incident_id=inc.incident_id
1186: and inc_a.user_id=au.user_id
1187: and NVL(inc.customer_product_id,0)=0
1188: and inc.inventory_item_id=a.inventory_item_id