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 1687: -- FND_TERRITORIES_VL T

1683: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
1684: HZ_PARTY_SITES PARTY_SITE,
1685: --HZ_LOCATIONS LOC,
1686: HZ_CUST_SITE_USES SU
1687: -- FND_TERRITORIES_VL T
1688: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1689: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
1690: --AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
1691: --AND LOC.COUNTRY = T.TERRITORY_CODE

Line 2084: FND_TERRITORIES_VL T

2080: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
2081: HZ_PARTY_SITES PARTY_SITE,
2082: HZ_LOCATIONS LOC,
2083: HZ_CUST_SITE_USES SU,
2084: FND_TERRITORIES_VL T
2085: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2086: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2087: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2088: AND LOC.COUNTRY = T.TERRITORY_CODE

Line 2884: FND_TERRITORIES_VL T

2880: FROM HZ_CUST_ACCT_SITES ACCT_SITE,
2881: HZ_PARTY_SITES PARTY_SITE,
2882: HZ_LOCATIONS LOC,
2883: HZ_CUST_SITE_USES SU,
2884: FND_TERRITORIES_VL T
2885: WHERE ACCT_SITE.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
2886: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
2887: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
2888: AND LOC.COUNTRY = T.TERRITORY_CODE

Line 3137: fnd_territories_vl t

3133: FROM hz_cust_acct_sites acct_site,
3134: hz_party_sites party_site,
3135: hz_locations loc,
3136: hz_cust_site_uses su,
3137: fnd_territories_vl t
3138: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
3139: AND acct_site.party_site_id = party_site.party_site_id
3140: AND loc.location_id = party_site.location_id
3141: AND loc.country = t.territory_code

Line 3217: fnd_territories_vl territory,

3213: SELECT acct_site.cust_acct_site_id
3214: FROM hz_cust_acct_sites acct_site,
3215: hz_party_sites party_site,
3216: hz_locations loc,
3217: fnd_territories_vl territory,
3218: ra_remit_tos rt
3219: WHERE NVL( acct_site.status, 'A' ) = 'A'
3220: AND acct_site.cust_acct_site_id = rt.address_id
3221: AND acct_site.party_site_id = party_site.party_site_id

Line 3445: fnd_territories_vl t

3441: FROM hz_cust_acct_sites acct_site,
3442: hz_party_sites party_site,
3443: hz_locations loc,
3444: hz_cust_site_uses su,
3445: fnd_territories_vl t
3446: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
3447: AND acct_site.party_site_id = party_site.party_site_id
3448: AND loc.location_id = party_site.location_id
3449: AND loc.country = t.territory_code