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 MSC_ST_SUPPLIERS_F

Line 38: -- msc_st_suppliers_f:required

34: end if;
35:
36: l_qid_last_date := msc_phub_util.get_reporting_dates(l_plan_start_date, l_plan_cutoff_date);
37:
38: -- msc_st_suppliers_f:required
39: insert /*+ append nologging */ into msc_st_suppliers_f (
40: st_transaction_id,
41: error_code,
42: sr_instance_id,

Line 39: insert /+ append nologging / into msc_st_suppliers_f (

35:
36: l_qid_last_date := msc_phub_util.get_reporting_dates(l_plan_start_date, l_plan_cutoff_date);
37:
38: -- msc_st_suppliers_f:required
39: insert /*+ append nologging */ into msc_st_suppliers_f (
40: st_transaction_id,
41: error_code,
42: sr_instance_id,
43: organization_id,

Line 137: msc_phub_util.log('insert into msc_st_suppliers_f:required: '||sql%rowcount);

133: f.supplier_id,
134: f.supplier_site_id,
135: d.date2;
136:
137: msc_phub_util.log('insert into msc_st_suppliers_f:required: '||sql%rowcount);
138: commit;
139:
140: -- l_qid_orgs
141: select msc_hub_query_s.nextval into l_qid_orgs from dual;

Line 160: from msc_st_suppliers_f f

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
162: and f.error_code in (1);
163:
164: l_rowcount := sql%rowcount;

Line 194: -- msc_st_suppliers_f:available

190: commit;
191: end if;
192:
193:
194: -- msc_st_suppliers_f:available
195: insert /*+ append nologging */ into msc_st_suppliers_f (
196: st_transaction_id,
197: error_code,
198: inventory_item_id,

Line 195: insert /+ append nologging / into msc_st_suppliers_f (

191: end if;
192:
193:
194: -- msc_st_suppliers_f:available
195: insert /*+ append nologging */ into msc_st_suppliers_f (
196: st_transaction_id,
197: error_code,
198: inventory_item_id,
199: supplier_id,

Line 279: msc_phub_util.log('insert into msc_st_suppliers_f:available: '||sql%rowcount);

275: f.supplier_id,
276: f.supplier_site_id,
277: d.date2;
278:
279: msc_phub_util.log('insert into msc_st_suppliers_f:available: '||sql%rowcount);
280: commit;
281:
282: -- msc_st_suppliers_f:net
283: insert /*+ append nologging */ into msc_st_suppliers_f (

Line 282: -- msc_st_suppliers_f:net

278:
279: msc_phub_util.log('insert into msc_st_suppliers_f:available: '||sql%rowcount);
280: commit;
281:
282: -- msc_st_suppliers_f:net
283: insert /*+ append nologging */ into msc_st_suppliers_f (
284: st_transaction_id,
285: error_code,
286: inventory_item_id,

Line 283: insert /+ append nologging / into msc_st_suppliers_f (

279: msc_phub_util.log('insert into msc_st_suppliers_f:available: '||sql%rowcount);
280: commit;
281:
282: -- msc_st_suppliers_f:net
283: insert /*+ append nologging */ into msc_st_suppliers_f (
284: st_transaction_id,
285: error_code,
286: inventory_item_id,
287: supplier_id,

Line 319: from msc_st_suppliers_f f

315: f.supplier_site_id,
316: f.analysis_date,
317: f.avail_qty,
318: f.required_qty
319: from msc_st_suppliers_f f
320: where f.st_transaction_id=l_transfer_id
321: and f.error_code in (1)
322: and exists (
323: select 1

Line 324: from msc_st_suppliers_f f2

320: where f.st_transaction_id=l_transfer_id
321: and f.error_code in (1)
322: and exists (
323: select 1
324: from msc_st_suppliers_f f2
325: where f2.error_code in (2)
326: and f.inventory_item_id=f2.inventory_item_id
327: and f.supplier_id=f2.supplier_id
328: and f.supplier_site_id=f2.supplier_site_id)

Line 337: from msc_st_suppliers_f f

333: f.supplier_site_id,
334: f.analysis_date,
335: f.avail_qty,
336: f.required_qty
337: from msc_st_suppliers_f f
338: where f.st_transaction_id=l_transfer_id
339: and f.error_code in (2)
340: ) f
341: group by

Line 347: msc_phub_util.log('insert into msc_st_suppliers_f:net: '||sql%rowcount);

343: f.supplier_id,
344: f.supplier_site_id,
345: f.analysis_date;
346:
347: msc_phub_util.log('insert into msc_st_suppliers_f:net: '||sql%rowcount);
348: commit;
349:
350: -- msc_st_suppliers_f:distributed
351: insert /*+ append nologging */ into msc_st_suppliers_f (

Line 350: -- msc_st_suppliers_f:distributed

346:
347: msc_phub_util.log('insert into msc_st_suppliers_f:net: '||sql%rowcount);
348: commit;
349:
350: -- msc_st_suppliers_f:distributed
351: insert /*+ append nologging */ into msc_st_suppliers_f (
352: st_transaction_id,
353: error_code,
354: sr_instance_id,

Line 351: insert /+ append nologging / into msc_st_suppliers_f (

347: msc_phub_util.log('insert into msc_st_suppliers_f:net: '||sql%rowcount);
348: commit;
349:
350: -- msc_st_suppliers_f:distributed
351: insert /*+ append nologging */ into msc_st_suppliers_f (
352: st_transaction_id,
353: error_code,
354: sr_instance_id,
355: organization_id,

Line 396: from msc_st_suppliers_f f

392: f.analysis_date,
393: f.required_qty,
394: to_number(null) avail_qty,
395: to_number(null) net_avail_qty
396: from msc_st_suppliers_f f
397: where f.st_transaction_id=l_transfer_id
398: and f.error_code in (1)
399: union all
400: select

Line 411: msc_st_suppliers_f f,

407: to_number(null) required_qty,
408: f.avail_qty avail_qty,
409: (case when nvl(f.net_avail_qty,0) < 0 then 0 else f.net_avail_qty end) net_avail_qty
410: from
411: msc_st_suppliers_f f,
412: msc_hub_query o
413: where f.st_transaction_id=l_transfer_id
414: and f.error_code in (3)
415: and o.query_id=l_qid_orgs

Line 425: msc_phub_util.log('insert into msc_st_suppliers_f:distributed: '||sql%rowcount);

421: f.supplier_id,
422: f.supplier_site_id,
423: f.analysis_date;
424:
425: msc_phub_util.log('insert into msc_st_suppliers_f:distributed: '||sql%rowcount);
426: commit;
427:
428: if (l_enable_num not in (2)) then
429: -- msc_st_suppliers_f:cum

Line 429: -- msc_st_suppliers_f:cum

425: msc_phub_util.log('insert into msc_st_suppliers_f:distributed: '||sql%rowcount);
426: commit;
427:
428: if (l_enable_num not in (2)) then
429: -- msc_st_suppliers_f:cum
430: insert /*+ append nologging */ into msc_st_suppliers_f (
431: st_transaction_id,
432: error_code,
433: sr_instance_id,

Line 430: insert /+ append nologging / into msc_st_suppliers_f (

426: commit;
427:
428: if (l_enable_num not in (2)) then
429: -- msc_st_suppliers_f:cum
430: insert /*+ append nologging */ into msc_st_suppliers_f (
431: st_transaction_id,
432: error_code,
433: sr_instance_id,
434: organization_id,

Line 461: msc_st_suppliers_f f,

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
464: and f.error_code in (4)
465: and d.query_id=l_qid_last_date

Line 474: msc_phub_util.log('insert into msc_st_suppliers_f:cum: '||sql%rowcount);

470: f.inventory_item_id,
471: f.supplier_id,
472: f.supplier_site_id,
473: d.date2;
474: msc_phub_util.log('insert into msc_st_suppliers_f:cum: '||sql%rowcount);
475: commit;
476: end if;
477:
478: -- msc_st_suppliers_f:final

Line 478: -- msc_st_suppliers_f:final

474: msc_phub_util.log('insert into msc_st_suppliers_f:cum: '||sql%rowcount);
475: commit;
476: end if;
477:
478: -- msc_st_suppliers_f:final
479: msc_phub_util.unusuable_local_index('MSC_SUPPLIERS_F', p_plan_run_id, 1);
480: insert into msc_suppliers_f (
481: plan_id,
482: plan_run_id,

Line 527: from msc_st_suppliers_f f

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
531: f.sr_instance_id,

Line 644: delete from msc_st_suppliers_f where st_transaction_id=p_st_transaction_id;

640: msc_phub_util.log('msc_supplier_pkg.export_suppliers_f');
641: retcode := 0;
642: errbuf := null;
643:
644: delete from msc_st_suppliers_f where st_transaction_id=p_st_transaction_id;
645: commit;
646:
647: l_sql :=
648: ' insert into msc_st_suppliers_f('||

Line 648: ' insert into msc_st_suppliers_f('||

644: delete from msc_st_suppliers_f where st_transaction_id=p_st_transaction_id;
645: commit;
646:
647: l_sql :=
648: ' insert into msc_st_suppliers_f('||
649: ' st_transaction_id,'||
650: ' error_code,'||
651: ' sr_instance_id,'||
652: ' organization_id,'||

Line 728: l_staging_table varchar2(30) := 'msc_st_suppliers_f';

724: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
725: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
726: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
727: is
728: l_staging_table varchar2(30) := 'msc_st_suppliers_f';
729: l_fact_table varchar2(30) := 'msc_suppliers_f';
730: l_result number := 0;
731: begin
732: msc_phub_util.log('msc_supplier_pkg.import_suppliers_f');

Line 799: from msc_st_suppliers_f

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);
803: commit;