eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_ORDER_IMPORT_PVT dependencies on OE_ACTIONS_IFACE_ALL

Line 496: FROM oe_actions_iface_all a

492: AND pa.orig_sys_document_ref
493: = h.orig_sys_document_ref
494: AND h.org_id = pa.org_id)
495: AND NOT EXISTS (SELECT 'Y'
496: FROM oe_actions_iface_all a
497: WHERE a.order_source_id = h.order_source_id
498: AND a.orig_sys_document_ref
499: = h.orig_sys_document_ref
500: AND operation_code <> 'BOOK_ORDER'

Line 561: FROM oe_actions_iface_all a

557: AND pa.orig_sys_document_ref
558: = h.orig_sys_document_ref
559: AND h.org_id = pa.org_id)
560: AND NOT EXISTS (SELECT 'Y'
561: FROM oe_actions_iface_all a
562: WHERE a.order_source_id = h.order_source_id
563: AND a.orig_sys_document_ref
564: = h.orig_sys_document_ref
565: AND h.org_id = a.org_id

Line 617: FROM oe_actions_iface_all a

613: = h.orig_sys_document_ref
614: AND NVL(h.org_id, l_default_org_id) =
615: NVL(pa.org_id, l_default_org_id))
616: AND NOT EXISTS (SELECT 'Y'
617: FROM oe_actions_iface_all a
618: WHERE a.order_source_id = h.order_source_id
619: AND a.orig_sys_document_ref
620: = h.orig_sys_document_ref
621: AND NVL(h.org_id, l_default_org_id) =

Line 842: FROM oe_actions_iface_all a

838: AND pa.orig_sys_document_ref
839: = h.orig_sys_document_ref
840: AND h.org_id = pa.org_id)
841: AND NOT EXISTS (SELECT 'Y'
842: FROM oe_actions_iface_all a
843: WHERE a.order_source_id = h.order_source_id
844: AND a.orig_sys_document_ref
845: = h.orig_sys_document_ref
846: AND h.org_id = a.org_id

Line 883: FROM oe_actions_iface_all a

879: = h.orig_sys_document_ref
880: AND NVL(h.org_id, l_default_org_id) =
881: NVL(pa.org_id, l_default_org_id))
882: AND NOT EXISTS (SELECT 'Y'
883: FROM oe_actions_iface_all a
884: WHERE a.order_source_id = h.order_source_id
885: AND a.orig_sys_document_ref
886: = h.orig_sys_document_ref
887: AND NVL(h.org_id, l_default_org_id) =

Line 928: FROM oe_actions_iface_all a

924: AND pa.orig_sys_document_ref
925: = h.orig_sys_document_ref
926: AND pa.org_id = h.org_id )
927: AND NOT EXISTS (SELECT 'Y'
928: FROM oe_actions_iface_all a
929: WHERE a.order_source_id = h.order_source_id
930: AND a.orig_sys_document_ref
931: = h.orig_sys_document_ref
932: AND a.org_id = h.org_id

Line 1189: UPDATE oe_actions_iface_all

1185: -- Update on lines iface is done as a part of request_id update.
1186:
1187: -- Update on actions iface all
1188: FORALL l_index IN 1..l_order_count
1189: UPDATE oe_actions_iface_all
1190: SET org_id = l_order_rec.org_id(l_index) -- added for MOAC
1191: WHERE order_source_id = l_order_rec.order_source_id(l_index)
1192: AND orig_sys_document_ref
1193: = l_order_rec.orig_sys_document_ref(l_index)