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_PHUB_COST_PKG dependencies on FND_GLOBAL

Line 96: fnd_global.user_id, sysdate,

92: sum(nvl(mbid.production_cost,0) + nvl(mbid.purchasing_cost,0) +
93: nvl(mbid.carrying_cost,0) + decode(l_plan_type,5, 0,nvl(mbid.transportation_cost,0))) supply_chain_cost,
94: decode(l_plan_type,5, to_number(null),sum(nvl(mbid.item_travel_distance,0))) item_travel_distance,
95:
96: fnd_global.user_id, sysdate,
97: sysdate, fnd_global.user_id, fnd_global.login_id,
98: fnd_global.conc_program_id, fnd_global.conc_login_id,
99: fnd_global.prog_appl_id, fnd_global.conc_request_id
100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d

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

93: nvl(mbid.carrying_cost,0) + decode(l_plan_type,5, 0,nvl(mbid.transportation_cost,0))) supply_chain_cost,
94: decode(l_plan_type,5, to_number(null),sum(nvl(mbid.item_travel_distance,0))) item_travel_distance,
95:
96: fnd_global.user_id, sysdate,
97: sysdate, fnd_global.user_id, fnd_global.login_id,
98: fnd_global.conc_program_id, fnd_global.conc_login_id,
99: fnd_global.prog_appl_id, fnd_global.conc_request_id
100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d
101: where mbid.plan_id=p_plan_id

Line 98: fnd_global.conc_program_id, fnd_global.conc_login_id,

94: decode(l_plan_type,5, to_number(null),sum(nvl(mbid.item_travel_distance,0))) item_travel_distance,
95:
96: fnd_global.user_id, sysdate,
97: sysdate, fnd_global.user_id, fnd_global.login_id,
98: fnd_global.conc_program_id, fnd_global.conc_login_id,
99: fnd_global.prog_appl_id, fnd_global.conc_request_id
100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d
101: where mbid.plan_id=p_plan_id
102: and l_plan_type not in (101,102,103,105)

Line 99: fnd_global.prog_appl_id, fnd_global.conc_request_id

95:
96: fnd_global.user_id, sysdate,
97: sysdate, fnd_global.user_id, fnd_global.login_id,
98: fnd_global.conc_program_id, fnd_global.conc_login_id,
99: fnd_global.prog_appl_id, fnd_global.conc_request_id
100: from msc_bis_inv_detail mbid, msc_phub_dates_mv d
101: where mbid.plan_id=p_plan_id
102: and l_plan_type not in (101,102,103,105)
103: and (mbid.detail_level=1 or l_plan_type=6)

Line 184: fnd_global.user_id, sysdate,

180: decode(l_plan_type,5, to_number(null),sum(decode(mbod.facility_cost_type,
181: 1, mbod.facility_cost, 2, mbod.facility_cost,
182: null))) facility_cost,
183:
184: fnd_global.user_id, sysdate,
185: sysdate, fnd_global.user_id, fnd_global.login_id,
186: fnd_global.conc_program_id, fnd_global.conc_login_id,
187: fnd_global.prog_appl_id, fnd_global.conc_request_id
188: from msc_bis_org_detail mbod, msc_phub_dates_mv d

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

181: 1, mbod.facility_cost, 2, mbod.facility_cost,
182: null))) facility_cost,
183:
184: fnd_global.user_id, sysdate,
185: sysdate, fnd_global.user_id, fnd_global.login_id,
186: fnd_global.conc_program_id, fnd_global.conc_login_id,
187: fnd_global.prog_appl_id, fnd_global.conc_request_id
188: from msc_bis_org_detail mbod, msc_phub_dates_mv d
189: where mbod.plan_id=p_plan_id

Line 186: fnd_global.conc_program_id, fnd_global.conc_login_id,

182: null))) facility_cost,
183:
184: fnd_global.user_id, sysdate,
185: sysdate, fnd_global.user_id, fnd_global.login_id,
186: fnd_global.conc_program_id, fnd_global.conc_login_id,
187: fnd_global.prog_appl_id, fnd_global.conc_request_id
188: from msc_bis_org_detail mbod, msc_phub_dates_mv d
189: where mbod.plan_id=p_plan_id
190: and trunc(mbod.detail_date)=d.calendar_date

Line 187: fnd_global.prog_appl_id, fnd_global.conc_request_id

183:
184: fnd_global.user_id, sysdate,
185: sysdate, fnd_global.user_id, fnd_global.login_id,
186: fnd_global.conc_program_id, fnd_global.conc_login_id,
187: fnd_global.prog_appl_id, fnd_global.conc_request_id
188: from msc_bis_org_detail mbod, msc_phub_dates_mv d
189: where mbod.plan_id=p_plan_id
190: and trunc(mbod.detail_date)=d.calendar_date
191: group by

Line 258: fnd_global.user_id, sysdate,

254: d.calendar_date detail_date,
255: f.source_count,
256: f.risk_item_count,
257:
258: fnd_global.user_id, sysdate,
259: sysdate, fnd_global.user_id, fnd_global.login_id,
260: fnd_global.conc_program_id, fnd_global.conc_login_id,
261: fnd_global.prog_appl_id, fnd_global.conc_request_id
262: from

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

255: f.source_count,
256: f.risk_item_count,
257:
258: fnd_global.user_id, sysdate,
259: sysdate, fnd_global.user_id, fnd_global.login_id,
260: fnd_global.conc_program_id, fnd_global.conc_login_id,
261: fnd_global.prog_appl_id, fnd_global.conc_request_id
262: from
263: (select

Line 260: fnd_global.conc_program_id, fnd_global.conc_login_id,

256: f.risk_item_count,
257:
258: fnd_global.user_id, sysdate,
259: sysdate, fnd_global.user_id, fnd_global.login_id,
260: fnd_global.conc_program_id, fnd_global.conc_login_id,
261: fnd_global.prog_appl_id, fnd_global.conc_request_id
262: from
263: (select
264: plan_id, sr_instance_id, organization_id, inventory_item_id,

Line 261: fnd_global.prog_appl_id, fnd_global.conc_request_id

257:
258: fnd_global.user_id, sysdate,
259: sysdate, fnd_global.user_id, fnd_global.login_id,
260: fnd_global.conc_program_id, fnd_global.conc_login_id,
261: fnd_global.prog_appl_id, fnd_global.conc_request_id
262: from
263: (select
264: plan_id, sr_instance_id, organization_id, inventory_item_id,
265: customer_id, customer_site_id, zone_id,

Line 368: fnd_global.user_id, sysdate,

364: sum(decode(mrk.kpi_type_id, 37, kpi_value_num2, 0)) total_component_qty,
365: sum(decode(mrk.kpi_type_id, 38, kpi_value_num1, 0)) ready_to_build_qty,
366: sum(decode(mrk.kpi_type_id, 38, kpi_value_num2, 0)) total_build_qty,
367:
368: fnd_global.user_id, sysdate,
369: sysdate, fnd_global.user_id, fnd_global.login_id,
370: fnd_global.conc_program_id, fnd_global.conc_login_id,
371: fnd_global.prog_appl_id, fnd_global.conc_request_id
372: from

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

365: sum(decode(mrk.kpi_type_id, 38, kpi_value_num1, 0)) ready_to_build_qty,
366: sum(decode(mrk.kpi_type_id, 38, kpi_value_num2, 0)) total_build_qty,
367:
368: fnd_global.user_id, sysdate,
369: sysdate, fnd_global.user_id, fnd_global.login_id,
370: fnd_global.conc_program_id, fnd_global.conc_login_id,
371: fnd_global.prog_appl_id, fnd_global.conc_request_id
372: from
373: msc_rp_kpi mrk,

Line 370: fnd_global.conc_program_id, fnd_global.conc_login_id,

366: sum(decode(mrk.kpi_type_id, 38, kpi_value_num2, 0)) total_build_qty,
367:
368: fnd_global.user_id, sysdate,
369: sysdate, fnd_global.user_id, fnd_global.login_id,
370: fnd_global.conc_program_id, fnd_global.conc_login_id,
371: fnd_global.prog_appl_id, fnd_global.conc_request_id
372: from
373: msc_rp_kpi mrk,
374: msc_phub_dates_mv d

Line 371: fnd_global.prog_appl_id, fnd_global.conc_request_id

367:
368: fnd_global.user_id, sysdate,
369: sysdate, fnd_global.user_id, fnd_global.login_id,
370: fnd_global.conc_program_id, fnd_global.conc_login_id,
371: fnd_global.prog_appl_id, fnd_global.conc_request_id
372: from
373: msc_rp_kpi mrk,
374: msc_phub_dates_mv d
375: where mrk.plan_id=p_plan_id

Line 508: fnd_global.user_id, sysdate,

504: f.avail_component_qty,
505: f.total_component_qty,
506: f.ready_to_build_qty,
507: f.total_build_qty,
508: fnd_global.user_id, sysdate,
509: sysdate, fnd_global.user_id, fnd_global.login_id,
510: fnd_global.conc_program_id, fnd_global.conc_login_id,
511: fnd_global.prog_appl_id, fnd_global.conc_request_id
512: from

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

505: f.total_component_qty,
506: f.ready_to_build_qty,
507: f.total_build_qty,
508: fnd_global.user_id, sysdate,
509: sysdate, fnd_global.user_id, fnd_global.login_id,
510: fnd_global.conc_program_id, fnd_global.conc_login_id,
511: fnd_global.prog_appl_id, fnd_global.conc_request_id
512: from
513: (select

Line 510: fnd_global.conc_program_id, fnd_global.conc_login_id,

506: f.ready_to_build_qty,
507: f.total_build_qty,
508: fnd_global.user_id, sysdate,
509: sysdate, fnd_global.user_id, fnd_global.login_id,
510: fnd_global.conc_program_id, fnd_global.conc_login_id,
511: fnd_global.prog_appl_id, fnd_global.conc_request_id
512: from
513: (select
514: f.owning_inst_id,

Line 511: fnd_global.prog_appl_id, fnd_global.conc_request_id

507: f.total_build_qty,
508: fnd_global.user_id, sysdate,
509: sysdate, fnd_global.user_id, fnd_global.login_id,
510: fnd_global.conc_program_id, fnd_global.conc_login_id,
511: fnd_global.prog_appl_id, fnd_global.conc_request_id
512: from
513: (select
514: f.owning_inst_id,
515: f.owning_org_id,

Line 689: fnd_global.user_id, sysdate,

685: sum(f.avail_component_qty),
686: sum(f.total_component_qty),
687: sum(f.ready_to_build_qty),
688: sum(f.total_build_qty),
689: fnd_global.user_id, sysdate,
690: sysdate, fnd_global.user_id, fnd_global.login_id,
691: fnd_global.conc_program_id, fnd_global.conc_login_id,
692: fnd_global.prog_appl_id, fnd_global.conc_request_id
693: from

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

686: sum(f.total_component_qty),
687: sum(f.ready_to_build_qty),
688: sum(f.total_build_qty),
689: fnd_global.user_id, sysdate,
690: sysdate, fnd_global.user_id, fnd_global.login_id,
691: fnd_global.conc_program_id, fnd_global.conc_login_id,
692: fnd_global.prog_appl_id, fnd_global.conc_request_id
693: from
694: msc_costs_f f,

Line 691: fnd_global.conc_program_id, fnd_global.conc_login_id,

687: sum(f.ready_to_build_qty),
688: sum(f.total_build_qty),
689: fnd_global.user_id, sysdate,
690: sysdate, fnd_global.user_id, fnd_global.login_id,
691: fnd_global.conc_program_id, fnd_global.conc_login_id,
692: fnd_global.prog_appl_id, fnd_global.conc_request_id
693: from
694: msc_costs_f f,
695: msc_phub_item_categories_mv q

Line 692: fnd_global.prog_appl_id, fnd_global.conc_request_id

688: sum(f.total_build_qty),
689: fnd_global.user_id, sysdate,
690: sysdate, fnd_global.user_id, fnd_global.login_id,
691: fnd_global.conc_program_id, fnd_global.conc_login_id,
692: fnd_global.prog_appl_id, fnd_global.conc_request_id
693: from
694: msc_costs_f f,
695: msc_phub_item_categories_mv q
696: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 796: ' fnd_global.user_id, sysdate,'||

792: ' f.supply_chain_cost,'||
793: ' f.supply_chain_cost2,'||
794: ' f.gross_margin,'||
795: ' f.gross_margin2,'||
796: ' fnd_global.user_id, sysdate,'||
797: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
798: ' from'||
799: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
800: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

Line 797: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

793: ' f.supply_chain_cost2,'||
794: ' f.gross_margin,'||
795: ' f.gross_margin2,'||
796: ' fnd_global.user_id, sysdate,'||
797: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
798: ' from'||
799: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
800: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
801: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp3,'||

Line 923: ' fnd_global.user_id, sysdate,'||

919: ' f.avail_component_qty,'||
920: ' f.total_component_qty,'||
921: ' f.ready_to_build_qty,'||
922: ' f.total_build_qty,'||
923: ' fnd_global.user_id, sysdate,'||
924: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
925: ' from'||
926: ' '||l_apps_schema||'.msc_costs_f'||l_suffix||' f,'||
927: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

Line 924: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

920: ' f.total_component_qty,'||
921: ' f.ready_to_build_qty,'||
922: ' f.total_build_qty,'||
923: ' fnd_global.user_id, sysdate,'||
924: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
925: ' from'||
926: ' '||l_apps_schema||'.msc_costs_f'||l_suffix||' f,'||
927: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
928: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 1111: fnd_global.user_id, sysdate,

1107: total_component_qty,
1108: ready_to_build_qty,
1109: total_build_qty,
1110: 0, -23453, -23453,
1111: fnd_global.user_id, sysdate,
1112: fnd_global.user_id, sysdate, fnd_global.login_id
1113: from msc_st_costs_f
1114: where st_transaction_id=p_st_transaction_id and error_code=0;
1115:

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

1108: ready_to_build_qty,
1109: total_build_qty,
1110: 0, -23453, -23453,
1111: fnd_global.user_id, sysdate,
1112: fnd_global.user_id, sysdate, fnd_global.login_id
1113: from msc_st_costs_f
1114: where st_transaction_id=p_st_transaction_id and error_code=0;
1115:
1116: msc_phub_util.log('msc_phub_cost_pkg.import_costs_f: inserted='||sql%rowcount);

Line 1272: ' fnd_global.user_id, sysdate,'||

1268: ' supply_chain_cost,'||
1269: ' supply_chain_cost2,'||
1270: ' gross_margin,'||
1271: ' gross_margin2,'||
1272: ' fnd_global.user_id, sysdate,'||
1273: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1274: ' from msc_item_inventory_f'||
1275: ' where plan_run_id=:p_plan_run_id';
1276:

Line 1273: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

1269: ' supply_chain_cost2,'||
1270: ' gross_margin,'||
1271: ' gross_margin2,'||
1272: ' fnd_global.user_id, sysdate,'||
1273: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1274: ' from msc_item_inventory_f'||
1275: ' where plan_run_id=:p_plan_run_id';
1276:
1277: execute immediate l_sql using r.plan_run_id;