APPS.MSC_DEMANTRA_PKG dependencies on MSC_DEMANTRA_F

Line 284: insert into msc_demantra_f (

280: msc_phub_util.log('msc_demantra_pkg.populate_details');
281: retcode := 0;
282: errbuf := '';
283:
284: insert into msc_demantra_f (
285: plan_id,
286: plan_run_id,
287: sr_instance_id,
288: organization_id,

Line 833: delete from msc_demantra_f

829: if (p_fact_type <> 5) then
830: return;
831: end if;
832:
833: delete from msc_demantra_f
834: where plan_id=p_plan_id and plan_run_id=p_plan_run_id and aggr_type>0;
835: msc_phub_util.log('msc_demantra_pkg.summarize, delete='||sql%rowcount);
836: commit;
837:

Line 839: ' insert into msc_demantra_f ('||LF||

835: msc_phub_util.log('msc_demantra_pkg.summarize, delete='||sql%rowcount);
836: commit;
837:
838: l_sql :=
839: ' insert into msc_demantra_f ('||LF||
840: ' plan_id, plan_run_id,'||LF||
841: ' sr_instance_id, organization_id, owning_inst_id, owning_org_id,'||LF||
842: ' inventory_item_id,'||LF||
843: ' customer_id, customer_site_id, region_id,'||LF||

Line 866: ' msc_demantra_f f,'||LF||

862: ' sysdate, fnd_global.user_id, fnd_global.login_id,'||LF||
863: ' fnd_global.conc_program_id, fnd_global.conc_login_id,'||LF||
864: ' fnd_global.prog_appl_id, fnd_global.conc_request_id'||LF||
865: ' from'||LF||
866: ' msc_demantra_f f,'||LF||
867: ' msc_phub_item_categories_mv q'||LF||
868: ' where f.plan_id='||p_plan_id||' and f.plan_run_id='||p_plan_run_id||LF||
869: ' and f.aggr_type=0'||LF||
870: ' and f.owning_inst_id=q.sr_instance_id(+)'||LF||

Line 1491: ' '||l_apps_schema||'.msc_demantra_f'||l_suffix||' f,'||

1487: ' f.attribute10,'||
1488: ' fnd_global.user_id, sysdate,'||
1489: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1490: ' from'||
1491: ' '||l_apps_schema||'.msc_demantra_f'||l_suffix||' f,'||
1492: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1493: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||
1494: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||
1495: ' '||l_apps_schema||'.msc_phub_customers_mv'||l_suffix||' cmv'||

Line 1515: ' from '||l_apps_schema||'.msc_demantra_f'||l_suffix||

1511: msc_phub_util.log('msc_demantra_pkg.export_demantra_f: insert into msc_st_demantra_f: '||sql%rowcount);
1512: else
1513: l_sql :=
1514: ' select min(start_date), max(start_date)'||
1515: ' from '||l_apps_schema||'.msc_demantra_f'||l_suffix||
1516: ' where plan_run_id=:p_plan_run_id and aggr_type=0';
1517:
1518: msc_phub_util.log_sql(l_sql);
1519: execute immediate l_sql into l_plan_start_date, l_plan_cutoff_date using p_plan_run_id;

Line 1655: ' from '||l_apps_schema||'.msc_demantra_f'||l_suffix||

1651: ' to_number(null) shipment_fcst,'||
1652: ' to_number(null) shipment_fcst_cum,'||
1653: ' to_number(null) shipment_fcst_value,'||
1654: ' to_number(null) shipment_fcst_value2'||
1655: ' from '||l_apps_schema||'.msc_demantra_f'||l_suffix||
1656: ' where plan_run_id=:p_plan_run_id and aggr_type=0'||
1657: ' union all'||
1658: ' select'||
1659: ' sr_instance_id,'||