DBA Data[Home] [Help]

APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on ENI_OLTP_ITEM_STAR

Line 1240: eni_oltp_item_star item

1236:
1237: CURSOR Dangling_Items_Init IS
1238: SELECT /*+ PARALLEL(tmp) PARALLEL(item) */ distinct tmp.inventory_item_id, tmp.item_inv_org_id
1239: FROM isc_tmp_book_sum2 tmp,
1240: eni_oltp_item_star item
1241: WHERE tmp.inventory_item_id = item.inventory_item_id(+)
1242: AND tmp.item_inv_org_id = item.organization_id(+)
1243: AND item.organization_id IS NULL;
1244:

Line 1248: eni_oltp_item_star item

1244:
1245: CURSOR Dangling_Items_Incre IS
1246: SELECT distinct tmp.inventory_item_id, tmp.item_inv_org_id
1247: FROM isc_tmp_book_sum2 tmp,
1248: eni_oltp_item_star item
1249: WHERE tmp.inventory_item_id = item.inventory_item_id(+)
1250: AND tmp.item_inv_org_id = item.organization_id(+)
1251: AND item.organization_id IS NULL;
1252: