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.ARPT_SQL_FUNC_UTIL dependencies on HZ_CUST_ACCT_SITES

Line 1445: hz_cust_acct_sites acct_site,

1441: /* modified for tca uptake */
1442: CURSOR c_territory IS
1443: select ft.territory_short_name
1444: from fnd_territories_vl ft,
1445: hz_cust_acct_sites acct_site,
1446: hz_party_sites party_site,
1447: hz_locations loc
1448: where loc.country = ft.territory_code
1449: and acct_site.party_site_id = party_site.party_site_id

Line 1499: hz_cust_acct_sites acct_site,

1495: /* modified for tca uptake */
1496: CURSOR c_territory IS
1497: select ft.rowid
1498: from fnd_territories_vl ft,
1499: hz_cust_acct_sites acct_site,
1500: hz_party_sites party_site,
1501: hz_locations loc
1502: where loc.country = ft.territory_code
1503: and acct_site.party_site_id = party_site.party_site_id

Line 1613: hz_cust_acct_sites acct_site,

1609: (
1610: SELECT 'commitments_exist'
1611: FROM hz_cust_accounts cust_acct,
1612: so_agreements soa,
1613: hz_cust_acct_sites acct_site,
1614: ra_cust_trx_types inv_type,
1615: ra_cust_trx_types type,
1616: ra_customer_trx trx
1617: WHERE trx.cust_trx_type_id = type.cust_trx_type_id

Line 2057: FROM hz_cust_acct_sites acct_site,

2053: acct_site.STATUS
2054: INTO l_add1, l_add2, l_add3, l_add4,
2055: l_city, l_state,l_province, l_postal_code, l_country,
2056: l_status
2057: FROM hz_cust_acct_sites acct_site,
2058: hz_party_sites party_site,
2059: hz_locations loc
2060: WHERE acct_site.party_site_id = party_site.party_site_id
2061: AND loc.location_id = party_site.location_id