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_CUSTOMER_INFO_IFACE_ALL

Line 1330: FROM OE_Customer_Info_Iface_All c

1326: l_c_min_ord_src := l_min_order_source_id;
1327: l_c_max_ord_src := l_max_order_source_id;
1328: END IF;
1329: DELETE
1330: FROM OE_Customer_Info_Iface_All c
1331: WHERE c.customer_info_ref IN (SELECT h.orig_sys_customer_ref
1332: FROM OE_Headers_Interface h
1333: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1334: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1350: FROM OE_Customer_Info_Iface_All c

1346:
1347: -- Start MOAC
1348: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1349: DELETE
1350: FROM OE_Customer_Info_Iface_All c
1351: WHERE c.customer_info_ref IN (SELECT h.orig_sys_customer_ref
1352: FROM OE_Headers_Iface_All h
1353: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1354: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1370: FROM OE_Customer_Info_Iface_All c

1366: END IF;
1367: -- End MOAC
1368:
1369: DELETE
1370: FROM OE_Customer_Info_Iface_All c
1371: WHERE c.customer_info_ref IN (SELECT h.sold_to_contact_ref
1372: FROM OE_Headers_Interface h
1373: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1374: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1389: FROM OE_Customer_Info_Iface_All c

1385:
1386: -- Start MOAC
1387: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1388: DELETE
1389: FROM OE_Customer_Info_Iface_All c
1390: WHERE c.customer_info_ref IN (SELECT h.sold_to_contact_ref
1391: FROM OE_Headers_Iface_All h
1392: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1393: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1409: FROM OE_Customer_Info_Iface_All c

1405: END IF;
1406: -- End MOAC
1407:
1408: DELETE
1409: FROM OE_Customer_Info_Iface_All c
1410: WHERE c.customer_info_ref IN (SELECT h.bill_to_contact_ref
1411: FROM OE_Headers_Interface h
1412: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1413: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1428: FROM OE_Customer_Info_Iface_All c

1424:
1425: -- Start MOAC
1426: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1427: DELETE
1428: FROM OE_Customer_Info_Iface_All c
1429: WHERE c.customer_info_ref IN (SELECT h.bill_to_contact_ref
1430: FROM OE_Headers_Iface_All h
1431: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1432: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1449: FROM OE_Customer_Info_Iface_All c

1445: -- End MOAC
1446:
1447:
1448: DELETE
1449: FROM OE_Customer_Info_Iface_All c
1450: WHERE c.customer_info_ref IN (SELECT h.ship_to_contact_ref
1451: FROM OE_Headers_Interface h
1452: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1453: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1468: FROM OE_Customer_Info_Iface_All c

1464:
1465: -- Start MOAC
1466: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1467: DELETE
1468: FROM OE_Customer_Info_Iface_All c
1469: WHERE c.customer_info_ref IN (SELECT h.ship_to_contact_ref
1470: FROM OE_Headers_Iface_All h
1471: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1472: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1488: FROM OE_Customer_Info_Iface_All c

1484: END IF;
1485: -- End MOAC
1486:
1487: DELETE
1488: FROM OE_Customer_Info_Iface_All c
1489: WHERE c.customer_info_ref IN (SELECT h.deliver_to_contact_ref
1490: FROM OE_Headers_Interface h
1491: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1492: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1507: FROM OE_Customer_Info_Iface_All c

1503:
1504: -- Start MOAC
1505: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1506: DELETE
1507: FROM OE_Customer_Info_Iface_All c
1508: WHERE c.customer_info_ref IN (SELECT h.deliver_to_contact_ref
1509: FROM OE_Headers_Iface_All h
1510: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1511: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1527: FROM OE_Customer_Info_Iface_All c

1523: END IF;
1524: -- End MOAC
1525:
1526: DELETE
1527: FROM OE_Customer_Info_Iface_All c
1528: WHERE c.customer_info_ref IN (SELECT h.orig_ship_address_ref
1529: FROM OE_Headers_Interface h
1530: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1531: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1547: FROM OE_Customer_Info_Iface_All c

1543:
1544: -- Start MOAC
1545: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1546: DELETE
1547: FROM OE_Customer_Info_Iface_All c
1548: WHERE c.customer_info_ref IN (SELECT h.orig_ship_address_ref
1549: FROM OE_Headers_Iface_All h
1550: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1551: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1567: FROM OE_Customer_Info_Iface_All c

1563: END IF;
1564: -- End MOAC
1565:
1566: DELETE
1567: FROM OE_Customer_Info_Iface_All c
1568: WHERE c.customer_info_ref IN (SELECT h.orig_bill_address_ref
1569: FROM OE_Headers_Interface h
1570: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1571: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1586: FROM OE_Customer_Info_Iface_All c

1582:
1583: -- Start MOAC
1584: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1585: DELETE
1586: FROM OE_Customer_Info_Iface_All c
1587: WHERE c.customer_info_ref IN (SELECT h.orig_bill_address_ref
1588: FROM OE_Headers_Iface_All h
1589: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1590: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1606: FROM OE_Customer_Info_Iface_All c

1602: END IF;
1603: -- End MOAC
1604:
1605: DELETE
1606: FROM OE_Customer_Info_Iface_All c
1607: WHERE c.customer_info_ref IN (SELECT h.orig_deliver_address_ref
1608: FROM OE_Headers_Interface h
1609: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1610: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 1625: FROM OE_Customer_Info_Iface_All c

1621:
1622: -- Start MOAC
1623: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1624: DELETE
1625: FROM OE_Customer_Info_Iface_All c
1626: WHERE c.customer_info_ref IN (SELECT h.orig_deliver_address_ref
1627: FROM OE_Headers_Iface_All h
1628: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
1629: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2106: FROM OE_Customer_Info_Iface_All c

2102: END IF;
2103:
2104:
2105: DELETE
2106: FROM OE_Customer_Info_Iface_All c
2107: WHERE c.customer_info_ref IN (SELECT h.bill_to_contact_ref
2108: FROM OE_Lines_Interface h
2109: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2110: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2125: FROM OE_Customer_Info_Iface_All c

2121:
2122: -- Start MOAC
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)

Line 2145: FROM OE_Customer_Info_Iface_All c

2141: END IF;
2142: -- End MOAC
2143:
2144: DELETE
2145: FROM OE_Customer_Info_Iface_All c
2146: WHERE c.customer_info_ref IN (SELECT h.ship_to_contact_ref
2147: FROM OE_Lines_Interface h
2148: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2149: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2164: FROM OE_Customer_Info_Iface_All c

2160:
2161: -- Start MOAC
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)

Line 2184: FROM OE_Customer_Info_Iface_All c

2180: END IF;
2181: -- End MOAC
2182:
2183: DELETE
2184: FROM OE_Customer_Info_Iface_All c
2185: WHERE c.customer_info_ref IN (SELECT h.deliver_to_contact_ref
2186: FROM OE_Lines_Interface h
2187: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2188: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2203: FROM OE_Customer_Info_Iface_All c

2199:
2200: -- Start MOAC
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)

Line 2223: FROM OE_Customer_Info_Iface_All c

2219: END IF;
2220: -- End MOAC
2221:
2222: DELETE
2223: FROM OE_Customer_Info_Iface_All c
2224: WHERE c.customer_info_ref IN (SELECT h.orig_ship_address_ref
2225: FROM OE_Lines_Interface h
2226: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2227: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2242: FROM OE_Customer_Info_Iface_All c

2238:
2239: -- Start MOAC
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)

Line 2262: FROM OE_Customer_Info_Iface_All c

2258: END IF;
2259: -- End MOAC
2260:
2261: DELETE
2262: FROM OE_Customer_Info_Iface_All c
2263: WHERE c.customer_info_ref IN (SELECT h.orig_bill_address_ref
2264: FROM OE_Lines_Interface h
2265: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2266: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2281: FROM OE_Customer_Info_Iface_All c

2277:
2278: -- Start MOAC
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)

Line 2301: FROM OE_Customer_Info_Iface_All c

2297: END IF;
2298: -- End MOAC
2299:
2300: DELETE
2301: FROM OE_Customer_Info_Iface_All c
2302: WHERE c.customer_info_ref IN (SELECT h.orig_deliver_address_ref
2303: FROM OE_Lines_Interface h
2304: WHERE order_source_id between l_c_min_ord_src and l_c_max_ord_src
2305: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)

Line 2320: FROM OE_Customer_Info_Iface_All c

2316:
2317: -- Start MOAC
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)