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_LIABILITY dependencies on MSD_DP_CALENDARS

Line 729: FROM msd_dp_calendars

725: IS
726: SELECT calendar_type, calendar_code, decode(calendar_type,
727: 1, initcap(calendar_code),
728: calendar_code) op_cal_code
729: FROM msd_dp_calendars
730: WHERE demand_plan_id = p_demand_plan_id
731: and calendar_type <> 1; -- To Prevent the validation of Gregorian calendar because validation of Gregorian Calendar is not required
732:
733:

Line 2262: msd_dp_calendars mdc ,

2258: CURSOR c_mfg_calendar
2259: IS
2260: select mdc.calendar_type
2261: from
2262: msd_dp_calendars mdc ,
2263: msd_demand_plans mdp
2264: where
2265: mdc.demand_plan_id = mdp.demand_plan_id
2266: and mdp.liab_plan_id = p_plan_id

Line 2329: ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id)

2325:
2326: BEGIN
2327:
2328: delete from msd_time_lb where CALENDAR_CODE in
2329: ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id)
2330: ;
2331:
2332: commit ;
2333:

Line 2359: in ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id and calendar_type <> 1 ) ;

2355: DAY_DESCRIPTION,
2356: WORKING_DAY )
2357: select * from msd_sr_time_lb_v
2358: where CALENDAR_CODE
2359: in ( select CALENDAR_CODE from msd_dp_calendars where demand_plan_id = p_demand_plan_id and calendar_type <> 1 ) ;
2360:
2361: commit ;
2362:
2363: