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.MSC_PHUB_PKG dependencies on MSC_DEMANTRA_PKG

Line 29: t(4) := msc_apcc_fact_type(4, 'msc_demantra_pkg', 'demantra_ods', '11.5.10', 'end_date', 4);

25: t.extend(15);
26: t(1) := msc_apcc_fact_type(1, 'msc_supply_pkg', 'supplies', '11.5.10', 'supply_date', 1);
27: t(2) := msc_apcc_fact_type(2, 'msc_demand_pkg', 'demands', '11.5.10', 'order_date', 1);
28: t(3) := msc_apcc_fact_type(3, 'msc_demand_pkg', 'demands_cum', '11.5.10', 'order_date', 1);
29: t(4) := msc_apcc_fact_type(4, 'msc_demantra_pkg', 'demantra_ods', '11.5.10', 'end_date', 4);
30: t(5) := msc_apcc_fact_type(5, 'msc_demantra_pkg', 'demantra', '11.5.10', 'start_date', 3);
31: t(6) := msc_apcc_fact_type(6, 'msc_exception_pkg', 'exceptions', '11.5.10', 'analysis_date', 1);
32: t(7) := msc_apcc_fact_type(7, 'msc_item_pkg', 'item_orders', '11.5.10', 'order_date', 1);
33: t(8) := msc_apcc_fact_type(8, 'msc_supply_pkg', 'item_wips', '11.5.10', 'wip_start_date', 2);

Line 30: t(5) := msc_apcc_fact_type(5, 'msc_demantra_pkg', 'demantra', '11.5.10', 'start_date', 3);

26: t(1) := msc_apcc_fact_type(1, 'msc_supply_pkg', 'supplies', '11.5.10', 'supply_date', 1);
27: t(2) := msc_apcc_fact_type(2, 'msc_demand_pkg', 'demands', '11.5.10', 'order_date', 1);
28: t(3) := msc_apcc_fact_type(3, 'msc_demand_pkg', 'demands_cum', '11.5.10', 'order_date', 1);
29: t(4) := msc_apcc_fact_type(4, 'msc_demantra_pkg', 'demantra_ods', '11.5.10', 'end_date', 4);
30: t(5) := msc_apcc_fact_type(5, 'msc_demantra_pkg', 'demantra', '11.5.10', 'start_date', 3);
31: t(6) := msc_apcc_fact_type(6, 'msc_exception_pkg', 'exceptions', '11.5.10', 'analysis_date', 1);
32: t(7) := msc_apcc_fact_type(7, 'msc_item_pkg', 'item_orders', '11.5.10', 'order_date', 1);
33: t(8) := msc_apcc_fact_type(8, 'msc_supply_pkg', 'item_wips', '11.5.10', 'wip_start_date', 2);
34: t(9) := msc_apcc_fact_type(9, 'msc_resource_pkg', 'resources', '11.5.10', 'analysis_date', 2);

Line 744: msc_demantra_pkg.populate_details(errbuf, retcode, l_pi.plan_id, l_plan_run_id);

740:
741: --populate fact/summary tables
742: if (l_demantra_flag = sys_yes) then
743: if (l_pi.plan_id > 0) then
744: msc_demantra_pkg.populate_details(errbuf, retcode, l_pi.plan_id, l_plan_run_id);
745: else
746: if (l_plan_run_id is not null) then
747: msc_demantra_pkg.archive(l_pi.plan_id, l_plan_run_id, 5, p_publisher, null);
748: end if;

Line 747: msc_demantra_pkg.archive(l_pi.plan_id, l_plan_run_id, 5, p_publisher, null);

743: if (l_pi.plan_id > 0) then
744: msc_demantra_pkg.populate_details(errbuf, retcode, l_pi.plan_id, l_plan_run_id);
745: else
746: if (l_plan_run_id is not null) then
747: msc_demantra_pkg.archive(l_pi.plan_id, l_plan_run_id, 5, p_publisher, null);
748: end if;
749:
750: if (p_include_ods = sys_yes) then
751: msc_demantra_pkg.archive(null, null, 4, p_publisher, l_ods_transfer_id);

Line 751: msc_demantra_pkg.archive(null, null, 4, p_publisher, l_ods_transfer_id);

747: msc_demantra_pkg.archive(l_pi.plan_id, l_plan_run_id, 5, p_publisher, null);
748: end if;
749:
750: if (p_include_ods = sys_yes) then
751: msc_demantra_pkg.archive(null, null, 4, p_publisher, l_ods_transfer_id);
752: end if;
753: end if;
754: else
755: -- build item dimension

Line 961: msc_demantra_pkg.build_custom_hierarchy;

957: end loop;
958: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_PHUB_ITEM_CATEGORIES_MV', null, msc_phub_util.apps_schema);
959:
960: build_items_from_pds(-1);
961: msc_demantra_pkg.build_custom_hierarchy;
962:
963: exception
964: when others then
965: retcode := -1;

Line 2363: msc_demantra_pkg.create_item_hierarchy_view;

2359: procedure sync_demantra(errbuf out nocopy varchar2, retcode out nocopy varchar2) is
2360: begin
2361: retcode := 0;
2362: errbuf := null;
2363: msc_demantra_pkg.create_item_hierarchy_view;
2364: msc_demantra_pkg.register_custom_measures;
2365: exception
2366: when others then
2367: retcode := -1;

Line 2364: msc_demantra_pkg.register_custom_measures;

2360: begin
2361: retcode := 0;
2362: errbuf := null;
2363: msc_demantra_pkg.create_item_hierarchy_view;
2364: msc_demantra_pkg.register_custom_measures;
2365: exception
2366: when others then
2367: retcode := -1;
2368: errbuf := sqlerrm;