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_ITEM_PKG dependencies on MSC_ITEM_INVENTORY_F

Line 47: delete from msc_item_inventory_f

43: if l_refresh_mode=2 -- targeted refesh
44: then
45: l_item_rn_qid := msc_phub_util.get_item_rn_qid(p_plan_id, p_plan_run_id);
46:
47: delete from msc_item_inventory_f
48: where plan_id=p_plan_id
49: and plan_run_id=p_plan_run_id
50: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
51: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id=l_item_rn_qid);

Line 54: msc_phub_util.log('msc_item_inventory_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);

50: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
51: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id=l_item_rn_qid);
52:
53: l_rowcount1 := l_rowcount1 + sql%rowcount;
54: msc_phub_util.log('msc_item_inventory_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
55: commit;
56:
57: delete from msc_item_orders_f
58: where plan_id=p_plan_id

Line 1333: -- msc_item_inventory_f:final

1329: msc_phub_util.log('insert into msc_st_item_inventory_f:avg_daily_demand: '||sql%rowcount);
1330: commit;
1331: end if;
1332:
1333: -- msc_item_inventory_f:final
1334: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_INVENTORY_F', l_transfer_id);
1335: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 1);
1336: insert into msc_item_inventory_f (
1337: plan_id,

Line 1335: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 1);

1331: end if;
1332:
1333: -- msc_item_inventory_f:final
1334: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_INVENTORY_F', l_transfer_id);
1335: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 1);
1336: insert into msc_item_inventory_f (
1337: plan_id,
1338: plan_run_id,
1339: sr_instance_id,

Line 1336: insert into msc_item_inventory_f (

1332:
1333: -- msc_item_inventory_f:final
1334: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_ITEM_INVENTORY_F', l_transfer_id);
1335: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 1);
1336: insert into msc_item_inventory_f (
1337: plan_id,
1338: plan_run_id,
1339: sr_instance_id,
1340: organization_id,

Line 1521: msc_phub_util.log('insert into msc_item_inventory_f:final: '||sql%rowcount);

1517: and fnd_profile.value('MSC_HUB_CUR_CODE_RPT')=mcc.to_currency(+)
1518: and f.order_date=mcc.calendar_date(+);
1519:
1520: l_rowcount2 := l_rowcount2 + sql%rowcount;
1521: msc_phub_util.log('insert into msc_item_inventory_f:final: '||sql%rowcount);
1522: commit;
1523: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 2);
1524: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_INVENTORY_F', p_plan_run_id);
1525:

Line 1523: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 2);

1519:
1520: l_rowcount2 := l_rowcount2 + sql%rowcount;
1521: msc_phub_util.log('insert into msc_item_inventory_f:final: '||sql%rowcount);
1522: commit;
1523: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 2);
1524: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_INVENTORY_F', p_plan_run_id);
1525:
1526: if (l_rowcount1 > 0) then
1527: summarize_item_orders_f(errbuf, retcode, p_plan_id, p_plan_run_id);

Line 1524: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_INVENTORY_F', p_plan_run_id);

1520: l_rowcount2 := l_rowcount2 + sql%rowcount;
1521: msc_phub_util.log('insert into msc_item_inventory_f:final: '||sql%rowcount);
1522: commit;
1523: msc_phub_util.unusuable_local_index('MSC_ITEM_INVENTORY_F', p_plan_run_id, 2);
1524: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_INVENTORY_F', p_plan_run_id);
1525:
1526: if (l_rowcount1 > 0) then
1527: summarize_item_orders_f(errbuf, retcode, p_plan_id, p_plan_run_id);
1528: end if;

Line 1553: delete from msc_item_inventory_f

1549: msc_phub_util.log('msc_item_pkg.summarize_item_inventory_f');
1550: retcode := 0;
1551: errbuf := '';
1552:
1553: delete from msc_item_inventory_f
1554: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
1555: msc_phub_util.log('msc_item_pkg.summarize_item_inventory_f, delete='||sql%rowcount);
1556: commit;
1557:

Line 1559: insert into msc_item_inventory_f (

1555: msc_phub_util.log('msc_item_pkg.summarize_item_inventory_f, delete='||sql%rowcount);
1556: commit;
1557:
1558: -- level 1
1559: insert into msc_item_inventory_f (
1560: plan_id, plan_run_id, io_plan_flag,
1561: sr_instance_id, organization_id, owning_inst_id, owning_org_id,
1562: inventory_item_id,
1563: vmi_flag, order_date,

Line 1657: msc_item_inventory_f f,

1653: sysdate, fnd_global.user_id, fnd_global.login_id,
1654: fnd_global.conc_program_id, fnd_global.conc_login_id,
1655: fnd_global.prog_appl_id, fnd_global.conc_request_id
1656: from
1657: msc_item_inventory_f f,
1658: msc_phub_item_categories_mv q
1659: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id
1660: and f.aggr_type=0
1661: and f.owning_inst_id=q.sr_instance_id(+)

Line 1981: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||

1977: l_sql := l_sql||
1978: ' fnd_global.user_id, sysdate,'||
1979: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1980: ' from'||
1981: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
1982: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1983: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1984: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
1985: ' where f.plan_run_id=:p_plan_run_id'||

Line 2205: l_fact_table varchar2(30) := 'msc_item_inventory_f';

2201: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
2202: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
2203: is
2204: l_staging_table varchar2(30) := 'msc_st_item_inventory_f';
2205: l_fact_table varchar2(30) := 'msc_item_inventory_f';
2206: l_result number := 0;
2207: begin
2208: msc_phub_util.log('msc_item_pkg.import_item_inventory_f');
2209: retcode := 0;

Line 2232: msc_phub_util.log('msc_item_pkg.import_item_inventory_f: insert into msc_item_inventory_f');

2228:
2229: l_result := l_result + msc_phub_util.decode_item_key(
2230: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'item_name');
2231:
2232: msc_phub_util.log('msc_item_pkg.import_item_inventory_f: insert into msc_item_inventory_f');
2233: insert into msc_item_inventory_f (
2234: plan_id,
2235: plan_run_id,
2236: sr_instance_id,

Line 2233: insert into msc_item_inventory_f (

2229: l_result := l_result + msc_phub_util.decode_item_key(
2230: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'item_name');
2231:
2232: msc_phub_util.log('msc_item_pkg.import_item_inventory_f: insert into msc_item_inventory_f');
2233: insert into msc_item_inventory_f (
2234: plan_id,
2235: plan_run_id,
2236: sr_instance_id,
2237: organization_id,