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

Line 79: fnd_global.user_id,

75: )
76: select
77: unique l_qid_eo,
78: sysdate,
79: fnd_global.user_id,
80: sysdate,
81: fnd_global.user_id,
82: fnd_global.login_id,
83: msi.obsolescence_date,

Line 81: fnd_global.user_id,

77: unique l_qid_eo,
78: sysdate,
79: fnd_global.user_id,
80: sysdate,
81: fnd_global.user_id,
82: fnd_global.login_id,
83: msi.obsolescence_date,
84: msi.sr_instance_id,
85: msi.organization_id,

Line 82: fnd_global.login_id,

78: sysdate,
79: fnd_global.user_id,
80: sysdate,
81: fnd_global.user_id,
82: fnd_global.login_id,
83: msi.obsolescence_date,
84: msi.sr_instance_id,
85: msi.organization_id,
86: msi.inventory_item_id,

Line 130: fnd_global.user_id,

126: )
127: select
128: unique l_qid_eo,
129: sysdate,
130: fnd_global.user_id,
131: sysdate,
132: fnd_global.user_id,
133: fnd_global.login_id,
134: mia.obsolescence_date,

Line 132: fnd_global.user_id,

128: unique l_qid_eo,
129: sysdate,
130: fnd_global.user_id,
131: sysdate,
132: fnd_global.user_id,
133: fnd_global.login_id,
134: mia.obsolescence_date,
135: mia.sr_instance_id,
136: mia.organization_id,

Line 133: fnd_global.login_id,

129: sysdate,
130: fnd_global.user_id,
131: sysdate,
132: fnd_global.user_id,
133: fnd_global.login_id,
134: mia.obsolescence_date,
135: mia.sr_instance_id,
136: mia.organization_id,
137: mia.inventory_item_id,

Line 247: fnd_global.user_id, sysdate,

243: decode(sdt.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))), 0) +
244: greatest(sum((nvl(sdt.onorder_value,0)-nvl(sdt.dmd_within_obs_hor_value,0)) *
245: decode(sdt.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))), 0) total_obs_value2,
246:
247: fnd_global.user_id, sysdate,
248: sysdate, fnd_global.user_id, fnd_global.login_id,
249: fnd_global.conc_program_id, fnd_global.conc_login_id,
250: fnd_global.prog_appl_id, fnd_global.conc_request_id
251: from

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

244: greatest(sum((nvl(sdt.onorder_value,0)-nvl(sdt.dmd_within_obs_hor_value,0)) *
245: decode(sdt.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))), 0) total_obs_value2,
246:
247: fnd_global.user_id, sysdate,
248: sysdate, fnd_global.user_id, fnd_global.login_id,
249: fnd_global.conc_program_id, fnd_global.conc_login_id,
250: fnd_global.prog_appl_id, fnd_global.conc_request_id
251: from
252: (

Line 249: fnd_global.conc_program_id, fnd_global.conc_login_id,

245: decode(sdt.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate,0))), 0) total_obs_value2,
246:
247: fnd_global.user_id, sysdate,
248: sysdate, fnd_global.user_id, fnd_global.login_id,
249: fnd_global.conc_program_id, fnd_global.conc_login_id,
250: fnd_global.prog_appl_id, fnd_global.conc_request_id
251: from
252: (
253: select

Line 250: fnd_global.prog_appl_id, fnd_global.conc_request_id

246:
247: fnd_global.user_id, sysdate,
248: sysdate, fnd_global.user_id, fnd_global.login_id,
249: fnd_global.conc_program_id, fnd_global.conc_login_id,
250: fnd_global.prog_appl_id, fnd_global.conc_request_id
251: from
252: (
253: select
254: msf.plan_id,

Line 373: fnd_global.user_id, sysdate,

369: to_number(-23453) owning_inst_id,
370: to_number(-23453) owning_org_id,
371: to_number(-23453) inventory_item_id,
372: mtp.maximum_volume*nvl(uc.conversion_rate,1) wh_available_capacity,
373: fnd_global.user_id, sysdate,
374: sysdate, fnd_global.user_id, fnd_global.login_id,
375: fnd_global.conc_program_id, fnd_global.conc_login_id,
376: fnd_global.prog_appl_id, fnd_global.conc_request_id
377: from

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

370: to_number(-23453) owning_org_id,
371: to_number(-23453) inventory_item_id,
372: mtp.maximum_volume*nvl(uc.conversion_rate,1) wh_available_capacity,
373: fnd_global.user_id, sysdate,
374: sysdate, fnd_global.user_id, fnd_global.login_id,
375: fnd_global.conc_program_id, fnd_global.conc_login_id,
376: fnd_global.prog_appl_id, fnd_global.conc_request_id
377: from
378: msc_trading_partners mtp,

Line 375: fnd_global.conc_program_id, fnd_global.conc_login_id,

371: to_number(-23453) inventory_item_id,
372: mtp.maximum_volume*nvl(uc.conversion_rate,1) wh_available_capacity,
373: fnd_global.user_id, sysdate,
374: sysdate, fnd_global.user_id, fnd_global.login_id,
375: fnd_global.conc_program_id, fnd_global.conc_login_id,
376: fnd_global.prog_appl_id, fnd_global.conc_request_id
377: from
378: msc_trading_partners mtp,
379: msc_plan_organizations po,

Line 376: fnd_global.prog_appl_id, fnd_global.conc_request_id

372: mtp.maximum_volume*nvl(uc.conversion_rate,1) wh_available_capacity,
373: fnd_global.user_id, sysdate,
374: sysdate, fnd_global.user_id, fnd_global.login_id,
375: fnd_global.conc_program_id, fnd_global.conc_login_id,
376: fnd_global.prog_appl_id, fnd_global.conc_request_id
377: from
378: msc_trading_partners mtp,
379: msc_plan_organizations po,
380: msc_uom_conversions uc

Line 415: fnd_global.user_id, sysdate,

411: mwc.sr_instance_id owning_inst_id,
412: to_number(-23453) owning_org_id,
413: -mwc.sr_category_id inventory_item_id,
414: mwc.available_capacity*nvl(uc.conversion_rate,1) wh_available_capacity,
415: fnd_global.user_id, sysdate,
416: sysdate, fnd_global.user_id, fnd_global.login_id,
417: fnd_global.conc_program_id, fnd_global.conc_login_id,
418: fnd_global.prog_appl_id, fnd_global.conc_request_id
419: from

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

412: to_number(-23453) owning_org_id,
413: -mwc.sr_category_id inventory_item_id,
414: mwc.available_capacity*nvl(uc.conversion_rate,1) wh_available_capacity,
415: fnd_global.user_id, sysdate,
416: sysdate, fnd_global.user_id, fnd_global.login_id,
417: fnd_global.conc_program_id, fnd_global.conc_login_id,
418: fnd_global.prog_appl_id, fnd_global.conc_request_id
419: from
420: msc_warehouse_capacities mwc,

Line 417: fnd_global.conc_program_id, fnd_global.conc_login_id,

413: -mwc.sr_category_id inventory_item_id,
414: mwc.available_capacity*nvl(uc.conversion_rate,1) wh_available_capacity,
415: fnd_global.user_id, sysdate,
416: sysdate, fnd_global.user_id, fnd_global.login_id,
417: fnd_global.conc_program_id, fnd_global.conc_login_id,
418: fnd_global.prog_appl_id, fnd_global.conc_request_id
419: from
420: msc_warehouse_capacities mwc,
421: msc_plan_organizations po,

Line 418: fnd_global.prog_appl_id, fnd_global.conc_request_id

414: mwc.available_capacity*nvl(uc.conversion_rate,1) wh_available_capacity,
415: fnd_global.user_id, sysdate,
416: sysdate, fnd_global.user_id, fnd_global.login_id,
417: fnd_global.conc_program_id, fnd_global.conc_login_id,
418: fnd_global.prog_appl_id, fnd_global.conc_request_id
419: from
420: msc_warehouse_capacities mwc,
421: msc_plan_organizations po,
422: msc_uom_conversions uc

Line 503: fnd_global.user_id, sysdate,

499: sum(obsolete_onorder_value2),
500: sum(total_excess_value2),
501: sum(total_obs_value2),
502: sum(wh_available_capacity),
503: fnd_global.user_id, sysdate,
504: sysdate, fnd_global.user_id, fnd_global.login_id,
505: fnd_global.conc_program_id, fnd_global.conc_login_id,
506: fnd_global.prog_appl_id, fnd_global.conc_request_id
507: from msc_st_items_f f

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

500: sum(total_excess_value2),
501: sum(total_obs_value2),
502: sum(wh_available_capacity),
503: fnd_global.user_id, sysdate,
504: sysdate, fnd_global.user_id, fnd_global.login_id,
505: fnd_global.conc_program_id, fnd_global.conc_login_id,
506: fnd_global.prog_appl_id, fnd_global.conc_request_id
507: from msc_st_items_f f
508: where f.st_transaction_id=l_transfer_id

Line 505: fnd_global.conc_program_id, fnd_global.conc_login_id,

501: sum(total_obs_value2),
502: sum(wh_available_capacity),
503: fnd_global.user_id, sysdate,
504: sysdate, fnd_global.user_id, fnd_global.login_id,
505: fnd_global.conc_program_id, fnd_global.conc_login_id,
506: fnd_global.prog_appl_id, fnd_global.conc_request_id
507: from msc_st_items_f f
508: where f.st_transaction_id=l_transfer_id
509: group by

Line 506: fnd_global.prog_appl_id, fnd_global.conc_request_id

502: sum(wh_available_capacity),
503: fnd_global.user_id, sysdate,
504: sysdate, fnd_global.user_id, fnd_global.login_id,
505: fnd_global.conc_program_id, fnd_global.conc_login_id,
506: fnd_global.prog_appl_id, fnd_global.conc_request_id
507: from msc_st_items_f f
508: where f.st_transaction_id=l_transfer_id
509: group by
510: sr_instance_id,

Line 604: fnd_global.user_id, sysdate,

600: sum(obsolete_onhand_value2),
601: sum(obsolete_onorder_value2),
602: sum(total_obs_value2),
603: sum(wh_available_capacity),
604: fnd_global.user_id, sysdate,
605: sysdate, fnd_global.user_id, fnd_global.login_id,
606: fnd_global.conc_program_id, fnd_global.conc_login_id,
607: fnd_global.prog_appl_id, fnd_global.conc_request_id
608: from

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

601: sum(obsolete_onorder_value2),
602: sum(total_obs_value2),
603: sum(wh_available_capacity),
604: fnd_global.user_id, sysdate,
605: sysdate, fnd_global.user_id, fnd_global.login_id,
606: fnd_global.conc_program_id, fnd_global.conc_login_id,
607: fnd_global.prog_appl_id, fnd_global.conc_request_id
608: from
609: msc_items_f f,

Line 606: fnd_global.conc_program_id, fnd_global.conc_login_id,

602: sum(total_obs_value2),
603: sum(wh_available_capacity),
604: fnd_global.user_id, sysdate,
605: sysdate, fnd_global.user_id, fnd_global.login_id,
606: fnd_global.conc_program_id, fnd_global.conc_login_id,
607: fnd_global.prog_appl_id, fnd_global.conc_request_id
608: from
609: msc_items_f f,
610: msc_phub_item_categories_mv q

Line 607: fnd_global.prog_appl_id, fnd_global.conc_request_id

603: sum(wh_available_capacity),
604: fnd_global.user_id, sysdate,
605: sysdate, fnd_global.user_id, fnd_global.login_id,
606: fnd_global.conc_program_id, fnd_global.conc_login_id,
607: fnd_global.prog_appl_id, fnd_global.conc_request_id
608: from
609: msc_items_f f,
610: msc_phub_item_categories_mv q
611: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id

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

668: ' f.organization_id,'||
669: ' f.inventory_item_id,'||
670: ' mtp.organization_code,'||
671: ' mi.item_name,'||
672: ' fnd_global.user_id, sysdate,'||
673: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
674: ' from'||
675: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
676: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

669: ' f.inventory_item_id,'||
670: ' mtp.organization_code,'||
671: ' mi.item_name,'||
672: ' fnd_global.user_id, sysdate,'||
673: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
674: ' from'||
675: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
676: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
677: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||

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

759: ' f.obsolete_onhand_value2,'||
760: ' f.obsolete_onorder_value2,'||
761: ' f.total_obs_value2,'||
762: ' f.wh_available_capacity,'||
763: ' fnd_global.user_id, sysdate,'||
764: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
765: ' from'||
766: ' '||l_apps_schema||'.msc_items_f'||l_suffix||' f,'||
767: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

760: ' f.obsolete_onorder_value2,'||
761: ' f.total_obs_value2,'||
762: ' f.wh_available_capacity,'||
763: ' fnd_global.user_id, sysdate,'||
764: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
765: ' from'||
766: ' '||l_apps_schema||'.msc_items_f'||l_suffix||' f,'||
767: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
768: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 891: fnd_global.user_id, sysdate,

887: obsolete_onorder_value2,
888: total_obs_value2,
889: wh_available_capacity,
890: 0, -23453, -23453,
891: fnd_global.user_id, sysdate,
892: fnd_global.user_id, sysdate, fnd_global.login_id
893: from msc_st_items_f
894: where st_transaction_id=p_st_transaction_id and error_code=0;
895:

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

888: total_obs_value2,
889: wh_available_capacity,
890: 0, -23453, -23453,
891: fnd_global.user_id, sysdate,
892: fnd_global.user_id, sysdate, fnd_global.login_id
893: from msc_st_items_f
894: where st_transaction_id=p_st_transaction_id and error_code=0;
895:
896: msc_phub_util.log('msc_phub_excess_pkg.import_items_f: inserted='||sql%rowcount);