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_SUPPLY_PKG dependencies on MSC_ITEM_WIPS_F

Line 71: delete from msc_item_wips_f

67: l_rowcount1 := l_rowcount1 + sql%rowcount;
68: msc_phub_util.log('msc_supplies_f, delete='||sql%rowcount||', l_rowcount1='||l_rowcount1);
69: commit;
70:
71: delete from msc_item_wips_f
72: where plan_id = p_plan_id
73: and plan_run_id = p_plan_run_id
74: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
75: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);

Line 78: msc_phub_util.log('msc_item_wips_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);

74: and (p_plan_id, sr_instance_id, organization_id, inventory_item_id) in
75: (select number1, number2, number3, number4 from msc_hub_query q where q.query_id = l_item_rn_qid);
76:
77: l_rowcount2 := l_rowcount2 + sql%rowcount;
78: msc_phub_util.log('msc_item_wips_f, delete='||sql%rowcount||', l_rowcount2='||l_rowcount2);
79: commit;
80: end if;
81: end if;
82:

Line 487: insert into msc_item_wips_f (

483: --- populate wip start qty
484: --- msc_item_wip_f
485: ---
486:
487: insert into msc_item_wips_f (
488: plan_id, -- plan_id
489: plan_run_id,
490: sr_instance_id,
491: organization_id,

Line 572: msc_phub_util.log('msc_item_wips_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);

568: wip_tbl.vmi_flag,
569: decode(sign(to_number(wip_tbl.wip_start_date-l_plan_start_date)),-1,l_plan_start_date,wip_tbl.wip_start_date);
570:
571: l_rowcount2 := l_rowcount2 + sql%rowcount;
572: msc_phub_util.log('msc_item_wips_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
573: commit;
574: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_WIPS_F', p_plan_run_id);
575:
576: if (l_rowcount1 > 0) then

Line 574: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_WIPS_F', p_plan_run_id);

570:
571: l_rowcount2 := l_rowcount2 + sql%rowcount;
572: msc_phub_util.log('msc_item_wips_f, insert='||sql%rowcount||', l_rowcount2='||l_rowcount2);
573: commit;
574: msc_phub_util.gather_table_stats(msc_phub_util.stats_fact, 'MSC_ITEM_WIPS_F', p_plan_run_id);
575:
576: if (l_rowcount1 > 0) then
577: summarize_supplies_f(errbuf, retcode, p_plan_id, p_plan_run_id);
578: end if;

Line 927: delete from msc_item_wips_f

923: msc_phub_util.log('msc_supply_pkg.summarize_item_wips_f');
924: retcode := 0;
925: errbuf := '';
926:
927: delete from msc_item_wips_f
928: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
929: msc_phub_util.log('msc_supply_pkg.summarize_item_wips_f, delete='||sql%rowcount);
930: commit;
931:

Line 933: insert into msc_item_wips_f (

929: msc_phub_util.log('msc_supply_pkg.summarize_item_wips_f, delete='||sql%rowcount);
930: commit;
931:
932: -- level 1
933: insert into msc_item_wips_f (
934: plan_id, plan_run_id,
935: sr_instance_id, organization_id, inventory_item_id,
936: vmi_flag, wip_start_date,
937: aggr_type, category_set_id, sr_category_id,

Line 958: msc_item_wips_f f,

954: sysdate, fnd_global.user_id, fnd_global.login_id,
955: fnd_global.conc_program_id, fnd_global.conc_login_id,
956: fnd_global.prog_appl_id, fnd_global.conc_request_id
957: from
958: msc_item_wips_f f,
959: msc_phub_item_categories_mv q
960: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
961: and f.aggr_type=0
962: and f.sr_instance_id=q.sr_instance_id(+)

Line 976: insert into msc_item_wips_f (

972: msc_phub_util.log('msc_supply_pkg.summarize_item_wips_f, level1='||sql%rowcount);
973: commit;
974:
975: -- level 2
976: insert into msc_item_wips_f (
977: plan_id, plan_run_id,
978: sr_instance_id, organization_id, inventory_item_id,
979: vmi_flag, wip_start_date,
980: aggr_type, category_set_id, sr_category_id,

Line 1000: msc_item_wips_f f,

996: sysdate, fnd_global.user_id, fnd_global.login_id,
997: fnd_global.conc_program_id, fnd_global.conc_login_id,
998: fnd_global.prog_appl_id, fnd_global.conc_request_id
999: from
1000: msc_item_wips_f f,
1001: msc_phub_dates_mv d
1002: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1003: and f.aggr_type between 42 and 44
1004: and f.wip_start_date = d.calendar_date

Line 1028: msc_item_wips_f f,

1024: sysdate, fnd_global.user_id, fnd_global.login_id,
1025: fnd_global.conc_program_id, fnd_global.conc_login_id,
1026: fnd_global.prog_appl_id, fnd_global.conc_request_id
1027: from
1028: msc_item_wips_f f,
1029: msc_phub_dates_mv d
1030: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1031: and f.aggr_type between 42 and 44
1032: and f.wip_start_date = d.calendar_date

Line 1318: ' '||l_apps_schema||'.msc_item_wips_f'||l_suffix||' f,'||

1314: ' f.wip_qty,'||
1315: ' fnd_global.user_id, sysdate,'||
1316: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1317: ' from'||
1318: ' '||l_apps_schema||'.msc_item_wips_f'||l_suffix||' f,'||
1319: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1320: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||
1321: ' where f.plan_run_id=:p_plan_run_id'||
1322: ' and f.aggr_type=0'||

Line 1527: l_fact_table varchar2(30) := 'msc_item_wips_f';

1523: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
1524: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
1525: is
1526: l_staging_table varchar2(30) := 'msc_st_item_wips_f';
1527: l_fact_table varchar2(30) := 'msc_item_wips_f';
1528: l_result number := 0;
1529: begin
1530: msc_phub_util.log('msc_supply_pkg.import_item_wips_f');
1531: retcode := 0;

Line 1550: msc_phub_util.log('msc_supply_pkg.import_item_wips_f: insert into msc_item_wips_f');

1546:
1547: l_result := l_result + msc_phub_util.decode_item_key(
1548: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'item_name');
1549:
1550: msc_phub_util.log('msc_supply_pkg.import_item_wips_f: insert into msc_item_wips_f');
1551: insert into msc_item_wips_f (
1552: plan_id,
1553: plan_run_id,
1554: sr_instance_id,

Line 1551: insert into msc_item_wips_f (

1547: l_result := l_result + msc_phub_util.decode_item_key(
1548: l_staging_table, p_st_transaction_id, 'inventory_item_id', 'item_name');
1549:
1550: msc_phub_util.log('msc_supply_pkg.import_item_wips_f: insert into msc_item_wips_f');
1551: insert into msc_item_wips_f (
1552: plan_id,
1553: plan_run_id,
1554: sr_instance_id,
1555: organization_id,