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.AR_INVOICE_UTILS dependencies on FND_TERRITORIES_VL

Line 1741: -- FND_TERRITORIES_VL T

1737: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
1738: HZ_PARTY_SITES PARTY_SITE,
1739: --HZ_LOCATIONS LOC,
1740: HZ_CUST_SITE_USES SU
1741: -- FND_TERRITORIES_VL T
1742: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1743: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1744: --AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1745: --AND LOC.COUNTRY = T.TERRITORY_CODE

Line 2161: FND_TERRITORIES_VL T

2157: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
2158: HZ_PARTY_SITES PARTY_SITE,
2159: HZ_LOCATIONS LOC,
2160: HZ_CUST_SITE_USES SU,
2161: FND_TERRITORIES_VL T
2162: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2163: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2164: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2165: AND LOC.COUNTRY = T.TERRITORY_CODE

Line 2961: FND_TERRITORIES_VL T

2957: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
2958: HZ_PARTY_SITES PARTY_SITE,
2959: HZ_LOCATIONS LOC,
2960: HZ_CUST_SITE_USES SU,
2961: FND_TERRITORIES_VL T
2962: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2963: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2964: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2965: AND LOC.COUNTRY = T.TERRITORY_CODE

Line 3232: fnd_territories_vl t

3228: FROM hz_cust_acct_sites acct_site,
3229: hz_party_sites party_site,
3230: hz_locations loc,
3231: hz_cust_site_uses su,
3232: fnd_territories_vl t
3233: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
3234: AND acct_site.party_site_id = party_site.party_site_id
3235: AND loc.location_id = party_site.location_id
3236: AND loc.country = t.territory_code

Line 3312: fnd_territories_vl territory,

3308: SELECT acct_site.cust_acct_site_id
3309: FROM hz_cust_acct_sites acct_site,
3310: hz_party_sites party_site,
3311: hz_locations loc,
3312: fnd_territories_vl territory,
3313: ra_remit_tos rt
3314: WHERE NVL( acct_site.status, 'A' ) = 'A'
3315: AND acct_site.cust_acct_site_id = rt.address_id
3316: AND acct_site.party_site_id = party_site.party_site_id

Line 3540: fnd_territories_vl t

3536: FROM hz_cust_acct_sites acct_site,
3537: hz_party_sites party_site,
3538: hz_locations loc,
3539: hz_cust_site_uses su,
3540: fnd_territories_vl t
3541: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
3542: AND acct_site.party_site_id = party_site.party_site_id
3543: AND loc.location_id = party_site.location_id
3544: AND loc.country = t.territory_code