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 HZ_LOCATIONS

Line 1291: HZ_LOCATIONS LOC,

1287: SELECT
1288: LOC.ADDRESS1
1289: INTO L_END_CUSTOMER_ADDRESS1
1290: FROM
1291: HZ_LOCATIONS LOC,
1292: HZ_PARTY_SITES SITE,
1293: HZ_CUST_SITE_USES_ALL SITE_USE,
1294: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1295: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1324: HZ_LOCATIONS LOC,

1320: LOC.POSTAL_CODE,
1321: LOC.COUNTRY
1322: INTO L_END_CUSTOMER_CITY,L_END_CUSTOMER_STATE,L_END_CUSTOMER_POSTAL_CODE,L_END_CUSTOMER_COUNTRY
1323: FROM
1324: HZ_LOCATIONS LOC,
1325: HZ_PARTY_SITES SITE,
1326: HZ_CUST_SITE_USES SITE_USE,
1327: HZ_CUST_ACCT_SITES ACCT_SITE
1328: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1385: HZ_LOCATIONS LOC,

1381: SELECT
1382: LOC.COUNTRY
1383: INTO L_END_CUSTOMER_COUNTRY
1384: FROM
1385: HZ_LOCATIONS LOC,
1386: HZ_PARTY_SITES SITE,
1387: HZ_CUST_SITE_USES_ALL SITE_USE,
1388: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1389: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1448: HZ_LOCATIONS LOC,

1444: SELECT
1445: LOC.ADDRESS1
1446: INTO L_ADDRESS1
1447: FROM
1448: HZ_LOCATIONS LOC,
1449: HZ_PARTY_SITES SITE,
1450: HZ_CUST_SITE_USES_ALL SITE_USE,
1451: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1452: WHERE SITE_USE.SITE_USE_ID = (

Line 1467: HZ_LOCATIONS LOC,

1463: SELECT
1464: LOC.ADDRESS1
1465: INTO L_ADDRESS1
1466: FROM
1467: HZ_LOCATIONS LOC,
1468: HZ_PARTY_SITES SITE,
1469: HZ_CUST_SITE_USES_ALL SITE_USE,
1470: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1471: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1536: HZ_LOCATIONS LOC,

1532: LOC.POSTAL_CODE,
1533: LOC.COUNTRY
1534: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1535: FROM
1536: HZ_LOCATIONS LOC,
1537: HZ_PARTY_SITES SITE,
1538: HZ_CUST_SITE_USES_ALL SITE_USE,
1539: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1540: WHERE SITE_USE.SITE_USE_ID = (

Line 1575: HZ_LOCATIONS LOC,

1571: LOC.POSTAL_CODE,
1572: LOC.COUNTRY
1573: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1574: FROM
1575: HZ_LOCATIONS LOC,
1576: HZ_PARTY_SITES SITE,
1577: HZ_CUST_SITE_USES_ALL SITE_USE,
1578: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1579: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1634: HZ_LOCATIONS LOC,

1630: SELECT
1631: LOC.ADDRESS1
1632: INTO L_ADDRESS1
1633: FROM
1634: HZ_LOCATIONS LOC,
1635: HZ_PARTY_SITES SITE,
1636: HZ_CUST_SITE_USES_ALL SITE_USE,
1637: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1638: WHERE SITE_USE.SITE_USE_ID = (

Line 1653: HZ_LOCATIONS LOC,

1649: SELECT
1650: LOC.ADDRESS1
1651: INTO L_ADDRESS1
1652: FROM
1653: HZ_LOCATIONS LOC,
1654: HZ_PARTY_SITES SITE,
1655: HZ_CUST_SITE_USES_ALL SITE_USE,
1656: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1657: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1722: HZ_LOCATIONS LOC,

1718: LOC.POSTAL_CODE,
1719: LOC.COUNTRY
1720: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1721: FROM
1722: HZ_LOCATIONS LOC,
1723: HZ_PARTY_SITES SITE,
1724: HZ_CUST_SITE_USES_ALL SITE_USE,
1725: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1726: WHERE SITE_USE.SITE_USE_ID = (

Line 1761: HZ_LOCATIONS LOC,

1757: LOC.POSTAL_CODE,
1758: LOC.COUNTRY
1759: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1760: FROM
1761: HZ_LOCATIONS LOC,
1762: HZ_PARTY_SITES SITE,
1763: HZ_CUST_SITE_USES_ALL SITE_USE,
1764: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1765: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID