APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ENI_OLTP_ITEM_STAR

Line 1060: eni_oltp_item_star item

1056: CURSOR Dangling_Items IS
1057: SELECT distinct s.sr_inventory_item_id, s.organization_id
1058: FROM isc_dbi_supplies_f s,
1059: isc_dbi_tmp_plans tmp,
1060: eni_oltp_item_star item
1061: WHERE s.plan_id = tmp.plan_id
1062: AND s.sr_inventory_item_id = item.inventory_item_id(+)
1063: AND s.organization_id = item.organization_id(+)
1064: AND item.inventory_item_id IS NULL

Line 1069: eni_oltp_item_star item

1065: UNION
1066: SELECT distinct d.sr_inventory_item_id, d.organization_id
1067: FROM isc_dbi_demands_f d,
1068: isc_dbi_tmp_plans tmp,
1069: eni_oltp_item_star item
1070: WHERE d.plan_id = tmp.plan_id
1071: AND d.sr_inventory_item_id = item.inventory_item_id(+)
1072: AND d.organization_id = item.organization_id(+)
1073: AND item.inventory_item_id IS NULL

Line 1078: eni_oltp_item_star item

1074: UNION
1075: SELECT distinct d.sr_inventory_item_id, d.organization_id
1076: FROM isc_dbi_inv_detail_f d,
1077: isc_dbi_tmp_plans tmp,
1078: eni_oltp_item_star item
1079: WHERE d.plan_id = tmp.plan_id
1080: AND d.sr_inventory_item_id = item.inventory_item_id(+)
1081: AND d.organization_id = item.organization_id(+)
1082: AND item.inventory_item_id IS NULL;