eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_VALIDATE_DEMAND_PLAN dependencies on MSD_PRICE_LIST_DS_V

Line 3443: FROM msd_price_list_ds_v

3439: SELECT 1
3440: INTO x_price_list_data_found
3441: FROM dual
3442: WHERE EXISTS (SELECT 1
3443: FROM msd_price_list_ds_v
3444: WHERE price_list_name = c_price_list_rec.price_list_name
3445: AND ( ( nvl(start_date, X_MIN_DATE) <= l_dp_min_date
3446: AND nvl(end_date, X_MAX_DATE) >= l_dp_min_date)
3447: OR ( nvl(start_date, X_MIN_DATE) >= l_dp_min_date

Line 3488: FROM msd_price_list_ds_v

3484: SELECT 1
3485: INTO x_price_list_data_found
3486: FROM dual
3487: WHERE EXISTS (SELECT 1
3488: FROM msd_price_list_ds_v
3489: WHERE price_list_name = c_scn_with_pls.price_list_name
3490: AND ( ( nvl(start_date, X_MIN_DATE) <= c_scn_with_pls.horizon_start_date
3491: AND nvl(end_date, X_MAX_DATE) >= c_scn_with_pls.horizon_start_date)
3492: OR ( nvl(start_date, X_MIN_DATE) >= c_scn_with_pls.horizon_start_date

Line 3533: FROM msd_price_list_ds_v

3529: SELECT 1
3530: INTO x_price_list_data_found
3531: FROM dual
3532: WHERE EXISTS (SELECT 1
3533: FROM msd_price_list_ds_v
3534: WHERE price_list_name = c_param_with_pls.price_list_name
3535: AND ( ( nvl(start_date, X_MIN_DATE) <= c_param_with_pls.start_date
3536: AND nvl(end_date, X_MAX_DATE) >= c_param_with_pls.start_date)
3537: OR ( nvl(start_date, X_MIN_DATE) >= c_param_with_pls.start_date