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_ELECMSGS_PVT dependencies on OE_LINES_IFACE_ALL

Line 2127: FROM OE_Lines_Iface_All h

2123: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2124: DELETE
2125: FROM OE_Customer_Info_Iface_All c
2126: WHERE c.customer_info_ref IN (SELECT h.bill_to_contact_ref
2127: FROM OE_Lines_Iface_All h
2128: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2129: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2130: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2131: AND (l_sold_to_org_id IS NULL

Line 2166: FROM OE_Lines_Iface_All h

2162: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2163: DELETE
2164: FROM OE_Customer_Info_Iface_All c
2165: WHERE c.customer_info_ref IN (SELECT h.ship_to_contact_ref
2166: FROM OE_Lines_Iface_All h
2167: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2168: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2169: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2170: AND (l_sold_to_org_id IS NULL

Line 2205: FROM OE_Lines_Iface_All h

2201: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2202: DELETE
2203: FROM OE_Customer_Info_Iface_All c
2204: WHERE c.customer_info_ref IN (SELECT h.deliver_to_contact_ref
2205: FROM OE_Lines_Iface_All h
2206: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2207: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2208: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2209: AND (l_sold_to_org_id IS NULL

Line 2244: FROM OE_Lines_Iface_All h

2240: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2241: DELETE
2242: FROM OE_Customer_Info_Iface_All c
2243: WHERE c.customer_info_ref IN (SELECT h.orig_ship_address_ref
2244: FROM OE_Lines_Iface_All h
2245: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2246: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2247: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2248: AND (l_sold_to_org_id IS NULL

Line 2283: FROM OE_Lines_Iface_All h

2279: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2280: DELETE
2281: FROM OE_Customer_Info_Iface_All c
2282: WHERE c.customer_info_ref IN (SELECT h.orig_bill_address_ref
2283: FROM OE_Lines_Iface_All h
2284: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2285: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2286: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2287: AND (l_sold_to_org_id IS NULL

Line 2322: FROM OE_Lines_Iface_All h

2318: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2319: DELETE
2320: FROM OE_Customer_Info_Iface_All c
2321: WHERE c.customer_info_ref IN (SELECT h.orig_deliver_address_ref
2322: FROM OE_Lines_Iface_All h
2323: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2324: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2325: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2326: AND (l_sold_to_org_id IS NULL

Line 2363: FROM OE_Lines_Iface_All

2359:
2360: -- Start MOAC
2361: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2362: DELETE
2363: FROM OE_Lines_Iface_All
2364: WHERE order_source_id = p_order_source_id
2365: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2366: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2367: AND (l_sold_to_org_id IS NULL

Line 2391: FROM OE_Lines_Iface_All

2387:
2388: -- Start MOAC
2389: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2390: DELETE
2391: FROM OE_Lines_Iface_All
2392: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2393: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2394: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2395: AND (l_sold_to_org_id IS NULL