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 BOM_CALENDAR_DATES

Line 117: FROM BOM_CALENDAR_DATES BOM,

113: (
114: SELECT
115: REPITEM.PRIMARY_ITEM_ID,
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

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 305: FROM BOM_CALENDAR_DATES BOM,

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,
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)