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 1295: HZ_LOCATIONS LOC,

1291: SELECT
1292: LOC.ADDRESS1
1293: INTO L_END_CUSTOMER_ADDRESS1
1294: FROM
1295: HZ_LOCATIONS LOC,
1296: HZ_PARTY_SITES SITE,
1297: HZ_CUST_SITE_USES_ALL SITE_USE,
1298: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1299: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1328: HZ_LOCATIONS LOC,

1324: LOC.POSTAL_CODE,
1325: LOC.COUNTRY
1326: INTO L_END_CUSTOMER_CITY,L_END_CUSTOMER_STATE,L_END_CUSTOMER_POSTAL_CODE,L_END_CUSTOMER_COUNTRY
1327: FROM
1328: HZ_LOCATIONS LOC,
1329: HZ_PARTY_SITES SITE,
1330: HZ_CUST_SITE_USES SITE_USE,
1331: HZ_CUST_ACCT_SITES ACCT_SITE
1332: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1389: HZ_LOCATIONS LOC,

1385: SELECT
1386: LOC.COUNTRY
1387: INTO L_END_CUSTOMER_COUNTRY
1388: FROM
1389: HZ_LOCATIONS LOC,
1390: HZ_PARTY_SITES SITE,
1391: HZ_CUST_SITE_USES_ALL SITE_USE,
1392: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1393: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1452: HZ_LOCATIONS LOC,

1448: SELECT
1449: LOC.ADDRESS1
1450: INTO L_ADDRESS1
1451: FROM
1452: HZ_LOCATIONS LOC,
1453: HZ_PARTY_SITES SITE,
1454: HZ_CUST_SITE_USES_ALL SITE_USE,
1455: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1456: WHERE SITE_USE.SITE_USE_ID = (

Line 1471: HZ_LOCATIONS LOC,

1467: SELECT
1468: LOC.ADDRESS1
1469: INTO L_ADDRESS1
1470: FROM
1471: HZ_LOCATIONS LOC,
1472: HZ_PARTY_SITES SITE,
1473: HZ_CUST_SITE_USES_ALL SITE_USE,
1474: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1475: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1540: HZ_LOCATIONS LOC,

1536: LOC.POSTAL_CODE,
1537: LOC.COUNTRY
1538: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1539: FROM
1540: HZ_LOCATIONS LOC,
1541: HZ_PARTY_SITES SITE,
1542: HZ_CUST_SITE_USES_ALL SITE_USE,
1543: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1544: WHERE SITE_USE.SITE_USE_ID = (

Line 1579: HZ_LOCATIONS LOC,

1575: LOC.POSTAL_CODE,
1576: LOC.COUNTRY
1577: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1578: FROM
1579: HZ_LOCATIONS LOC,
1580: HZ_PARTY_SITES SITE,
1581: HZ_CUST_SITE_USES_ALL SITE_USE,
1582: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1583: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1638: HZ_LOCATIONS LOC,

1634: SELECT
1635: LOC.ADDRESS1
1636: INTO L_ADDRESS1
1637: FROM
1638: HZ_LOCATIONS LOC,
1639: HZ_PARTY_SITES SITE,
1640: HZ_CUST_SITE_USES_ALL SITE_USE,
1641: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1642: WHERE SITE_USE.SITE_USE_ID = (

Line 1657: HZ_LOCATIONS LOC,

1653: SELECT
1654: LOC.ADDRESS1
1655: INTO L_ADDRESS1
1656: FROM
1657: HZ_LOCATIONS LOC,
1658: HZ_PARTY_SITES SITE,
1659: HZ_CUST_SITE_USES_ALL SITE_USE,
1660: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1661: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID

Line 1726: HZ_LOCATIONS LOC,

1722: LOC.POSTAL_CODE,
1723: LOC.COUNTRY
1724: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1725: FROM
1726: HZ_LOCATIONS LOC,
1727: HZ_PARTY_SITES SITE,
1728: HZ_CUST_SITE_USES_ALL SITE_USE,
1729: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1730: WHERE SITE_USE.SITE_USE_ID = (

Line 1765: HZ_LOCATIONS LOC,

1761: LOC.POSTAL_CODE,
1762: LOC.COUNTRY
1763: INTO L_CITY,L_STATE,L_POSTAL_CODE,L_COUNTRY
1764: FROM
1765: HZ_LOCATIONS LOC,
1766: HZ_PARTY_SITES SITE,
1767: HZ_CUST_SITE_USES_ALL SITE_USE,
1768: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
1769: WHERE SITE_USE.SITE_USE_ID = END_CUSTOMER_SITE_USE_ID