APPS.OE_BULK_ORDER_PVT dependencies on OE_LINES_IFACE_ALL

Line 65: (select orig_sys_line_ref from oe_lines_iface_all a

61: -- Delete line records
62: FORALL i IN 1..G_ERROR_REC.order_source_id.COUNT
63: DELETE from OE_ORDER_LINES
64: WHERE orig_sys_line_ref in
65: (select orig_sys_line_ref from oe_lines_iface_all a
66: where nvl(a.error_flag, 'N') = 'Y'
67: and a.orig_sys_document_ref=G_ERROR_REC.orig_sys_document_ref(i));
68:
69: -- Delete Header Records

Line 186: FROM oe_lines_iface_all b

182: AND ORDER_SOURCE_ID = G_ERROR_REC.order_source_id(i)
183: AND ORIG_SYS_DOCUMENT_REF = G_ERROR_REC.orig_sys_document_ref(i)
184: AND NOT EXISTS
185: (SELECT 1
186: FROM oe_lines_iface_all b
187: WHERE b.orig_sys_document_ref = G_ERROR_REC.orig_sys_document_ref(i)
188: AND b.order_source_id = G_ERROR_REC.order_source_id(i)
189: AND nvl(error_flag, 'N') = 'N');
190: