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_HEADERS_IFACE_ALL

Line 1352: FROM OE_Headers_Iface_All h

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)
1355: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1356: AND (l_sold_to_org_id IS NULL

Line 1391: FROM OE_Headers_Iface_All h

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)
1394: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1395: AND (l_sold_to_org_id IS NULL

Line 1430: FROM OE_Headers_Iface_All h

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)
1433: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1434: AND (l_sold_to_org_id IS NULL

Line 1470: FROM OE_Headers_Iface_All h

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)
1473: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1474: AND (l_sold_to_org_id IS NULL

Line 1509: FROM OE_Headers_Iface_All h

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)
1512: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1513: AND (l_sold_to_org_id IS NULL

Line 1549: FROM OE_Headers_Iface_All h

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)
1552: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1553: AND (l_sold_to_org_id IS NULL

Line 1588: FROM OE_Headers_Iface_All h

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)
1591: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1592: AND (l_sold_to_org_id IS NULL

Line 1627: FROM OE_Headers_Iface_All h

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)
1630: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1631: AND (l_sold_to_org_id IS NULL

Line 1674: FROM OE_Headers_Iface_All

1670:
1671: -- Start MOAC
1672: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1673: DELETE
1674: FROM OE_Headers_Iface_All
1675: WHERE order_source_id = p_order_source_id
1676: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1677: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1678: AND (l_sold_to_org_id IS NULL

Line 1702: FROM OE_Headers_Iface_All

1698:
1699: -- Start MOAC
1700: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1701: DELETE
1702: FROM OE_Headers_Iface_All
1703: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
1704: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1705: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1706: AND (l_sold_to_org_id IS NULL