APPS.MSD_FCST_PUB dependencies on MSD_DP_SCN_ENTRIES_TEMP

Line 409: l_insert := l_insert || 'INTO MSD_DP_SCN_ENTRIES_TEMP' ||

405: IF l_round_off is null THEN
406: l_round_off := 6;
407: END IF;
408:
409: l_insert := l_insert || 'INTO MSD_DP_SCN_ENTRIES_TEMP' ||
410: ' (inventory_item_id, forecast_designator, organization_id, ' ||
411: ' forecast_date, quantity, bucket_type, forecast_end_date) ';
412:
413: -- select

Line 560: DELETE FROM MSD_DP_SCN_ENTRIES_TEMP;

556: -- group_by
557: l_group_by := l_group_by || 'sce.sr_product_lvl_pk, sce.time_lvl_val_from, sce.time_lvl_val_to ';
558:
559: /* Clear Temp table before insertion */
560: DELETE FROM MSD_DP_SCN_ENTRIES_TEMP;
561:
562: /* Insert Forecast into MSD_DP_SCN_ENTRIES_TEMP table first */
563: v_sql_stmt := l_insert || l_select || l_from || l_where || l_group_by;
564: EXECUTE IMMEDIATE v_sql_stmt;

Line 562: /* Insert Forecast into MSD_DP_SCN_ENTRIES_TEMP table first */

558:
559: /* Clear Temp table before insertion */
560: DELETE FROM MSD_DP_SCN_ENTRIES_TEMP;
561:
562: /* Insert Forecast into MSD_DP_SCN_ENTRIES_TEMP table first */
563: v_sql_stmt := l_insert || l_select || l_from || l_where || l_group_by;
564: EXECUTE IMMEDIATE v_sql_stmt;
565:
566: /* Clean up mrp_forecast_interface table before inserting new forecast */

Line 584: ' FROM MSD_DP_SCN_ENTRIES_TEMP ';

580: ' SELECT inventory_item_id, forecast_designator, organization_id, ' ||
581: ' forecast_end_date, quantity, 2, 100, ' ||
582: ' bucket_type, forecast_end_date, SYSDATE, -1, SYSDATE, -1, ' ||
583: to_char(p_workday_control) || ' ' ||
584: ' FROM MSD_DP_SCN_ENTRIES_TEMP ';
585: EXECUTE IMMEDIATE v_sql_stmt;
586:
587: /* Delete temp table after insert forecast into the source */
588: DELETE FROM MSD_DP_SCN_ENTRIES_TEMP;

Line 588: DELETE FROM MSD_DP_SCN_ENTRIES_TEMP;

584: ' FROM MSD_DP_SCN_ENTRIES_TEMP ';
585: EXECUTE IMMEDIATE v_sql_stmt;
586:
587: /* Delete temp table after insert forecast into the source */
588: DELETE FROM MSD_DP_SCN_ENTRIES_TEMP;
589:
590: -- insert into dwk_test10 values(v_sql_stmt);
591:
592: commit;