APPS.OE_ORDER_IMPORT_INTEROP_PUB dependencies on SO_LINES

Line 108: FROM so_headers h, so_lines l

104: SELECT nvl(l.ordered_quantity, 0)
105: - nvl(l.shipped_quantity,0)
106: - nvl(l.cancelled_quantity,0)
107: INTO x_open_qty
108: FROM so_headers h, so_lines l
109: WHERE h.original_system_source_code = p_order_source_id
110: AND h.original_system_reference = p_orig_sys_document_ref
111: AND h.header_id = l.header_id
112: AND l.original_system_line_reference = p_orig_sys_line_ref

Line 218: FROM so_headers h, so_lines l

214:
215: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
216: SELECT nvl(l.shipped_quantity,0)
217: INTO x_shipped_qty
218: FROM so_headers h, so_lines l
219: WHERE h.original_system_source_code = p_order_source_id
220: AND h.original_system_reference = p_orig_sys_document_ref
221: AND h.header_id = l.header_id
222: AND l.original_system_line_reference = p_orig_sys_line_ref;

Line 335: FROM so_headers h, so_lines l

331:
332: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
333: SELECT l.cancelled_quantity
334: INTO x_cancelled_qty
335: FROM so_headers h, so_lines l
336: WHERE h.original_system_source_code = p_order_source_id
337: AND h.original_system_reference = p_orig_sys_document_ref
338: AND h.header_id = l.header_id
339: AND l.original_system_line_reference = p_orig_sys_line_ref;

Line 414: FROM so_headers h, so_lines l

410:
411: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
412: SELECT h.order_number
413: INTO x_order_number
414: FROM so_headers h, so_lines l
415: WHERE h.original_system_source_code = p_order_source_id
416: AND h.original_system_reference = p_orig_sys_document_ref
417: AND h.header_id = l.header_id
418: AND l.original_system_line_reference = p_orig_sys_line_ref;