DBA Data[Home] [Help]

APPS.FLM_MMM_CALCULATION dependencies on WIP_REPETITIVE_SCHEDULES

Line 119: WIP_REPETITIVE_SCHEDULES REP,

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
122: TRUNC(REP.LAST_UNIT_COMPLETION_DATE)
123: AND BOM.SEQ_NUM IS NOT NULL

Line 306: WIP_REPETITIVE_SCHEDULES REP,

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)
310: AND TRUNC(REP.LAST_UNIT_COMPLETION_DATE)