DBA Data[Home] [Help]

APPS.WSH_INTERFACE dependencies on OE_ORDER_LINES_ALL

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

808: IS
809: CURSOR C_container
810: IS
811: SELECT mci.master_container_item_id, mci.detail_container_item_id
812: FROM mtl_customer_items mci, wsh_delivery_details dd, oe_order_lines_all ool
813: WHERE dd.delivery_detail_id = p_delivery_detail_id AND
814: dd.source_line_id = ool.line_id AND
815: mci.customer_item_id(+) = ool.ordered_item_id AND
816: ool.item_identifier_type = 'CUST';