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_ORDER_IMPORT_INTEROP_PUB dependencies on OE_INSTALL

Line 52: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

48: -- Fix for bug 3217280
49: l_org_id NUMBER;
50: BEGIN
51:
52: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
53:
54: /* bsadri performance fixes for bug 1807599 so that the
55: indexes on oe_order_headers and oe_order_lines are
56: used again

Line 103: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN

99: AND NVL(l.org_id,-1) = l_org_id
100: GROUP BY l.source_document_line_id;
101:
102: -- End of bug 2469894,2641565 }
103: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
104: SELECT nvl(l.ordered_quantity, 0)
105: - nvl(l.shipped_quantity,0)
106: - nvl(l.cancelled_quantity,0)
107: INTO x_open_qty

Line 151: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

147: -- Fix for bug 3217280
148: l_org_id NUMBER;
149: BEGIN
150:
151: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
152: /* bsadri performance fixes for bug 1807599 so that the
153: indexes on oe_order_headers and oe_order_lines are
154: used again
155: */

Line 215: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN

211: --AND l.source_document_line_id = p_orig_sys_line_ref;
212: AND l.orig_sys_line_ref = l_orig_sys_line_ref;
213: */
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

Line 276: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

272: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
273: --
274: BEGIN
275:
276: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
277: /* bsadri performance fixes for bug 1807599 so that the
278: indexes on oe_order_headers and oe_order_lines are
279: used again
280: */

Line 332: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN

328:
329: x_cancelled_qty := l_sum_of_quantity;
330: -- End of bug 2469894,2641565 }
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

Line 376: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

372: -- Fix for bug 3217280
373: l_org_id NUMBER;
374: BEGIN
375:
376: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
377: /* bsadri performance fixes for bug 1807599 so that the
378: indexes on oe_order_headers and oe_order_lines are
379: used again
380: */

Line 411: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN

407: AND l.orig_sys_line_ref = l_orig_sys_line_ref
408: AND h.source_document_id = l.source_document_id
409: AND nvl(h.org_id, -1) = l_org_id;
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

Line 459: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

455: l_org_id NUMBER;
456: l_orig_sys_line_ref VARCHAR2(50);
457: BEGIN
458:
459: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
460: IF p_type = 'H' THEN
461: /* bsadri performance fixes for bug 1807599 so that the
462: indexes on oe_order_headers and oe_order_lines are
463: used again

Line 497: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN

493: AND d.requisition_line_id =
494: nvl(p_requisition_line_id, d.requisition_line_id);
495: END IF;
496:
497: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
498: IF p_type = 'H' THEN
499: SELECT h.header_id
500: INTO x_header_id
501: FROM so_headers h

Line 543: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN

539: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
540: --
541: BEGIN
542:
543: IF OE_INSTALL.Get_Active_Product = 'ONT' THEN
544: IF p_type = 'H' THEN /* From oe_order_headers */
545: -- Following change is made to support the multi-org PO functionality
546: -- SELECT r.requisition_header_id
547: -- INTO x_req_header_id

Line 562: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN

558: INTO x_req_header_id
559: FROM oe_drop_ship_sources d
560: WHERE d.header_id = p_header_id;
561: END IF;
562: ELSIF OE_INSTALL.Get_Active_Product = 'OE' THEN
563: IF p_type = 'H' THEN /* From oe_order_headers */
564: SELECT r.requisition_header_id
565: INTO x_req_header_id
566: FROM so_headers h, po_requisition_headers r