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 FND_GLOBAL

Line 58: l_user_id := fnd_global.user_id;

54: -- Successfully populated msc_supplies_f table for plan_id =' || p_plan_id || ',plan_run_id=' || p_plan_run_id;
55: -- initial there is no error message
56: l_api_name := 'msc_supply_f_pkg.populate_details';
57:
58: l_user_id := fnd_global.user_id;
59: l_sysdate :=sysdate;
60: l_user_login_id :=fnd_global.login_id;
61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 60: l_user_login_id :=fnd_global.login_id;

56: l_api_name := 'msc_supply_f_pkg.populate_details';
57:
58: l_user_id := fnd_global.user_id;
59: l_sysdate :=sysdate;
60: l_user_login_id :=fnd_global.login_id;
61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

Line 61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;

57:
58: l_user_id := fnd_global.user_id;
59: l_sysdate :=sysdate;
60: l_user_login_id :=fnd_global.login_id;
61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
65: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);

Line 62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

58: l_user_id := fnd_global.user_id;
59: l_sysdate :=sysdate;
60: l_user_login_id :=fnd_global.login_id;
61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
65: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
66:

Line 63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;

59: l_sysdate :=sysdate;
60: l_user_login_id :=fnd_global.login_id;
61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
65: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
66:
67:

Line 64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

60: l_user_login_id :=fnd_global.login_id;
61: l_cp_login_id :=FND_GLOBAL.CONC_LOGIN_ID;
62: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
63: l_appl_id := FND_GLOBAL.PROG_APPL_ID;
64: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
65: l_plan_type := msc_phub_util.get_plan_type(p_plan_id);
66:
67:
68: l_stmt_id :=5;

Line 876: fnd_global.user_id, sysdate,

872: sum(f.work_order_qty),
873: sum(f.stockout_days),
874: sum(f.drp_supply_as_demand),
875: sum(f.return_order_qty),
876: fnd_global.user_id, sysdate,
877: sysdate, fnd_global.user_id, fnd_global.login_id,
878: fnd_global.conc_program_id, fnd_global.conc_login_id,
879: fnd_global.prog_appl_id, fnd_global.conc_request_id
880: from

Line 877: sysdate, fnd_global.user_id, fnd_global.login_id,

873: sum(f.stockout_days),
874: sum(f.drp_supply_as_demand),
875: sum(f.return_order_qty),
876: fnd_global.user_id, sysdate,
877: sysdate, fnd_global.user_id, fnd_global.login_id,
878: fnd_global.conc_program_id, fnd_global.conc_login_id,
879: fnd_global.prog_appl_id, fnd_global.conc_request_id
880: from
881: msc_supplies_f f,

Line 878: fnd_global.conc_program_id, fnd_global.conc_login_id,

874: sum(f.drp_supply_as_demand),
875: sum(f.return_order_qty),
876: fnd_global.user_id, sysdate,
877: sysdate, fnd_global.user_id, fnd_global.login_id,
878: fnd_global.conc_program_id, fnd_global.conc_login_id,
879: fnd_global.prog_appl_id, fnd_global.conc_request_id
880: from
881: msc_supplies_f f,
882: msc_phub_item_categories_mv q

Line 879: fnd_global.prog_appl_id, fnd_global.conc_request_id

875: sum(f.return_order_qty),
876: fnd_global.user_id, sysdate,
877: sysdate, fnd_global.user_id, fnd_global.login_id,
878: fnd_global.conc_program_id, fnd_global.conc_login_id,
879: fnd_global.prog_appl_id, fnd_global.conc_request_id
880: from
881: msc_supplies_f f,
882: msc_phub_item_categories_mv q
883: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 922: fnd_global.user_id, sysdate,

918: to_number(42) aggr_type,
919: l_category_set_id1 category_set_id,
920: nvl(q.sr_category_id, -23453),
921: sum(f.wip_qty),
922: fnd_global.user_id, sysdate,
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

Line 923: sysdate, fnd_global.user_id, fnd_global.login_id,

919: l_category_set_id1 category_set_id,
920: nvl(q.sr_category_id, -23453),
921: sum(f.wip_qty),
922: fnd_global.user_id, sysdate,
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,

Line 924: fnd_global.conc_program_id, fnd_global.conc_login_id,

920: nvl(q.sr_category_id, -23453),
921: sum(f.wip_qty),
922: fnd_global.user_id, sysdate,
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

Line 925: fnd_global.prog_appl_id, fnd_global.conc_request_id

921: sum(f.wip_qty),
922: fnd_global.user_id, sysdate,
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

Line 984: fnd_global.user_id, sysdate,

980: sum(f.work_order_qty),
981: sum(f.stockout_days),
982: sum(f.drp_supply_as_demand),
983: sum(f.return_order_qty),
984: fnd_global.user_id, sysdate,
985: sysdate, fnd_global.user_id, fnd_global.login_id,
986: fnd_global.conc_program_id, fnd_global.conc_login_id,
987: fnd_global.prog_appl_id, fnd_global.conc_request_id
988: from

Line 985: sysdate, fnd_global.user_id, fnd_global.login_id,

981: sum(f.stockout_days),
982: sum(f.drp_supply_as_demand),
983: sum(f.return_order_qty),
984: fnd_global.user_id, sysdate,
985: sysdate, fnd_global.user_id, fnd_global.login_id,
986: fnd_global.conc_program_id, fnd_global.conc_login_id,
987: fnd_global.prog_appl_id, fnd_global.conc_request_id
988: from
989: msc_supplies_f f,

Line 986: fnd_global.conc_program_id, fnd_global.conc_login_id,

982: sum(f.drp_supply_as_demand),
983: sum(f.return_order_qty),
984: fnd_global.user_id, sysdate,
985: sysdate, fnd_global.user_id, fnd_global.login_id,
986: fnd_global.conc_program_id, fnd_global.conc_login_id,
987: fnd_global.prog_appl_id, fnd_global.conc_request_id
988: from
989: msc_supplies_f f,
990: msc_phub_mfg_cal_periods_mv mp

Line 987: fnd_global.prog_appl_id, fnd_global.conc_request_id

983: sum(f.return_order_qty),
984: fnd_global.user_id, sysdate,
985: sysdate, fnd_global.user_id, fnd_global.login_id,
986: fnd_global.conc_program_id, fnd_global.conc_login_id,
987: fnd_global.prog_appl_id, fnd_global.conc_request_id
988: from
989: msc_supplies_f f,
990: msc_phub_mfg_cal_periods_mv mp
991: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1024: fnd_global.user_id, sysdate,

1020: sum(f.work_order_qty),
1021: sum(f.stockout_days),
1022: sum(f.drp_supply_as_demand),
1023: sum(f.return_order_qty),
1024: fnd_global.user_id, sysdate,
1025: sysdate, fnd_global.user_id, fnd_global.login_id,
1026: fnd_global.conc_program_id, fnd_global.conc_login_id,
1027: fnd_global.prog_appl_id, fnd_global.conc_request_id
1028: from

Line 1025: sysdate, fnd_global.user_id, fnd_global.login_id,

1021: sum(f.stockout_days),
1022: sum(f.drp_supply_as_demand),
1023: sum(f.return_order_qty),
1024: fnd_global.user_id, sysdate,
1025: sysdate, fnd_global.user_id, fnd_global.login_id,
1026: fnd_global.conc_program_id, fnd_global.conc_login_id,
1027: fnd_global.prog_appl_id, fnd_global.conc_request_id
1028: from
1029: msc_supplies_f f,

Line 1026: fnd_global.conc_program_id, fnd_global.conc_login_id,

1022: sum(f.drp_supply_as_demand),
1023: sum(f.return_order_qty),
1024: fnd_global.user_id, sysdate,
1025: sysdate, fnd_global.user_id, fnd_global.login_id,
1026: fnd_global.conc_program_id, fnd_global.conc_login_id,
1027: fnd_global.prog_appl_id, fnd_global.conc_request_id
1028: from
1029: msc_supplies_f f,
1030: msc_phub_fiscal_periods_mv fp

Line 1027: fnd_global.prog_appl_id, fnd_global.conc_request_id

1023: sum(f.return_order_qty),
1024: fnd_global.user_id, sysdate,
1025: sysdate, fnd_global.user_id, fnd_global.login_id,
1026: fnd_global.conc_program_id, fnd_global.conc_login_id,
1027: fnd_global.prog_appl_id, fnd_global.conc_request_id
1028: from
1029: msc_supplies_f f,
1030: msc_phub_fiscal_periods_mv fp
1031: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1067: fnd_global.user_id, sysdate,

1063: mp.period_start_date wip_start_date,
1064: decode(f.aggr_type, 42, 1016, 43, 1017, 1018) aggr_type,
1065: f.category_set_id, f.sr_category_id,
1066: sum(f.wip_qty),
1067: fnd_global.user_id, sysdate,
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

Line 1068: sysdate, fnd_global.user_id, fnd_global.login_id,

1064: decode(f.aggr_type, 42, 1016, 43, 1017, 1018) aggr_type,
1065: f.category_set_id, f.sr_category_id,
1066: sum(f.wip_qty),
1067: fnd_global.user_id, sysdate,
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,

Line 1069: fnd_global.conc_program_id, fnd_global.conc_login_id,

1065: f.category_set_id, f.sr_category_id,
1066: sum(f.wip_qty),
1067: fnd_global.user_id, sysdate,
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

Line 1070: fnd_global.prog_appl_id, fnd_global.conc_request_id

1066: sum(f.wip_qty),
1067: fnd_global.user_id, sysdate,
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

Line 1094: fnd_global.user_id, sysdate,

1090: fp.start_date wip_start_date,
1091: decode(f.aggr_type, 42, 1019, 43, 1020, 1021) aggr_type,
1092: f.category_set_id, f.sr_category_id,
1093: sum(f.wip_qty),
1094: fnd_global.user_id, sysdate,
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

Line 1095: sysdate, fnd_global.user_id, fnd_global.login_id,

1091: decode(f.aggr_type, 42, 1019, 43, 1020, 1021) aggr_type,
1092: f.category_set_id, f.sr_category_id,
1093: sum(f.wip_qty),
1094: fnd_global.user_id, sysdate,
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,

Line 1096: fnd_global.conc_program_id, fnd_global.conc_login_id,

1092: f.category_set_id, f.sr_category_id,
1093: sum(f.wip_qty),
1094: fnd_global.user_id, sysdate,
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

Line 1097: fnd_global.prog_appl_id, fnd_global.conc_request_id

1093: sum(f.wip_qty),
1094: fnd_global.user_id, sysdate,
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