DBA Data[Home] [Help]

APPS.MRP_EPI dependencies on OE_ORDER_LINES_ALL

Line 725: FROM oe_order_lines_all ool

721: inv_decimals_pub.get_primary_quantity(ool.ship_from_org_id,
722: ool.inventory_item_id,
723: ool.order_quantity_uom,
724: ool.shipped_quantity))) completed_quantity
725: FROM oe_order_lines_all ool
726: WHERE DECODE(ool.source_document_type_id,
727: 10, 8, DECODE(ool.line_category_code, 'ORDER', 2, 12)) in (2,8)
728: GROUP BY inventory_item_id,ship_from_org_id,schedule_ship_date,
729: sold_to_org_id,demand_class_code, ship_to_org_id,invoice_to_org_id) md,