[Home] [Help]
153:
154:
155: if l_item_simulation_set_id is not null then
156: -- msc_items_f:eo
157: insert /*+ append nologging */ into msc_st_items_f (
158: st_transaction_id,
159: error_code,
160: sr_instance_id,
161: organization_id,
340: sdt.sr_instance_id,
341: sdt.organization_id,
342: sdt.inventory_item_id;
343:
344: msc_phub_util.log('insert into msc_st_items_f:eo: '||sql%rowcount);
345: commit;
346: end if;
347:
348: if (l_enforce_wh_cpty = 1 and l_plan_type = 4) then
347:
348: if (l_enforce_wh_cpty = 1 and l_plan_type = 4) then
349: if (nvl(fnd_profile.value('MSR_ORGANIZATION_WAREHOUSE_CAPACITY'),1) = 1) then
350: -- msc_items_f:wh_available_capacity
351: insert /*+ append nologging */ into msc_st_items_f (
352: st_transaction_id,
353: error_code,
354: sr_instance_id,
355: organization_id,
385: and mtp.maximum_volume is not null
386: and mtp.volume_uom=uc.uom_code
387: and mtp.sr_instance_id=uc.sr_instance_id
388: and uc.inventory_item_id=0;
389: msc_phub_util.log('insert into msc_st_items_f:wh_available_capacity: '||sql%rowcount);
390: commit;
391: else
392: -- msc_items_f:wh_available_capacity_cat
393: insert /*+ append nologging */ into msc_st_items_f (
389: msc_phub_util.log('insert into msc_st_items_f:wh_available_capacity: '||sql%rowcount);
390: commit;
391: else
392: -- msc_items_f:wh_available_capacity_cat
393: insert /*+ append nologging */ into msc_st_items_f (
394: st_transaction_id,
395: error_code,
396: sr_instance_id,
397: organization_id,
425: and po.organization_id=mwc.organization_id
426: and mwc.capacity_uom=uc.uom_code(+)
427: and mwc.sr_instance_id=uc.sr_instance_id(+)
428: and uc.inventory_item_id(+)=0;
429: msc_phub_util.log('insert into msc_st_items_f:wh_available_capacity_cat: '||sql%rowcount);
430: commit;
431: end if;
432: end if;
433:
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,
511: organization_id,
644: msc_phub_util.log('msc_phub_excess_pkg.export_items_f');
645: retcode := 0;
646: errbuf := null;
647:
648: delete from msc_st_items_f where st_transaction_id=p_st_transaction_id;
649: commit;
650:
651: if (p_source_version = '11.5.10') then
652: l_sql :=
649: commit;
650:
651: if (p_source_version = '11.5.10') then
652: l_sql :=
653: ' insert into msc_st_items_f('||
654: ' st_transaction_id,'||
655: ' error_code,'||
656: ' sr_instance_id,'||
657: ' organization_id,'||
688: ' mtp.organization_code,'||
689: ' mi.item_name';
690: else
691: l_sql :=
692: ' insert into msc_st_items_f('||
693: ' st_transaction_id,'||
694: ' error_code,'||
695: ' sr_instance_id,'||
696: ' organization_id,'||
797: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
798: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
799: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
800: is
801: l_staging_table varchar2(30) := 'msc_st_items_f';
802: l_fact_table varchar2(30) := 'msc_items_f';
803: l_result number := 0;
804: begin
805: msc_phub_util.log('msc_phub_excess_pkg.import_items_f');
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);
897: commit;