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_V

Line 3583: FROM msd_price_list_v

3579: SELECT 1
3580: INTO x_price_list_data_found
3581: FROM dual
3582: WHERE EXISTS (SELECT 1
3583: FROM msd_price_list_v
3584: WHERE price_list_name = c_price_list_rec.price_list_name
3585: AND ( ( nvl(start_date, X_MIN_DATE) <= l_dp_min_date
3586: AND nvl(end_date, X_MAX_DATE) >= l_dp_min_date)
3587: OR ( nvl(start_date, X_MIN_DATE) >= l_dp_min_date

Line 3628: FROM msd_price_list_v

3624: SELECT 1
3625: INTO x_price_list_data_found
3626: FROM dual
3627: WHERE EXISTS (SELECT 1
3628: FROM msd_price_list_v
3629: WHERE price_list_name = c_scn_with_pls.price_list_name
3630: AND ( ( nvl(start_date, X_MIN_DATE) <= c_scn_with_pls.horizon_start_date
3631: AND nvl(end_date, X_MAX_DATE) >= c_scn_with_pls.horizon_start_date)
3632: OR ( nvl(start_date, X_MIN_DATE) >= c_scn_with_pls.horizon_start_date

Line 3673: FROM msd_price_list_v

3669: SELECT 1
3670: INTO x_price_list_data_found
3671: FROM dual
3672: WHERE EXISTS (SELECT 1
3673: FROM msd_price_list_v
3674: WHERE price_list_name = c_param_with_pls.price_list_name
3675: AND ( ( nvl(start_date, X_MIN_DATE) <= c_param_with_pls.start_date
3676: AND nvl(end_date, X_MAX_DATE) >= c_param_with_pls.start_date)
3677: OR ( nvl(start_date, X_MIN_DATE) >= c_param_with_pls.start_date