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.ONT_OEXOECOD_XMLP_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 1456: OE_ORDER_HEADERS_ALL

1452: WHERE SITE_USE.SITE_USE_ID = (
1453: SELECT
1454: SOLD_TO_SITE_USE_ID
1455: FROM
1456: OE_ORDER_HEADERS_ALL
1457: WHERE HEADER_ID = HEADER_ID )
1458: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1459: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1460: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1544: OE_ORDER_HEADERS_ALL

1540: WHERE SITE_USE.SITE_USE_ID = (
1541: SELECT
1542: SOLD_TO_SITE_USE_ID
1543: FROM
1544: OE_ORDER_HEADERS_ALL
1545: WHERE HEADER_ID = HEADER_ID )
1546: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1547: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1548: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1642: OE_ORDER_HEADERS_ALL

1638: WHERE SITE_USE.SITE_USE_ID = (
1639: SELECT
1640: SOLD_TO_SITE_USE_ID
1641: FROM
1642: OE_ORDER_HEADERS_ALL
1643: WHERE HEADER_ID = HEADER_ID )
1644: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1645: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1646: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1730: OE_ORDER_HEADERS_ALL

1726: WHERE SITE_USE.SITE_USE_ID = (
1727: SELECT
1728: SOLD_TO_SITE_USE_ID
1729: FROM
1730: OE_ORDER_HEADERS_ALL
1731: WHERE HEADER_ID = HEADER_ID )
1732: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1733: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1734: AND SITE.LOCATION_ID = LOC.LOCATION_ID;