DBA Data[Home] [Help]

APPS.MRP_WFS_FORM_FLOW_SCHEDULE dependencies on WIP_LINES

Line 2662: WIP_LINES WL,

2658: WL.LINE_ID) alternate_routing_designator
2659: FROM
2660: OE_ORDER_LINES_ALL SL1,
2661: MTL_SYSTEM_ITEMS_KFV MSI1,
2662: WIP_LINES WL,
2663: (select sl2.line_id,
2664: decode((select 1
2665: from oe_order_holds_all oh
2666: where oh.header_id = sl2.header_id

Line 2767: WIP_LINES WL

2763: FROM MTL_SYSTEM_ITEMS_B KFV,
2764: MRP_SYSTEM_ITEMS RSI1,
2765: MRP_PLANS MP1,
2766: MRP_RECOMMENDATIONS MR1,
2767: WIP_LINES WL
2768: WHERE MP1.PLAN_COMPLETION_DATE IS NOT NULL
2769: AND MP1.DATA_COMPLETION_DATE IS NOT NULL
2770: AND MP1.COMPILE_DESIGNATOR = MR1.COMPILE_DESIGNATOR
2771: AND (MP1.ORGANIZATION_ID = MR1.ORGANIZATION_ID OR