APPS.AR_INVOICE_UTILS dependencies on HZ_PARTY_SITES

Line 1684: HZ_PARTY_SITES PARTY_SITE,

1680: WHERE gt.bill_to_address_id IS NOT NULL
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

Line 2081: HZ_PARTY_SITES PARTY_SITE,

2077: WHERE gt.primary_salesrep_id IS NOT NULL
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

Line 2881: HZ_PARTY_SITES PARTY_SITE,

2877: UPDATE ar_trx_header_gt gt
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

Line 3134: hz_party_sites party_site,

3130: UPDATE ar_trx_header_gt gt
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

Line 3184: hz_party_sites party_site,

3180: loc.state,
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

Line 3215: hz_party_sites party_site,

3211: UPDATE ar_trx_header_gt gt
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'

Line 3442: hz_party_sites party_site,

3438: UPDATE ar_trx_header_gt gt
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