DBA Data[Home] [Help]

APPS.BOM_MIXED_MODEL_MAP_PVT dependencies on OE_ORDER_LINES_ALL

Line 569: OE_ORDER_LINES_ALL SO_LINES,

565: JOB.START_QUANTITY planned_quantity,
566: JOB.LINE_ID,
567: JOB.SCHEDULED_COMPLETION_DATE
568: FROM MFG_LOOKUPS WST,
569: OE_ORDER_LINES_ALL SO_LINES,
570: WIP_SO_ALLOCATIONS WSA,
571: WIP_SCHEDULE_GROUPS SCH,
572: MFG_LOOKUPS WJS,
573: WIP_ENTITIES ENTITIES,

Line 600: OE_ORDER_LINES_ALL SO_LINES,

596: FLOW.PLANNED_QUANTITY planned_quantity,
597: FLOW.LINE_ID,
598: FLOW.SCHEDULED_COMPLETION_DATE
599: FROM MFG_LOOKUPS WST,
600: OE_ORDER_LINES_ALL SO_LINES,
601: WIP_SCHEDULE_GROUPS SCH,
602: MTL_SYSTEM_ITEMS_KFV KFV,
603: WIP_FLOW_SCHEDULES FLOW,
604: WIP_LINES LINE,

Line 677: OE_ORDER_LINES_ALL SL1,

673: sl1.ship_from_org_id organization_id,
674: wl.line_id,
675: sl1.schedule_ship_date order_date
676: FROM
677: OE_ORDER_LINES_ALL SL1,
678: MTL_SYSTEM_ITEMS_KFV MSI1,
679: WIP_LINES WL,
680: (select sl2.line_id,
681: decode((select 1

Line 698: from oe_order_lines_all sl2) line_holds,

694: mrp_flow_schedule_util.check_holds(sl2.header_id,
695: sl2.line_id,
696: null,
697: null))) hold
698: from oe_order_lines_all sl2) line_holds,
699: (select sl2.line_id,
700: CTO_WIP_WORKFLOW_API_PK.workflow_build_status(sl2.LINE_ID) status
701: from oe_order_lines_all sl2) line_build
702: WHERE

Line 701: from oe_order_lines_all sl2) line_build

697: null))) hold
698: from oe_order_lines_all sl2) line_holds,
699: (select sl2.line_id,
700: CTO_WIP_WORKFLOW_API_PK.workflow_build_status(sl2.LINE_ID) status
701: from oe_order_lines_all sl2) line_build
702: WHERE
703: line_build.line_id = sl1.line_id
704: AND 1 = decode(MSI1.REPLENISH_TO_ORDER_FLAG, 'N', 1, line_build.status)
705: AND MSI1.BUILD_IN_WIP_FLAG = 'Y'