APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_DEMANDS_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 486: 'INTO isc_dbi_demands_f (PLAN_ID,ORGANIZATION_ID,SR_INVENTORY_ITEM_ID,'||

482: 'department_id, resource_id, sr_supplier_id, '||
483: 'exception_detail_id,exception_type,number1,number2,sr_supplier_site_id, '||
484: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
485: 'WHEN union_flag = 8 THEN '||
486: 'INTO isc_dbi_demands_f (PLAN_ID,ORGANIZATION_ID,SR_INVENTORY_ITEM_ID,'||
487: 'DEMAND_ID,TIME_AS_DMD_COMP_DATE,TIME_DMD_DATE_ID,TIME_USING_AS_DMD_DATE,ASSEMBLY_DEMAND_COMP_DATE,'||
488: 'ORIGINATION_TYPE,UOM_CODE,USING_ASSEMBLY_DEMAND_DATE,'||
489: 'AVERAGE_DISCOUNT,LIST_PRICE,SELLING_PRICE,STANDARD_COST,USING_REQUIREMENT_QUANTITY,'||
490: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||

Line 1067: FROM isc_dbi_demands_f d,

1063: AND s.organization_id = item.organization_id(+)
1064: AND item.inventory_item_id IS NULL
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(+)

Line 1762: isc_dbi_demands_f id,

1758: sum(decode(reason.reason_type, null, 0, 1)) over (partition by tmp.snapshot_id, id.demand_id) REASON_CNT,
1759: avg(decode(reason.reason_type, null, 0, 1)) LATE_LINES,
1760: id.uom_code
1761: FROM isc_dbi_tmp_plans tmp,
1762: isc_dbi_demands_f id,
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

Line 1870: isc_dbi_demands_f id,

1866: sum(decode(iex.number1, null, 0, 1)) over (partition by tmp.snapshot_id, id.demand_id) REASON_CNT,
1867: avg(CASE WHEN iex.late_lines >= 1 THEN 1 ELSE 0 END) LATE_LINES,
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,