APPS.GML_INTORD_LOT_STS dependencies on OE_ORDER_LINES_ALL

Line 426: AND line_id IN(SELECT line_id FROM oe_order_lines_all

422: WHERE doc_type = 'OMSO'
423: AND item_id = p_item_id
424: AND completed_ind = 1
425: AND delete_mark = 0
426: AND line_id IN(SELECT line_id FROM oe_order_lines_all
427: WHERE source_document_line_id = p_req_line_id);
428:
429: l_number NUMBER := 1;
430: