APPS.FLM_MMM_CALCULATION dependencies on WIP_LINES

Line 176: WIP_LINES WL,

172: wl.line_id
173: FROM
174: OE_ORDER_LINES_ALL SL1,
175: MTL_SYSTEM_ITEMS_KFV MSI1,
176: WIP_LINES WL,
177: (select sl2.line_id,
178: decode((select 1
179: from oe_order_holds_all oh
180: where oh.header_id = sl2.header_id

Line 234: WIP_LINES WL

230: FROM MTL_SYSTEM_ITEMS_B KFV,
231: MRP_SYSTEM_ITEMS RSI1,
232: MRP_PLANS MP1,
233: MRP_RECOMMENDATIONS MR1,
234: WIP_LINES WL
235: WHERE MP1.PLAN_COMPLETION_DATE IS NOT NULL
236: AND MP1.DATA_COMPLETION_DATE IS NOT NULL
237: AND MP1.COMPILE_DESIGNATOR = MR1.COMPILE_DESIGNATOR
238: AND (MP1.ORGANIZATION_ID = MR1.ORGANIZATION_ID OR

Line 328: WIP_LINES LINE

324: AND i_end_date+1-(1/86400)
325: UNION ALL
326: SELECT count(distinct(to_char(flow.scheduled_completion_date))) num_days
327: FROM WIP_FLOW_SCHEDULES FLOW,
328: WIP_LINES LINE
329: WHERE FLOW.LINE_ID = LINE.LINE_ID
330: AND FLOW.ORGANIZATION_ID = LINE.ORGANIZATION_ID
331: AND FLOW.organization_id = i_organization_id
332: AND FLOW.line_id = i_line_id

Line 704: FROM wip_lines

700: --fix bug#3773193
701:
702: SELECT start_time, stop_time
703: INTO l_start_time, l_stop_time
704: FROM wip_lines
705: WHERE line_id = i_line_id
706: AND organization_id = i_organization_id;
707:
708: IF (l_stop_time <= l_start_time) THEN

Line 736: FROM wip_lines

732: --fix bug#3773193
733:
734: SELECT start_time, stop_time
735: INTO l_start_time, l_stop_time
736: FROM wip_lines
737: WHERE line_id = i_demand(l_index).line_id
738: AND organization_id = i_organization_id;
739:
740: IF (l_stop_time <= l_start_time) THEN