APPS.MRP_CL_FUNCTION dependencies on MSC_SR_ZN_AGGR_IBUC

Line 2378: lv_sql_stmt := 'Truncate table '|| MSC_UTIL.G_MSC_SCHEMA || '.MSC_SR_ZN_AGGR_IBUC';

2374: BEGIN
2375: /*Aggregate the quantity based on the item, date, quantity */
2376:
2377: if lv_purge_flag = 'Y' then
2378: lv_sql_stmt := 'Truncate table '|| MSC_UTIL.G_MSC_SCHEMA || '.MSC_SR_ZN_AGGR_IBUC';
2379: EXECUTE IMMEDIATE lv_sql_stmt;
2380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Truncated table MSC_SR_ZN_AGGR_IBUC');
2381:
2382: elsif lv_purge_flag = 'N' THEN

Line 2380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Truncated table MSC_SR_ZN_AGGR_IBUC');

2376:
2377: if lv_purge_flag = 'Y' then
2378: lv_sql_stmt := 'Truncate table '|| MSC_UTIL.G_MSC_SCHEMA || '.MSC_SR_ZN_AGGR_IBUC';
2379: EXECUTE IMMEDIATE lv_sql_stmt;
2380: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Truncated table MSC_SR_ZN_AGGR_IBUC');
2381:
2382: elsif lv_purge_flag = 'N' THEN
2383: /* In case of net-change coll, we are deleting the data of the start date
2384: alone, to avoid unique constraint, as data would have been collected in the

Line 2386: Delete from msc_sr_zn_aggr_ibuc where sample_date = orig_st_date;

2382: elsif lv_purge_flag = 'N' THEN
2383: /* In case of net-change coll, we are deleting the data of the start date
2384: alone, to avoid unique constraint, as data would have been collected in the
2385: Complete Refresh on the same day. */
2386: Delete from msc_sr_zn_aggr_ibuc where sample_date = orig_st_date;
2387: end if ;
2388:
2389:
2390: v_curr_date := orig_st_date;

Line 2392: insert into msc_sr_zn_aggr_ibuc

2388:
2389:
2390: v_curr_date := orig_st_date;
2391: LOOP --for each day
2392: insert into msc_sr_zn_aggr_ibuc
2393: (sr_inventory_item_id,
2394: sample_date,
2395: zone,
2396: region_id,

Line 2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Completed inserting data into MSC_SR_ZN_AGGR_IBUC');

2427:
2428:
2429: COMMIT;
2430:
2431: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS,'Completed inserting data into MSC_SR_ZN_AGGR_IBUC');
2432:
2433: BEGIN
2434: lv_sql_stmt := 'DROP INDEX ' || MSC_UTIL.G_MSC_SCHEMA || '.MSC_IB_CONTRACTS_TEMP_N1';
2435: EXECUTE IMMEDIATE lv_sql_stmt;