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_SHORTFALL_SNAPSHOTS

Line 28: 'ISC_DBI_RES_SUM_SNAPSHOTS', 'ISC_DBI_SHORTFALL_SNAPSHOTS');

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');
29:
30: FUNCTION DROP_PLANS(p_plan_id NUMBER) RETURN NUMBER IS
31:
32: l_delete_stmt VARCHAR2(2000);

Line 1677: -- Collect ISC_DBI_SHORTFALL_SNAPSHOTS

1673: -- COMMIT;
1674:
1675:
1676: -- ----------------------------------------
1677: -- Collect ISC_DBI_SHORTFALL_SNAPSHOTS
1678: --
1679: -- Reason Type: -1 - Unassigned
1680: -- 0 - On-time Demands
1681: -- 1 - Item Related

Line 1687: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for unconstrained plans.');

1683: -- 3 - Transportation Related
1684: -- ----------------------------------------
1685:
1686: BIS_COLLECTION_UTILITIES.put_line(' ');
1687: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for unconstrained plans.');
1688: FII_UTIL.Start_Timer;
1689:
1690: INSERT
1691: INTO isc_dbi_shortfall_snapshots F(

Line 1691: INTO isc_dbi_shortfall_snapshots F(

1687: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for unconstrained plans.');
1688: FII_UTIL.Start_Timer;
1689:
1690: INSERT
1691: INTO isc_dbi_shortfall_snapshots F(
1692: SNAPSHOT_ID,
1693: ORGANIZATION_ID,
1694: START_DATE,
1695: PERIOD_TYPE_ID,

Line 1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');

1788: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,
1789: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1790:
1791: FII_UTIL.Stop_Timer;
1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1793:
1794: BIS_COLLECTION_UTILITIES.put_line(' ');
1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');
1796: FII_UTIL.Start_Timer;

Line 1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');

1791: FII_UTIL.Stop_Timer;
1792: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1793:
1794: BIS_COLLECTION_UTILITIES.put_line(' ');
1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');
1796: FII_UTIL.Start_Timer;
1797:
1798: INSERT
1799: INTO isc_dbi_shortfall_snapshots F(

Line 1799: INTO isc_dbi_shortfall_snapshots F(

1795: BIS_COLLECTION_UTILITIES.put_line('Begin to insert data into isc_dbi_shortfall_snapshots for constrained plans.');
1796: FII_UTIL.Start_Timer;
1797:
1798: INSERT
1799: INTO isc_dbi_shortfall_snapshots F(
1800: SNAPSHOT_ID,
1801: ORGANIZATION_ID,
1802: START_DATE,
1803: PERIOD_TYPE_ID,

Line 1908: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');

1904: f.r_item_id, f.r_supplier_id, f.r_supplier_site_id, f.r_resource_id, f.r_org_id, f.r_department_id,
1905: grouping sets(ent_year_start_date, ent_qtr_start_date, ent_period_start_date);
1906:
1907: FII_UTIL.Stop_Timer;
1908: FII_UTIL.Print_Timer('Inserted '|| sql%rowcount ||' rows into isc_dbi_shortfall_snapshots in');
1909: -- COMMIT;
1910:
1911: -- ------------------------------------
1912: -- Collect ISC_DBI_INV_DETAIL_SNAPSHOTS

Line 2028: isc_dbi_shortfall_snapshots sh

2024: 0 PRODUCTION_COST, 0 PRODUCTION_COST_G, 0 PRODUCTION_COST_G1, 0 PURCHASING_COST, 0 PURCHASING_COST_G, 0 PURCHASING_COST_G1, late_lines_temp LATE_LINES,
2025: sh.rev_shortfall REV_SHORTFALL, sh.rev_shortfall_G REV_SHORTFALL_G, sh.rev_shortfall_G1 REV_SHORTFALL_G1, total_lines_temp TOTAL_LINES,
2026: 1 UNION1_FLAG, 1 UNION2_FLAG
2027: FROM isc_dbi_tmp_plans tmp,
2028: isc_dbi_shortfall_snapshots sh
2029: WHERE tmp.snapshot_id = sh.snapshot_id
2030: AND bitand(tmp.plan_usage, 2) = 2)
2031: GROUP BY snapshot_id, organization_id, sr_inventory_item_id, start_date, period_type_id, uom_code;
2032: