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 1460: OE_ORDER_HEADERS_ALL

1456: WHERE SITE_USE.SITE_USE_ID = (
1457: SELECT
1458: SOLD_TO_SITE_USE_ID
1459: FROM
1460: OE_ORDER_HEADERS_ALL
1461: WHERE HEADER_ID = HEADER_ID )
1462: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1463: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1464: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1548: OE_ORDER_HEADERS_ALL

1544: WHERE SITE_USE.SITE_USE_ID = (
1545: SELECT
1546: SOLD_TO_SITE_USE_ID
1547: FROM
1548: OE_ORDER_HEADERS_ALL
1549: WHERE HEADER_ID = HEADER_ID )
1550: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1551: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1552: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1646: OE_ORDER_HEADERS_ALL

1642: WHERE SITE_USE.SITE_USE_ID = (
1643: SELECT
1644: SOLD_TO_SITE_USE_ID
1645: FROM
1646: OE_ORDER_HEADERS_ALL
1647: WHERE HEADER_ID = HEADER_ID )
1648: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1649: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1650: AND SITE.LOCATION_ID = LOC.LOCATION_ID;

Line 1734: OE_ORDER_HEADERS_ALL

1730: WHERE SITE_USE.SITE_USE_ID = (
1731: SELECT
1732: SOLD_TO_SITE_USE_ID
1733: FROM
1734: OE_ORDER_HEADERS_ALL
1735: WHERE HEADER_ID = HEADER_ID )
1736: AND SITE_USE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
1737: AND ACCT_SITE.PARTY_SITE_ID = SITE.PARTY_SITE_ID
1738: AND SITE.LOCATION_ID = LOC.LOCATION_ID;