APPS.MSD_SPF_COLLECT_HISTORY_DATA dependencies on MSD_DEM_DATES

Line 137: x_key_values := x_key_values || '$C_DEM_DEST_DATES#' || ', msd_dem_dates inp ' ||

133: '$C_MMT_TIME_CLAUSE#' || x_mmt_time_clause ||
134: '$C_SSH_DEST_DATE#' || c_ssh_source_date_col || -- bug#12675064
135: '$C_SSH_TIME_CLAUSE#' || x_ssh_time_clause ; -- bug#12675064
136: else
137: x_key_values := x_key_values || '$C_DEM_DEST_DATES#' || ', msd_dem_dates inp ' ||
138: '$C_CDL_DEST_DATE#' || 'inp.start_date' ||
139: '$C_MMT_DEST_DATE#' || 'inp.start_date' ||
140: '$C_CDL_TIME_CLAUSE#' || x_cdl_time_clause || ' AND ' || c_cdl_source_date_col || ' between inp.start_date and inp.end_date ' ||
141: '$C_MMT_TIME_CLAUSE#' || x_mmt_time_clause || ' AND ' || c_mmt_source_date_col || ' between inp.start_date and inp.end_date ' ||

Line 1736: || ' msd_dem_dates mdd '

1732: var_sql := 'INSERT /*+ APPEND */ INTO ' || g_schema || '.BIIO_SPF_SPARES_HIST_DATA NOLOGGING '
1733: || ' (SDATE, LEVEL1, LEVEL2, SPF_ACTUAL_QUANTITY_DEP) '
1734: || ' SELECT mdd.datet, tsst.dm_item_code, tsst.dm_org_code, sum(tsst.ebs_ship_hist_ship_qty_sd) '
1735: || ' FROM ' || g_schema || '.t_src_sales_tmpl tsst, '
1736: || ' msd_dem_dates mdd '
1737: || ' WHERE tsst.sales_date BETWEEN mdd.start_date AND mdd.end_date '
1738: || ' GROUP BY tsst.dm_item_code, tsst.dm_org_code, mdd.datet';
1739: msd_dem_common_utilities.log_debug ('Shipment Data move sql - ');
1740: msd_dem_common_utilities.log_debug (var_sql);

Line 2721: FROM msd_dem_dates

2717:
2718: /* Get bucket start date for start date */
2719: SELECT start_date
2720: INTO var_from_date_dt
2721: FROM msd_dem_dates
2722: WHERE fnd_date.canonical_to_date(p_from_date) BETWEEN start_date AND end_date;
2723:
2724: /* Get bucket end date for end date */
2725: SELECT end_date

Line 2727: FROM msd_dem_dates

2723:
2724: /* Get bucket end date for end date */
2725: SELECT end_date
2726: INTO var_to_date_dt
2727: FROM msd_dem_dates
2728: WHERE fnd_date.canonical_to_date(p_to_date) BETWEEN start_date AND end_date;
2729:
2730:
2731: ELSE /* Daily system or complete refresh - assign the same dates */

Line 3754: ' select inp.start_date from msd_dem_dates inp '||

3750:
3751: x_sql := 'UPDATE ' ||
3752: ' msd_spf_model_bom_components '||
3753: ' set effective_date = ( '||
3754: ' select inp.start_date from msd_dem_dates inp '||
3755: ' where effective_date between inp.start_date and inp.end_date) ' ||
3756: ' where effective_date > :1 ';
3757: msd_dem_common_utilities.log_debug(x_sql);
3758: execute immediate x_sql using x_max_sales_date;

Line 3763: ' (select greatest(inp.start_date-1,effective_date) from msd_dem_dates inp '||

3759:
3760: x_sql := 'UPDATE ' ||
3761: ' msd_spf_model_bom_components '||
3762: ' set disable_date = nvl( '||
3763: ' (select greatest(inp.start_date-1,effective_date) from msd_dem_dates inp '||
3764: ' where disable_date between inp.start_date and inp.end_date-1), ' ||
3765: ' disable_date) '||
3766: ' where disable_date > :1 ';
3767: msd_dem_common_utilities.log_debug(x_sql);

Line 4355: msd_dem_dates mdd

4351: su.ebs_base_model_sr_pk, su.dm_item_sr_pk, su.dm_org_sr_pk,
4352: FND_GLOBAL.LOGIN_ID, systimestamp, systimestamp, FND_GLOBAL.USER_ID, FND_GLOBAL.USER_ID
4353: FROM
4354: msd_spf_st_spare_usage su,
4355: msd_dem_dates mdd
4356: WHERE
4357: su.usage_date BETWEEN mdd.start_date AND mdd.end_date
4358: GROUP BY su.usage_hist_type, su.ebs_base_model_sr_pk, su.dm_item_sr_pk, su.dm_org_sr_pk, mdd.datet, -- Bug#12675064
4359: su.ebs_base_model_code, su.dm_item_code, su.dm_org_code;