APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_EXCEPTION_DETAILS_F

Line 23: 'ISC_DBI_EXCEPTION_DETAILS_F','ISC_DBI_DEMANDS_F',

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');
27: g_large_snapshots TableList := TableList('ISC_DBI_SUPPLIES_SNAPSHOTS','ISC_DBI_INV_DETAIL_SNAPSHOTS',

Line 476: 'INTO isc_dbi_exception_details_f ('||

472: 'VALUES(plan_id,organization_id,department_id,resource_id,time_resource_date_id,'||
473: 'available_hours,organization_type,required_hours,resource_date,utilization,'||
474: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
475: 'WHEN union_flag = 7 THEN '||
476: 'INTO isc_dbi_exception_details_f ('||
477: 'PLAN_ID,ORGANIZATION_ID,SR_INVENTORY_ITEM_ID,ORGANIZATION_TYPE,'||
478: 'DEPARTMENT_ID, RESOURCE_ID, SR_SUPPLIER_ID, '||
479: 'EXCEPTION_DETAIL_ID,EXCEPTION_TYPE,NUMBER1,NUMBER2,SR_SUPPLIER_SITE_ID,'||
480: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||

Line 1767: FROM isc_dbi_tmp_plans p, isc_dbi_exception_details_f r, isc_dbi_full_pegging_f peg1

1763: (SELECT /*+ ordered */ peg1.plan_id, peg1.demand_id,
1764: r.organization_type, r.sr_inventory_item_id, r.sr_supplier_id, r.sr_supplier_site_id,
1765: r.organization_id, r.resource_id, r.department_id,
1766: decode(r.exception_type, 23, 2, 1) reason_type
1767: FROM isc_dbi_tmp_plans p, isc_dbi_exception_details_f r, isc_dbi_full_pegging_f peg1
1768: WHERE bitand(p.plan_usage, 2) = 2
1769: AND p.plan_id = r.plan_id
1770: AND p.constrained_flag = 2
1771: AND r.exception_type in (15, 16, 23, 42)

Line 1872: FROM isc_dbi_exception_details_f ex

1868: id.uom_code
1869: FROM isc_dbi_tmp_plans tmp,
1870: isc_dbi_demands_f id,
1871: (SELECT plan_id, number1, sum(decode(exception_type, 13, 1, 14, 1, 24, 1, 26, 1, 0)) LATE_LINES
1872: FROM isc_dbi_exception_details_f ex
1873: WHERE ex.exception_type in (13, 14, 24, 26, 52) AND ex.number1 is not null
1874: GROUP BY plan_id, number1) iex,
1875: (SELECT /*+ ordered */ peg1.plan_id, peg.demand_id,
1876: r.organization_type, r.sr_inventory_item_id, r.sr_supplier_id, r.sr_supplier_site_id,

Line 1879: FROM isc_dbi_tmp_plans p, isc_dbi_exception_details_f r, isc_dbi_full_pegging_f peg1, isc_dbi_full_pegging_f peg

1875: (SELECT /*+ ordered */ peg1.plan_id, peg.demand_id,
1876: r.organization_type, r.sr_inventory_item_id, r.sr_supplier_id, r.sr_supplier_site_id,
1877: r.organization_id, r.resource_id, r.department_id,
1878: decode(r.exception_type,36,2,53,2,58,2,60,2,63,2,40,3,55,3,56,3,61,3,1) reason_type
1879: FROM isc_dbi_tmp_plans p, isc_dbi_exception_details_f r, isc_dbi_full_pegging_f peg1, isc_dbi_full_pegging_f peg
1880: WHERE bitand(p.plan_usage, 2) = 2
1881: AND p.constrained_flag = 1
1882: AND p.plan_id = r.plan_id
1883: AND r.exception_type in (9, 36, 37, 40, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 66, 67)