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.FLM_MMM_CALCULATION dependencies on MTL_PARAMETERS

Line 120: MTL_PARAMETERS MP

116: REP.LINE_ID
117: FROM BOM_CALENDAR_DATES BOM,
118: WIP_REPETITIVE_ITEMS REPITEM,
119: WIP_REPETITIVE_SCHEDULES REP,
120: MTL_PARAMETERS MP
121: WHERE BOM.CALENDAR_DATE BETWEEN TRUNC(REP.FIRST_UNIT_COMPLETION_DATE) AND
122: TRUNC(REP.LAST_UNIT_COMPLETION_DATE)
123: AND BOM.SEQ_NUM IS NOT NULL
124: AND MP.CALENDAR_CODE = BOM.CALENDAR_CODE

Line 301: -- add MTL_PARAMETERS criteria when querying BOM_CALENDAR_DATES

297: AND trunc(scheduled_completion_date) BETWEEN i_start_date AND i_end_date;
298: */
299: --fix bug#3293206:
300: -- change sum(num_days) to max(num_days)
301: -- add MTL_PARAMETERS criteria when querying BOM_CALENDAR_DATES
302: SELECT max(num_days)
303: FROM (
304: SELECT count(distinct(to_char(BOM.calendar_Date))) num_days
305: FROM BOM_CALENDAR_DATES BOM,

Line 307: MTL_PARAMETERS MP

303: FROM (
304: SELECT count(distinct(to_char(BOM.calendar_Date))) num_days
305: FROM BOM_CALENDAR_DATES BOM,
306: WIP_REPETITIVE_SCHEDULES REP,
307: MTL_PARAMETERS MP
308: WHERE REP.line_id =i_line_id
309: AND BOM.CALENDAR_DATE BETWEEN TRUNC(REP.FIRST_UNIT_COMPLETION_DATE)
310: AND TRUNC(REP.LAST_UNIT_COMPLETION_DATE)
311: AND BOM.SEQ_NUM IS NOT NULL

Line 2394: mtl_parameters mp

2390: ELSIF i_bucket_type = C_BUCKET_WEEKS THEN
2391: SELECT bw.week_start_date
2392: INTO l_offset_date
2393: FROM bom_cal_week_start_dates bw,
2394: mtl_parameters mp
2395: WHERE mp.organization_id = i_organization_id
2396: AND bw.calendar_code = mp.calendar_code
2397: AND bw.exception_set_id = mp.calendar_exception_set_id
2398: AND bw.week_start_date <= i_start_date

Line 2405: mtl_parameters mp

2401: ELSIF i_bucket_type = C_BUCKET_PERIODS THEN
2402: SELECT bp.period_start_date
2403: INTO l_offset_date
2404: FROM bom_period_start_dates bp,
2405: mtl_parameters mp
2406: WHERE mp.organization_id = i_organization_id
2407: AND bp.calendar_code = mp.calendar_code
2408: AND bp.exception_set_id = mp.calendar_exception_set_id
2409: AND bp.period_start_date <= i_start_date