APPS.MRP_WFS_FORM_FLOW_SCHEDULE dependencies on OE_ORDER_LINES_ALL

Line 2660: OE_ORDER_LINES_ALL SL1,

2656: MRP_FLOW_SCHEDULE_UTIL.GET_ROUTING_DESIGNATOR(SL1.INVENTORY_ITEM_ID,
2657: SL1.SHIP_FROM_ORG_ID,
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

Line 2681: from oe_order_lines_all sl2) line_holds,

2677: mrp_flow_schedule_util.check_holds(sl2.header_id,
2678: sl2.line_id,
2679: null,
2680: null))) hold
2681: from oe_order_lines_all sl2) line_holds,
2682: (select sl2.line_id,
2683: CTO_WIP_WORKFLOW_API_PK.workflow_build_status(sl2.LINE_ID) status
2684: from oe_order_lines_all sl2) line_build
2685: WHERE

Line 2684: from oe_order_lines_all sl2) line_build

2680: null))) hold
2681: from oe_order_lines_all sl2) line_holds,
2682: (select sl2.line_id,
2683: CTO_WIP_WORKFLOW_API_PK.workflow_build_status(sl2.LINE_ID) status
2684: from oe_order_lines_all sl2) line_build
2685: WHERE
2686: line_build.line_id = sl1.line_id
2687: AND 1 = decode(MSI1.REPLENISH_TO_ORDER_FLAG, 'N', 1, line_build.status)
2688: AND MSI1.BUILD_IN_WIP_FLAG = 'Y'