APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_INV_DETAIL_F

Line 22: g_large_bases TableList := TableList('ISC_DBI_SUPPLIES_F','ISC_DBI_INV_DETAIL_F','ISC_DBI_RES_SUMMARY_F',

18: g_rebuild_snapshot_index VARCHAR2(1) := 'N';
19:
20: TYPE TableList IS TABLE OF VARCHAR2(80);
21: g_small_bases TableList := TableList('ISC_DBI_PLAN_ORGANIZATIONS', 'ISC_DBI_PLAN_BUCKETS', 'ISC_DBI_PLANS');
22: g_large_bases TableList := TableList('ISC_DBI_SUPPLIES_F','ISC_DBI_INV_DETAIL_F','ISC_DBI_RES_SUMMARY_F',
23: 'ISC_DBI_EXCEPTION_DETAILS_F','ISC_DBI_DEMANDS_F',
24: 'ISC_DBI_FULL_PEGGING_F');
25:
26: g_small_snapshots TableList := TableList('ISC_DBI_PLAN_ORG_SNAPSHOTS', 'ISC_DBI_PLAN_SNAPSHOTS');

Line 460: 'INTO isc_dbi_inv_detail_f (PLAN_ID,ORGANIZATION_ID,'||

456: 'new_processing_days,new_schedule_date,order_type,planning_make_buy_code,r_cfm_routing_flag,'||
457: 'standard_cost,uom_code,'||
458: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login ) '||
459: 'WHEN union_flag = 5 THEN '||
460: 'INTO isc_dbi_inv_detail_f (PLAN_ID,ORGANIZATION_ID,'||
461: 'SR_INVENTORY_ITEM_ID,TIME_DETAIL_DATE_ID,CARRYING_COST,DETAIL_DATE,INVENTORY_COST,'||
462: 'MDS_COST,MDS_PRICE,MDS_QUANTITY,PRODUCTION_COST,PURCHASING_COST,UOM_CODE,'||
463: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
464: 'VALUES(plan_id,organization_id,sr_inventory_item_id,time_detail_date_id,carrying_cost,detail_date,'||

Line 1076: FROM isc_dbi_inv_detail_f d,

1072: AND d.organization_id = item.organization_id(+)
1073: AND item.inventory_item_id IS NULL
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(+)

Line 1996: isc_dbi_inv_detail_f iinv,

1992: 0 TOTAL_LINES,
1993: 1 UNION1_FLAG,
1994: 0 UNION2_FLAG
1995: FROM isc_dbi_tmp_plans tmp,
1996: isc_dbi_inv_detail_f iinv,
1997: isc_dbi_periods per,
1998: fii_time_day time1
1999: WHERE tmp.plan_id = iinv.plan_id
2000: AND bitand(tmp.plan_usage, 2) = 2