APPS.AR_INVOICE_UTILS dependencies on HZ_PARTY_SITES

Line 1738: HZ_PARTY_SITES PARTY_SITE,

1734: WHERE gt.bill_to_address_id IS NOT NULL
1735: AND NOT EXISTS (
1736: SELECT 'X'
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

Line 2158: HZ_PARTY_SITES PARTY_SITE,

2154: WHERE gt.primary_salesrep_id IS NOT NULL
2155: AND NOT EXISTS (
2156: SELECT 'X'
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

Line 2958: HZ_PARTY_SITES PARTY_SITE,

2954: UPDATE ar_trx_header_gt gt
2955: SET gt.primary_salesrep_id =
2956: ( SELECT SU.PRIMARY_SALESREP_ID
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

Line 3229: hz_party_sites party_site,

3225: UPDATE ar_trx_header_gt gt
3226: SET gt.bill_to_address_id = (
3227: SELECT su.cust_acct_site_id
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

Line 3279: hz_party_sites party_site,

3275: loc.state,
3276: loc.country,
3277: loc.postal_code
3278: FROM hz_cust_acct_sites acct_site,
3279: hz_party_sites party_site,
3280: hz_locations loc,
3281: hz_cust_site_uses su
3282: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
3283: AND su.site_use_id = l_site_use_id

Line 3310: hz_party_sites party_site,

3306: UPDATE ar_trx_header_gt gt
3307: SET remit_to_address_id = (
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'

Line 3537: hz_party_sites party_site,

3533: UPDATE ar_trx_header_gt gt
3534: SET gt.ship_to_address_id = (
3535: SELECT su.cust_acct_site_id
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