APPS.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on ENI_OLTP_ITEM_STAR

Line 1568: eni_oltp_item_star item

1564:
1565: CURSOR Dangling_Items_Init IS
1566: SELECT /*+ PARALLEL(tmp) PARALLEL(item) */ distinct tmp.inventory_item_id, tmp.organization_id
1567: FROM isc_dbi_tmp_del_details tmp,
1568: eni_oltp_item_star item
1569: WHERE tmp.inventory_item_id = item.inventory_item_id(+)
1570: AND tmp.organization_id = item.organization_id(+)
1571: AND item.inventory_item_id IS NULL
1572: AND tmp.inventory_item_id IS NOT NULL;

Line 1577: eni_oltp_item_star item

1573:
1574: CURSOR Dangling_Items_Incre IS
1575: SELECT distinct tmp.inventory_item_id, tmp.organization_id
1576: FROM isc_dbi_tmp_del_details tmp,
1577: eni_oltp_item_star item
1578: WHERE tmp.inventory_item_id = item.inventory_item_id(+)
1579: AND tmp.organization_id = item.organization_id(+)
1580: AND item.inventory_item_id IS NULL
1581: AND tmp.inventory_item_id IS NOT NULL;