APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_ACTIONS_IFACE_ALL

Line 402: FROM oe_actions_iface_all a

398: AND pa.orig_sys_document_ref
399: = h.orig_sys_document_ref
400: AND h.org_id = pa.org_id)
401: AND NOT EXISTS (SELECT 'Y'
402: FROM oe_actions_iface_all a
403: WHERE a.order_source_id = h.order_source_id
404: AND a.orig_sys_document_ref
405: = h.orig_sys_document_ref
406: AND operation_code <> 'BOOK_ORDER'

Line 467: FROM oe_actions_iface_all a

463: AND pa.orig_sys_document_ref
464: = h.orig_sys_document_ref
465: AND h.org_id = pa.org_id)
466: AND NOT EXISTS (SELECT 'Y'
467: FROM oe_actions_iface_all a
468: WHERE a.order_source_id = h.order_source_id
469: AND a.orig_sys_document_ref
470: = h.orig_sys_document_ref
471: AND h.org_id = a.org_id

Line 523: FROM oe_actions_iface_all a

519: = h.orig_sys_document_ref
520: AND NVL(h.org_id, l_default_org_id) =
521: NVL(pa.org_id, l_default_org_id))
522: AND NOT EXISTS (SELECT 'Y'
523: FROM oe_actions_iface_all a
524: WHERE a.order_source_id = h.order_source_id
525: AND a.orig_sys_document_ref
526: = h.orig_sys_document_ref
527: AND NVL(h.org_id, l_default_org_id) =

Line 747: FROM oe_actions_iface_all a

743: AND pa.orig_sys_document_ref
744: = h.orig_sys_document_ref
745: AND h.org_id = pa.org_id)
746: AND NOT EXISTS (SELECT 'Y'
747: FROM oe_actions_iface_all a
748: WHERE a.order_source_id = h.order_source_id
749: AND a.orig_sys_document_ref
750: = h.orig_sys_document_ref
751: AND h.org_id = a.org_id

Line 788: FROM oe_actions_iface_all a

784: = h.orig_sys_document_ref
785: AND NVL(h.org_id, l_default_org_id) =
786: NVL(pa.org_id, l_default_org_id))
787: AND NOT EXISTS (SELECT 'Y'
788: FROM oe_actions_iface_all a
789: WHERE a.order_source_id = h.order_source_id
790: AND a.orig_sys_document_ref
791: = h.orig_sys_document_ref
792: AND NVL(h.org_id, l_default_org_id) =

Line 833: FROM oe_actions_iface_all a

829: AND pa.orig_sys_document_ref
830: = h.orig_sys_document_ref
831: AND pa.org_id = h.org_id )
832: AND NOT EXISTS (SELECT 'Y'
833: FROM oe_actions_iface_all a
834: WHERE a.order_source_id = h.order_source_id
835: AND a.orig_sys_document_ref
836: = h.orig_sys_document_ref
837: AND a.org_id = h.org_id

Line 1094: UPDATE oe_actions_iface_all

1090: -- Update on lines iface is done as a part of request_id update.
1091:
1092: -- Update on actions iface all
1093: FORALL l_index IN 1..l_order_count
1094: UPDATE oe_actions_iface_all
1095: SET org_id = l_order_rec.org_id(l_index) -- added for MOAC
1096: WHERE order_source_id = l_order_rec.order_source_id(l_index)
1097: AND orig_sys_document_ref
1098: = l_order_rec.orig_sys_document_ref(l_index)