APPS.MSC_DEMANTRA_PKG dependencies on MSC_DEMANTRA_ODS_F

Line 36: l_ddl := 'truncate table msc_demantra_ods_f';

32: msc_phub_util.log(fnd_message.get_string('MSC', 'MSC_PART_UNDEFINED_SCHEMA'));
33: raise e_truncate_ods_f;
34: end if;
35:
36: l_ddl := 'truncate table msc_demantra_ods_f';
37: ad_ddl.do_ddl(l_applsys_schema, g_msc_schema, ad_ddl.truncate_table, l_ddl, 'MSC_DEMANTRA_ODS_F');
38: commit;
39:
40: exception

Line 37: ad_ddl.do_ddl(l_applsys_schema, g_msc_schema, ad_ddl.truncate_table, l_ddl, 'MSC_DEMANTRA_ODS_F');

33: raise e_truncate_ods_f;
34: end if;
35:
36: l_ddl := 'truncate table msc_demantra_ods_f';
37: ad_ddl.do_ddl(l_applsys_schema, g_msc_schema, ad_ddl.truncate_table, l_ddl, 'MSC_DEMANTRA_ODS_F');
38: commit;
39:
40: exception
41: when others then

Line 1176: delete from msc_demantra_ods_f f where exists (

1172: msc_phub_util.log('msc_demantra_pkg.archive: insert into '||l_target_table||': '||sql%rowcount);
1173: commit;
1174:
1175: if (p_fact_type = 4 and l_publish_mode = 2) then
1176: delete from msc_demantra_ods_f f where exists (
1177: select 1 from msc_st_demantra_ods_f
1178: where st_transaction_id=p_transfer_id and error_code=0
1179: and sr_instance_id=f.sr_instance_id
1180: and organization_id=f.organization_id

Line 1190: msc_phub_util.log('msc_demantra_pkg.archive: delete from msc_demantra_ods_f: '||sql%rowcount);

1186: and region_id=f.region_id
1187: and demand_class=f.demand_class
1188: and end_date=f.end_date
1189: );
1190: msc_phub_util.log('msc_demantra_pkg.archive: delete from msc_demantra_ods_f: '||sql%rowcount);
1191: commit;
1192:
1193: append_from_staging(p_plan_id, p_plan_run_id, p_fact_type, p_transfer_id);
1194: end if;

Line 1695: ' from '||l_apps_schema||'.msc_demantra_ods_f'||l_suffix||

1691: ' shipment_fcst,'||
1692: ' shipment_fcst_cum,'||
1693: ' shipment_fcst_value,'||
1694: ' shipment_fcst_value2'||
1695: ' from '||l_apps_schema||'.msc_demantra_ods_f'||l_suffix||
1696: ' where end_date between :p_plan_start_date and :p_plan_cutoff_date'||
1697: ' ) f,'||
1698: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1699: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 1859: ' '||l_apps_schema||'.msc_demantra_ods_f'||l_suffix||' f,'||

1855: l_sql := l_sql||
1856: ' fnd_global.user_id, sysdate,'||
1857: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1858: ' from'||
1859: ' '||l_apps_schema||'.msc_demantra_ods_f'||l_suffix||' f,'||
1860: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1861: if (p_source_version > '11.5.10') then l_sql := l_sql||
1862: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,';
1863: end if;