APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on SO_LINES

Line 103: FROM so_headers h, so_lines l

99: SELECT nvl(l.ordered_quantity, 0)
100: - nvl(l.shipped_quantity,0)
101: - nvl(l.cancelled_quantity,0)
102: INTO x_open_qty
103: FROM so_headers h, so_lines l
104: WHERE h.original_system_source_code = p_order_source_id
105: AND h.original_system_reference = p_orig_sys_document_ref
106: AND h.header_id = l.header_id
107: AND l.original_system_line_reference = p_orig_sys_line_ref

Line 208: FROM so_headers h, so_lines l

204:
205: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
206: SELECT nvl(l.shipped_quantity,0)
207: INTO x_shipped_qty
208: FROM so_headers h, so_lines l
209: WHERE h.original_system_source_code = p_order_source_id
210: AND h.original_system_reference = p_orig_sys_document_ref
211: AND h.header_id = l.header_id
212: AND l.original_system_line_reference = p_orig_sys_line_ref;

Line 320: FROM so_headers h, so_lines l

316:
317: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
318: SELECT l.cancelled_quantity
319: INTO x_cancelled_qty
320: FROM so_headers h, so_lines l
321: WHERE h.original_system_source_code = p_order_source_id
322: AND h.original_system_reference = p_orig_sys_document_ref
323: AND h.header_id = l.header_id
324: AND l.original_system_line_reference = p_orig_sys_line_ref;

Line 398: FROM so_headers h, so_lines l

394:
395: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
396: SELECT h.order_number
397: INTO x_order_number
398: FROM so_headers h, so_lines l
399: WHERE h.original_system_source_code = p_order_source_id
400: AND h.original_system_reference = p_orig_sys_document_ref
401: AND h.header_id = l.header_id
402: AND l.original_system_line_reference = p_orig_sys_line_ref;