APPS.AR_INVOICE_UTILS dependencies on HZ_LOCATIONS

Line 1685: --HZ_LOCATIONS LOC,

1681: AND NOT EXISTS (
1682: SELECT 'X'
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

Line 2082: HZ_LOCATIONS LOC,

2078: AND NOT EXISTS (
2079: SELECT 'X'
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

Line 2882: HZ_LOCATIONS LOC,

2878: SET gt.primary_salesrep_id =
2879: ( SELECT SU.PRIMARY_SALESREP_ID
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

Line 3135: hz_locations loc,

3131: SET gt.bill_to_address_id = (
3132: SELECT su.cust_acct_site_id
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

Line 3185: hz_locations loc,

3181: loc.country,
3182: loc.postal_code
3183: FROM hz_cust_acct_sites acct_site,
3184: hz_party_sites party_site,
3185: hz_locations loc,
3186: hz_cust_site_uses su
3187: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
3188: AND su.site_use_id = l_site_use_id
3189: AND acct_site.party_site_id = party_site.party_site_id

Line 3216: hz_locations loc,

3212: SET remit_to_address_id = (
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

Line 3443: hz_locations loc,

3439: SET gt.ship_to_address_id = (
3440: SELECT su.cust_acct_site_id
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