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.

[Home] [Help]

APPS.MSC_PHUB_PKG dependencies on MSC_PHUB_ITEM_CATEGORIES_MV

Line 892: 'MSC_PHUB_ITEM_CATEGORIES_MV',

888: procedure refresh_mvs(errbuf out nocopy varchar2, retcode out nocopy varchar2, p_refresh_mode varchar2) is
889: l_ods_table_list object_names := object_names(
890: 'MSC_PHUB_DATES_MV',
891: 'MSC_PHUB_CATEGORIES_MV',
892: 'MSC_PHUB_ITEM_CATEGORIES_MV',
893: 'MSC_PHUB_ORGS_MV',
894: 'MSC_PHUB_CUSTOMERS_MV',
895: 'MSC_PHUB_SUPPLIERS_MV',
896: 'MSC_CURRENCY_CONV_MV',

Line 958: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_PHUB_ITEM_CATEGORIES_MV', null, msc_phub_util.apps_schema);

954: msc_phub_util.log('Refreshing MV : '||l_name||' starts');
955: dbms_mview.refresh(l_name, atomic_refresh=>false);
956: msc_phub_util.log('Refreshing MV : '||l_name||' ends');
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:

Line 1546: from msc_phub_item_categories_mv

1542: fnd_global.conc_program_id, fnd_global.conc_login_id,
1543: fnd_global.prog_appl_id, fnd_global.conc_request_id
1544: from msc_system_items i,
1545: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1546: from msc_phub_item_categories_mv
1547: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_1')) ic1,
1548: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1549: from msc_phub_item_categories_mv
1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,

Line 1549: from msc_phub_item_categories_mv

1545: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1546: from msc_phub_item_categories_mv
1547: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_1')) ic1,
1548: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1549: from msc_phub_item_categories_mv
1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,
1551: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1552: from msc_phub_item_categories_mv
1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,

Line 1552: from msc_phub_item_categories_mv

1548: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1549: from msc_phub_item_categories_mv
1550: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_2')) ic2,
1551: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1552: from msc_phub_item_categories_mv
1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,
1554: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1555: from msc_phub_item_categories_mv
1556: where nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2)<2

Line 1555: from msc_phub_item_categories_mv

1551: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1552: from msc_phub_item_categories_mv
1553: where category_set_id=fnd_profile.value('MSC_HUB_CAT_SET_ID_3')) ic3,
1554: (select sr_instance_id, organization_id, inventory_item_id, sr_category_id
1555: from msc_phub_item_categories_mv
1556: where nvl(fnd_profile.value('MSC_APCC_END_ITEM_ENABLED'), 2)<2
1557: and category_set_id=fnd_profile.value('MSC_APCC_PEGGING_CAT_SET')) ick,
1558: (select distinct lower_item_id,
1559: first_value(highest_item_id) over(partition by lower_item_id) highest_item_id