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 MSC_ST_COSTS_F

Line 29: -- msc_st_costs_f:regular_costs

25: from msc_plan_runs
26: where plan_id=p_plan_id
27: and plan_run_id=p_plan_run_id;
28:
29: -- msc_st_costs_f:regular_costs
30: msc_phub_util.gather_table_stats(msc_phub_util.stats_pds, 'MSC_BIS_INV_DETAIL');
31: insert /*+ append nologging */ into msc_st_costs_f (
32: st_transaction_id,
33: error_code,

Line 31: insert /+ append nologging / into msc_st_costs_f (

27: and plan_run_id=p_plan_run_id;
28:
29: -- msc_st_costs_f:regular_costs
30: msc_phub_util.gather_table_stats(msc_phub_util.stats_pds, 'MSC_BIS_INV_DETAIL');
31: insert /*+ append nologging */ into msc_st_costs_f (
32: st_transaction_id,
33: error_code,
34: owning_inst_id,
35: owning_org_id,

Line 129: msc_phub_util.log('insert into msc_st_costs_f:regular_costs: '||sql%rowcount);

125: decode(sign(mbid.supplier_site_id), 1, mbid.supplier_site_id, -23453),
126: nvl(mbid.ship_method, '-23453'),
127: d.mfg_week_end_date;
128:
129: msc_phub_util.log('insert into msc_st_costs_f:regular_costs: '||sql%rowcount);
130: commit;
131:
132: -- msc_st_costs_f:facility_cost
133: insert /*+ append nologging */ into msc_st_costs_f (

Line 132: -- msc_st_costs_f:facility_cost

128:
129: msc_phub_util.log('insert into msc_st_costs_f:regular_costs: '||sql%rowcount);
130: commit;
131:
132: -- msc_st_costs_f:facility_cost
133: insert /*+ append nologging */ into msc_st_costs_f (
134: st_transaction_id,
135: error_code,
136: owning_inst_id,

Line 133: insert /+ append nologging / into msc_st_costs_f (

129: msc_phub_util.log('insert into msc_st_costs_f:regular_costs: '||sql%rowcount);
130: commit;
131:
132: -- msc_st_costs_f:facility_cost
133: insert /*+ append nologging */ into msc_st_costs_f (
134: st_transaction_id,
135: error_code,
136: owning_inst_id,
137: owning_org_id,

Line 200: msc_phub_util.log('insert into msc_st_costs_f:facility_cost: '||sql%rowcount);

196: mbod.sr_instance_id,
197: mbod.organization_id,
198: d.mfg_week_end_date;
199:
200: msc_phub_util.log('insert into msc_st_costs_f:facility_cost: '||sql%rowcount);
201: commit;
202:
203: if (l_enable_scrm not in (2) and l_plan_type not in (5)) then
204: -- msc_st_costs_f:source_count

Line 204: -- msc_st_costs_f:source_count

200: msc_phub_util.log('insert into msc_st_costs_f:facility_cost: '||sql%rowcount);
201: commit;
202:
203: if (l_enable_scrm not in (2) and l_plan_type not in (5)) then
204: -- msc_st_costs_f:source_count
205: insert /*+ append nologging */ into msc_st_costs_f (
206: st_transaction_id,
207: error_code,
208: owning_inst_id,

Line 205: insert /+ append nologging / into msc_st_costs_f (

201: commit;
202:
203: if (l_enable_scrm not in (2) and l_plan_type not in (5)) then
204: -- msc_st_costs_f:source_count
205: insert /*+ append nologging */ into msc_st_costs_f (
206: st_transaction_id,
207: error_code,
208: owning_inst_id,
209: owning_org_id,

Line 294: msc_phub_util.log('insert into msc_st_costs_f:source_count: '||sql%rowcount);

290: where d.calendar_date between l_plan_start_date and l_plan_cutoff_date
291: and d.calendar_date in (d.mfg_week_end_date, l_plan_cutoff_date)
292: and d.calendar_date between nvl(f.effective_date, l_plan_start_date) and nvl(f.disable_date, l_plan_cutoff_date);
293:
294: msc_phub_util.log('insert into msc_st_costs_f:source_count: '||sql%rowcount);
295: commit;
296: end if;
297:
298: -- msc_st_costs_f:RP

Line 298: -- msc_st_costs_f:RP

294: msc_phub_util.log('insert into msc_st_costs_f:source_count: '||sql%rowcount);
295: commit;
296: end if;
297:
298: -- msc_st_costs_f:RP
299: insert /*+ append nologging */ into msc_st_costs_f (
300: st_transaction_id,
301: error_code,
302: owning_inst_id,

Line 299: insert /+ append nologging / into msc_st_costs_f (

295: commit;
296: end if;
297:
298: -- msc_st_costs_f:RP
299: insert /*+ append nologging */ into msc_st_costs_f (
300: st_transaction_id,
301: error_code,
302: owning_inst_id,
303: owning_org_id,

Line 401: msc_phub_util.log('insert into msc_st_costs_f:RP: '||sql%rowcount);

397: nvl(mrk.supplier_id, -23453),
398: nvl(mrk.supplier_site_id, -23453),
399: d.mfg_week_end_date;
400:
401: msc_phub_util.log('insert into msc_st_costs_f:RP: '||sql%rowcount);
402: commit;
403:
404: -- msc_costs_f:final
405: msc_phub_util.unusuable_local_index('MSC_COSTS_F', p_plan_run_id, 1);

Line 548: msc_st_costs_f f,

544: sum(f.total_component_qty) total_component_qty,
545: sum(f.ready_to_build_qty) ready_to_build_qty,
546: sum(f.total_build_qty) total_build_qty
547: from
548: msc_st_costs_f f,
549: msc_trading_partners mtp
550: where f.st_transaction_id=l_transfer_id
551: and mtp.partner_type(+)=3
552: and f.owning_inst_id=mtp.sr_instance_id(+)

Line 736: delete from msc_st_costs_f where st_transaction_id=p_st_transaction_id;

732: msc_phub_util.log('msc_phub_cost_pkg.export_costs_f');
733: retcode := 0;
734: errbuf := null;
735:
736: delete from msc_st_costs_f where st_transaction_id=p_st_transaction_id;
737: commit;
738:
739: if (p_source_version < '12.1.3') then
740: l_sql :=

Line 741: ' insert into msc_st_costs_f('||

737: commit;
738:
739: if (p_source_version < '12.1.3') then
740: l_sql :=
741: ' insert into msc_st_costs_f('||
742: ' st_transaction_id,'||
743: ' error_code,'||
744: ' owning_inst_id,'||
745: ' owning_org_id,'||

Line 814: ' insert into msc_st_costs_f('||

810: ' and mtp3.sr_tp_id(+)=f.owning_org_id'||
811: ' and mi.inventory_item_id(+)=f.inventory_item_id';
812: else
813: l_sql :=
814: ' insert into msc_st_costs_f('||
815: ' st_transaction_id,'||
816: ' error_code,'||
817: ' owning_inst_id,'||
818: ' owning_org_id,'||

Line 973: l_staging_table varchar2(30) := 'msc_st_costs_f';

969: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
970: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
971: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
972: is
973: l_staging_table varchar2(30) := 'msc_st_costs_f';
974: l_fact_table varchar2(30) := 'msc_costs_f';
975: l_result number := 0;
976: begin
977: msc_phub_util.log('msc_phub_cost_pkg.import_costs_f');

Line 1113: from msc_st_costs_f

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