eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_MSC_OBJECTS_C dependencies on ISC_DBI_FULL_PEGGING_F

Line 24: 'ISC_DBI_FULL_PEGGING_F');

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',
28: 'ISC_DBI_RES_SUM_SNAPSHOTS', 'ISC_DBI_SHORTFALL_SNAPSHOTS');

Line 508: 'INTO isc_dbi_full_pegging_f (PLAN_ID,PEGGING_ID,DEMAND_ID,END_PEGGING_ID,TRANSACTION_ID,'||

504: 'period_type,period_year,period_num,quarter_num,'||
505: 'entered_period_name,adjustment_period_flag,description,'||
506: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
507: 'WHEN union_flag = 10 THEN '||
508: 'INTO isc_dbi_full_pegging_f (PLAN_ID,PEGGING_ID,DEMAND_ID,END_PEGGING_ID,TRANSACTION_ID,'||
509: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
510: 'VALUES(plan_id,pegging_id,demand_id, end_pegging_id, transaction_id,'||
511: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) ';
512:

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 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)