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

Line 65: fnd_global.user_id, sysdate,

61: f.supplier_site_id,
62: d.date2 analysis_date,
63: sum(f.required_qty) required_qty,
64:
65: fnd_global.user_id, sysdate,
66: sysdate, fnd_global.user_id, fnd_global.login_id,
67: fnd_global.conc_program_id, fnd_global.conc_login_id,
68: fnd_global.prog_appl_id, fnd_global.conc_request_id
69: from

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

62: d.date2 analysis_date,
63: sum(f.required_qty) required_qty,
64:
65: fnd_global.user_id, sysdate,
66: sysdate, fnd_global.user_id, fnd_global.login_id,
67: fnd_global.conc_program_id, fnd_global.conc_login_id,
68: fnd_global.prog_appl_id, fnd_global.conc_request_id
69: from
70: (select

Line 67: fnd_global.conc_program_id, fnd_global.conc_login_id,

63: sum(f.required_qty) required_qty,
64:
65: fnd_global.user_id, sysdate,
66: sysdate, fnd_global.user_id, fnd_global.login_id,
67: fnd_global.conc_program_id, fnd_global.conc_login_id,
68: fnd_global.prog_appl_id, fnd_global.conc_request_id
69: from
70: (select
71: msr.sr_instance_id,

Line 68: fnd_global.prog_appl_id, fnd_global.conc_request_id

64:
65: fnd_global.user_id, sysdate,
66: sysdate, fnd_global.user_id, fnd_global.login_id,
67: fnd_global.conc_program_id, fnd_global.conc_login_id,
68: fnd_global.prog_appl_id, fnd_global.conc_request_id
69: from
70: (select
71: msr.sr_instance_id,
72: msr.organization_id,

Line 154: fnd_global.user_id,

150: number4 -- organization_id
151: )
152: select distinct l_qid_orgs,
153: sysdate,
154: fnd_global.user_id,
155: sysdate,
156: fnd_global.user_id,
157: fnd_global.login_id,
158: f.sr_instance_id,

Line 156: fnd_global.user_id,

152: select distinct l_qid_orgs,
153: sysdate,
154: fnd_global.user_id,
155: sysdate,
156: fnd_global.user_id,
157: fnd_global.login_id,
158: f.sr_instance_id,
159: f.organization_id
160: from msc_st_suppliers_f f

Line 157: fnd_global.login_id,

153: sysdate,
154: fnd_global.user_id,
155: sysdate,
156: fnd_global.user_id,
157: fnd_global.login_id,
158: f.sr_instance_id,
159: f.organization_id
160: from msc_st_suppliers_f f
161: where f.st_transaction_id=l_transfer_id

Line 181: fnd_global.user_id,

177: number4 -- organization_id
178: )
179: select distinct l_qid_orgs,
180: sysdate,
181: fnd_global.user_id,
182: sysdate,
183: fnd_global.user_id,
184: fnd_global.login_id,
185: l_sr_instance_id,

Line 183: fnd_global.user_id,

179: select distinct l_qid_orgs,
180: sysdate,
181: fnd_global.user_id,
182: sysdate,
183: fnd_global.user_id,
184: fnd_global.login_id,
185: l_sr_instance_id,
186: -23453
187: from dual;

Line 184: fnd_global.login_id,

180: sysdate,
181: fnd_global.user_id,
182: sysdate,
183: fnd_global.user_id,
184: fnd_global.login_id,
185: l_sr_instance_id,
186: -23453
187: from dual;
188:

Line 217: fnd_global.user_id, sysdate,

213: f.supplier_site_id,
214: d.date2 analysis_date,
215: sum(f.avail_qty) avail_qty,
216:
217: fnd_global.user_id, sysdate,
218: sysdate, fnd_global.user_id, fnd_global.login_id,
219: fnd_global.conc_program_id, fnd_global.conc_login_id,
220: fnd_global.prog_appl_id, fnd_global.conc_request_id
221: from

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

214: d.date2 analysis_date,
215: sum(f.avail_qty) avail_qty,
216:
217: fnd_global.user_id, sysdate,
218: sysdate, fnd_global.user_id, fnd_global.login_id,
219: fnd_global.conc_program_id, fnd_global.conc_login_id,
220: fnd_global.prog_appl_id, fnd_global.conc_request_id
221: from
222: (select distinct

Line 219: fnd_global.conc_program_id, fnd_global.conc_login_id,

215: sum(f.avail_qty) avail_qty,
216:
217: fnd_global.user_id, sysdate,
218: sysdate, fnd_global.user_id, fnd_global.login_id,
219: fnd_global.conc_program_id, fnd_global.conc_login_id,
220: fnd_global.prog_appl_id, fnd_global.conc_request_id
221: from
222: (select distinct
223: mscp.inventory_item_id,

Line 220: fnd_global.prog_appl_id, fnd_global.conc_request_id

216:
217: fnd_global.user_id, sysdate,
218: sysdate, fnd_global.user_id, fnd_global.login_id,
219: fnd_global.conc_program_id, fnd_global.conc_login_id,
220: fnd_global.prog_appl_id, fnd_global.conc_request_id
221: from
222: (select distinct
223: mscp.inventory_item_id,
224: mscp.supplier_id,

Line 307: fnd_global.user_id, sysdate,

303: f.analysis_date,
304: sum(avail_qty) avail_qty,
305: sum(nvl(f.avail_qty,0) - nvl(f.required_qty,0)) net_avail_qty,
306:
307: fnd_global.user_id, sysdate,
308: sysdate, fnd_global.user_id, fnd_global.login_id,
309: fnd_global.conc_program_id, fnd_global.conc_login_id,
310: fnd_global.prog_appl_id, fnd_global.conc_request_id
311: from

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

304: sum(avail_qty) avail_qty,
305: sum(nvl(f.avail_qty,0) - nvl(f.required_qty,0)) net_avail_qty,
306:
307: fnd_global.user_id, sysdate,
308: sysdate, fnd_global.user_id, fnd_global.login_id,
309: fnd_global.conc_program_id, fnd_global.conc_login_id,
310: fnd_global.prog_appl_id, fnd_global.conc_request_id
311: from
312: (select

Line 309: fnd_global.conc_program_id, fnd_global.conc_login_id,

305: sum(nvl(f.avail_qty,0) - nvl(f.required_qty,0)) net_avail_qty,
306:
307: fnd_global.user_id, sysdate,
308: sysdate, fnd_global.user_id, fnd_global.login_id,
309: fnd_global.conc_program_id, fnd_global.conc_login_id,
310: fnd_global.prog_appl_id, fnd_global.conc_request_id
311: from
312: (select
313: f.inventory_item_id,

Line 310: fnd_global.prog_appl_id, fnd_global.conc_request_id

306:
307: fnd_global.user_id, sysdate,
308: sysdate, fnd_global.user_id, fnd_global.login_id,
309: fnd_global.conc_program_id, fnd_global.conc_login_id,
310: fnd_global.prog_appl_id, fnd_global.conc_request_id
311: from
312: (select
313: f.inventory_item_id,
314: f.supplier_id,

Line 381: fnd_global.user_id, sysdate,

377: sum(f.required_qty) required_qty,
378: sum(f.avail_qty) avail_qty,
379: sum(f.net_avail_qty) net_avail_qty,
380:
381: fnd_global.user_id, sysdate,
382: sysdate, fnd_global.user_id, fnd_global.login_id,
383: fnd_global.conc_program_id, fnd_global.conc_login_id,
384: fnd_global.prog_appl_id, fnd_global.conc_request_id
385: from

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

378: sum(f.avail_qty) avail_qty,
379: sum(f.net_avail_qty) net_avail_qty,
380:
381: fnd_global.user_id, sysdate,
382: sysdate, fnd_global.user_id, fnd_global.login_id,
383: fnd_global.conc_program_id, fnd_global.conc_login_id,
384: fnd_global.prog_appl_id, fnd_global.conc_request_id
385: from
386: (select

Line 383: fnd_global.conc_program_id, fnd_global.conc_login_id,

379: sum(f.net_avail_qty) net_avail_qty,
380:
381: fnd_global.user_id, sysdate,
382: sysdate, fnd_global.user_id, fnd_global.login_id,
383: fnd_global.conc_program_id, fnd_global.conc_login_id,
384: fnd_global.prog_appl_id, fnd_global.conc_request_id
385: from
386: (select
387: f.sr_instance_id,

Line 384: fnd_global.prog_appl_id, fnd_global.conc_request_id

380:
381: fnd_global.user_id, sysdate,
382: sysdate, fnd_global.user_id, fnd_global.login_id,
383: fnd_global.conc_program_id, fnd_global.conc_login_id,
384: fnd_global.prog_appl_id, fnd_global.conc_request_id
385: from
386: (select
387: f.sr_instance_id,
388: f.organization_id,

Line 456: fnd_global.user_id, sysdate,

452: f.supplier_site_id,
453: d.date2 analysis_date,
454: sum(f.net_avail_qty) net_avail_qty_cum,
455:
456: fnd_global.user_id, sysdate,
457: sysdate, fnd_global.user_id, fnd_global.login_id,
458: fnd_global.conc_program_id, fnd_global.conc_login_id,
459: fnd_global.prog_appl_id, fnd_global.conc_request_id
460: from

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

453: d.date2 analysis_date,
454: sum(f.net_avail_qty) net_avail_qty_cum,
455:
456: fnd_global.user_id, sysdate,
457: sysdate, fnd_global.user_id, fnd_global.login_id,
458: fnd_global.conc_program_id, fnd_global.conc_login_id,
459: fnd_global.prog_appl_id, fnd_global.conc_request_id
460: from
461: msc_st_suppliers_f f,

Line 458: fnd_global.conc_program_id, fnd_global.conc_login_id,

454: sum(f.net_avail_qty) net_avail_qty_cum,
455:
456: fnd_global.user_id, sysdate,
457: sysdate, fnd_global.user_id, fnd_global.login_id,
458: fnd_global.conc_program_id, fnd_global.conc_login_id,
459: fnd_global.prog_appl_id, fnd_global.conc_request_id
460: from
461: msc_st_suppliers_f f,
462: msc_hub_query d

Line 459: fnd_global.prog_appl_id, fnd_global.conc_request_id

455:
456: fnd_global.user_id, sysdate,
457: sysdate, fnd_global.user_id, fnd_global.login_id,
458: fnd_global.conc_program_id, fnd_global.conc_login_id,
459: fnd_global.prog_appl_id, fnd_global.conc_request_id
460: from
461: msc_st_suppliers_f f,
462: msc_hub_query d
463: where f.st_transaction_id=l_transfer_id

Line 523: fnd_global.user_id, sysdate,

519: sum(f.avail_qty) avail_qty,
520: sum(f.net_avail_qty) net_avail_qty,
521: sum(f.net_avail_qty_cum) net_avail_qty_cum,
522:
523: fnd_global.user_id, sysdate,
524: sysdate, fnd_global.user_id, fnd_global.login_id,
525: fnd_global.conc_program_id, fnd_global.conc_login_id,
526: fnd_global.prog_appl_id, fnd_global.conc_request_id
527: from msc_st_suppliers_f f

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

520: sum(f.net_avail_qty) net_avail_qty,
521: sum(f.net_avail_qty_cum) net_avail_qty_cum,
522:
523: fnd_global.user_id, sysdate,
524: sysdate, fnd_global.user_id, fnd_global.login_id,
525: fnd_global.conc_program_id, fnd_global.conc_login_id,
526: fnd_global.prog_appl_id, fnd_global.conc_request_id
527: from msc_st_suppliers_f f
528: where f.st_transaction_id=l_transfer_id

Line 525: fnd_global.conc_program_id, fnd_global.conc_login_id,

521: sum(f.net_avail_qty_cum) net_avail_qty_cum,
522:
523: fnd_global.user_id, sysdate,
524: sysdate, fnd_global.user_id, fnd_global.login_id,
525: fnd_global.conc_program_id, fnd_global.conc_login_id,
526: fnd_global.prog_appl_id, fnd_global.conc_request_id
527: from msc_st_suppliers_f f
528: where f.st_transaction_id=l_transfer_id
529: and f.error_code in (4,5)

Line 526: fnd_global.prog_appl_id, fnd_global.conc_request_id

522:
523: fnd_global.user_id, sysdate,
524: sysdate, fnd_global.user_id, fnd_global.login_id,
525: fnd_global.conc_program_id, fnd_global.conc_login_id,
526: fnd_global.prog_appl_id, fnd_global.conc_request_id
527: from msc_st_suppliers_f f
528: where f.st_transaction_id=l_transfer_id
529: and f.error_code in (4,5)
530: group by

Line 599: fnd_global.user_id, sysdate,

595: sum(f.required_qty),
596: sum(f.avail_qty),
597: sum(f.net_avail_qty),
598: sum(f.net_avail_qty_cum),
599: fnd_global.user_id, sysdate,
600: sysdate, fnd_global.user_id, fnd_global.login_id,
601: fnd_global.conc_program_id, fnd_global.conc_login_id,
602: fnd_global.prog_appl_id, fnd_global.conc_request_id
603: from

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

596: sum(f.avail_qty),
597: sum(f.net_avail_qty),
598: sum(f.net_avail_qty_cum),
599: fnd_global.user_id, sysdate,
600: sysdate, fnd_global.user_id, fnd_global.login_id,
601: fnd_global.conc_program_id, fnd_global.conc_login_id,
602: fnd_global.prog_appl_id, fnd_global.conc_request_id
603: from
604: msc_suppliers_f f,

Line 601: fnd_global.conc_program_id, fnd_global.conc_login_id,

597: sum(f.net_avail_qty),
598: sum(f.net_avail_qty_cum),
599: fnd_global.user_id, sysdate,
600: sysdate, fnd_global.user_id, fnd_global.login_id,
601: fnd_global.conc_program_id, fnd_global.conc_login_id,
602: fnd_global.prog_appl_id, fnd_global.conc_request_id
603: from
604: msc_suppliers_f f,
605: msc_phub_item_categories_mv q

Line 602: fnd_global.prog_appl_id, fnd_global.conc_request_id

598: sum(f.net_avail_qty_cum),
599: fnd_global.user_id, sysdate,
600: sysdate, fnd_global.user_id, fnd_global.login_id,
601: fnd_global.conc_program_id, fnd_global.conc_login_id,
602: fnd_global.prog_appl_id, fnd_global.conc_request_id
603: from
604: msc_suppliers_f f,
605: msc_phub_item_categories_mv q
606: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id

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

687: ' f.required_qty,'||
688: ' f.avail_qty,'||
689: ' f.net_avail_qty,'||
690: ' f.net_avail_qty_cum,'||
691: ' fnd_global.user_id, sysdate,'||
692: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
693: ' from'||
694: ' '||l_apps_schema||'.msc_suppliers_f'||l_suffix||' f,'||
695: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

688: ' f.avail_qty,'||
689: ' f.net_avail_qty,'||
690: ' f.net_avail_qty_cum,'||
691: ' fnd_global.user_id, sysdate,'||
692: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
693: ' from'||
694: ' '||l_apps_schema||'.msc_suppliers_f'||l_suffix||' f,'||
695: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
696: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 797: fnd_global.user_id, sysdate,

793: avail_qty,
794: net_avail_qty,
795: net_avail_qty_cum,
796: 0, -23453, -23453,
797: fnd_global.user_id, sysdate,
798: fnd_global.user_id, sysdate, fnd_global.login_id
799: from msc_st_suppliers_f
800: where st_transaction_id=p_st_transaction_id and error_code=0;
801:

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

794: net_avail_qty,
795: net_avail_qty_cum,
796: 0, -23453, -23453,
797: fnd_global.user_id, sysdate,
798: fnd_global.user_id, sysdate, fnd_global.login_id
799: from msc_st_suppliers_f
800: where st_transaction_id=p_st_transaction_id and error_code=0;
801:
802: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f: inserted='||sql%rowcount);