APPS.WSH_INTERFACE dependencies on OE_ORDER_LINES_ALL

Line 822: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool

818: IS
819: CURSOR C_container
820: IS
821: SELECT mci.master_container_item_id, mci.detail_container_item_id
822: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool
823: WHERE dd.delivery_detail_id = p_delivery_detail_id AND
824: dd.source_line_id = ool.line_id AND
825: mci.customer_item_id(+) = ool.ordered_item_id AND
826: ool.item_identifier_type = 'CUST';