APPS.GMI_UPDATE_ORDER dependencies on OE_ORDER_LINES_ALL

Line 62: from rcv_shipment_lines rsl, oe_order_lines_all oel

58: AND NVL(dd.inv_interfaced_flag , 'N') = 'Y'
59: AND dd.container_flag = 'N'
60: AND dd.source_code = 'OE'
61: AND NOT EXISTS(select 1
62: from rcv_shipment_lines rsl, oe_order_lines_all oel
63: where oel.line_id = dd.source_line_id
64: and rsl.requisition_line_id = oel.source_document_line_id
65: and rsl.comments = 'OPM WDD:'||to_char(dd.delivery_detail_id));
66:

Line 74: from oe_order_lines_all

70: SELECT source_document_type_id
71: , source_document_id
72: , source_document_line_id
73: , ship_from_org_id
74: from oe_order_lines_all
75: where line_id = c_order_line_id;
76:
77: l_order_line_info c_order_line_info%ROWTYPE;
78: