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 606: Insert into msc_item_wips_f (

602: --- msc_item_wip_f
603: ---
604:
605: l_stmt_id:=30;
606: Insert into msc_item_wips_f (
607: created_by,
608: creation_date,
609: last_updated_by,
610: last_update_date,

Line 902: insert into msc_item_wips_f (

898:
899: commit;
900:
901: -- level 1
902: insert into msc_item_wips_f (
903: plan_id, plan_run_id,
904: sr_instance_id, organization_id, inventory_item_id,
905: vmi_flag, wip_start_date,
906: aggr_type, category_set_id, sr_category_id,

Line 927: msc_item_wips_f f,

923: sysdate, fnd_global.user_id, fnd_global.login_id,
924: fnd_global.conc_program_id, fnd_global.conc_login_id,
925: fnd_global.prog_appl_id, fnd_global.conc_request_id
926: from
927: msc_item_wips_f f,
928: msc_phub_item_categories_mv q
929: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
930: and f.aggr_type=0
931: and f.sr_instance_id=q.sr_instance_id(+)

Line 1048: insert into msc_item_wips_f (

1044:
1045: commit;
1046:
1047: -- level 2
1048: insert into msc_item_wips_f (
1049: plan_id, plan_run_id,
1050: sr_instance_id, organization_id, inventory_item_id,
1051: vmi_flag, wip_start_date,
1052: aggr_type, category_set_id, sr_category_id,

Line 1072: msc_item_wips_f f,

1068: sysdate, fnd_global.user_id, fnd_global.login_id,
1069: fnd_global.conc_program_id, fnd_global.conc_login_id,
1070: fnd_global.prog_appl_id, fnd_global.conc_request_id
1071: from
1072: msc_item_wips_f f,
1073: msc_phub_mfg_cal_periods_mv mp
1074: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1075: and f.aggr_type between 42 and 44
1076: and f.wip_start_date between mp.period_start_date and mp.period_end_date

Line 1099: msc_item_wips_f f,

1095: sysdate, fnd_global.user_id, fnd_global.login_id,
1096: fnd_global.conc_program_id, fnd_global.conc_login_id,
1097: fnd_global.prog_appl_id, fnd_global.conc_request_id
1098: from
1099: msc_item_wips_f f,
1100: msc_phub_fiscal_periods_mv fp
1101: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
1102: and f.aggr_type between 42 and 44
1103: and f.wip_start_date between fp.start_date and fp.end_date