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 HZ_CUST_ACCT_SITES

Line 533: FROM hz_cust_acct_sites acct_site,

529: FROM ar_trx_header_gt gt
530: WHERE gt.paying_site_use_id IS NOT NULL
531: AND NOT EXISTS
532: (SELECT 'X'
533: FROM hz_cust_acct_sites acct_site,
534: hz_cust_site_uses site_uses
535: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
536: AND acct_site.cust_account_id = gt.paying_customer_id
537: AND site_uses.site_use_id = gt.paying_site_use_id

Line 1641: FROM hz_cust_acct_sites

1637: FROM hz_cust_site_uses ct
1638: WHERE site_use_code = 'BILL_TO'
1639: AND cust_acct_site_id in (
1640: SELECT cust_acct_site_id
1641: FROM hz_cust_acct_sites
1642: WHERE cust_account_id = gt.bill_to_customer_id)
1643: AND site_use_id = gt.bill_to_site_use_id);
1644:
1645: IF pg_debug = 'Y'

Line 1683: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

1679: FROM ar_trx_header_gt gt
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

Line 1782: select cust_acct_site_id from hz_cust_acct_sites

1778: SELECT 'X'
1779: FROM hz_cust_site_uses ct
1780: WHERE site_use_code = 'SHIP_TO'
1781: and cust_acct_site_id in (
1782: select cust_acct_site_id from hz_cust_acct_sites
1783: where cust_account_id = gt.ship_to_customer_id)
1784: and site_use_id = gt.ship_to_site_use_id);
1785:
1786: INSERT INTO ar_trx_errors_gt (

Line 1838: HZ_CUST_ACCT_SITES A,

1834: A.STATUS A_STATUS ,
1835: SU.STATUS SU_STATUS ,
1836: SU.SITE_USE_ID SITE_USE_ID
1837: FROM
1838: HZ_CUST_ACCT_SITES A,
1839: HZ_CUST_SITE_USES SU
1840: WHERE
1841: A.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1842: AND SU.SITE_USE_CODE = 'SHIP_TO'

Line 1899: FROM hz_cust_acct_sites

1895: WHERE primary_flag = 'Y'
1896: AND site_use_code = 'SHIP_TO'
1897: AND cust_acct_site_id IN (
1898: SELECT cust_acct_site_id
1899: FROM hz_cust_acct_sites
1900: WHERE cust_account_id = gt.ship_to_customer_id))
1901: WHERE gt.ship_to_site_use_id IS NULL;
1902:
1903: IF pg_debug = 'Y' THEN

Line 1956: HZ_CUST_ACCT_SITES A,

1952: A.STATUS A_STATUS ,
1953: SU.STATUS SU_STATUS ,
1954: SU.SITE_USE_ID SITE_USE_ID
1955: FROM
1956: HZ_CUST_ACCT_SITES A,
1957: HZ_CUST_SITE_USES SU
1958: WHERE
1959: A.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
1960: AND SU.SITE_USE_CODE = 'SHIP_TO'

Line 2080: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

2076: FROM ar_trx_header_gt gt
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

Line 2880: FROM HZ_CUST_ACCT_SITES ACCT_SITE,

2876:
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

Line 3032: FROM hz_cust_acct_sites

3028: WHERE primary_flag = 'Y'
3029: AND site_use_code = 'BILL_TO'
3030: AND cust_acct_site_id IN (
3031: SELECT cust_acct_site_id
3032: FROM hz_cust_acct_sites
3033: WHERE cust_account_id = gt.bill_to_customer_id))
3034: WHERE gt.bill_to_site_use_id IS NULL;
3035:
3036: IF pg_debug = 'Y' THEN

Line 3090: FROM hz_cust_acct_sites

3086: WHERE primary_flag = 'Y'
3087: AND site_use_code = 'BILL_TO'
3088: AND cust_acct_site_id IN (
3089: SELECT cust_acct_site_id
3090: FROM hz_cust_acct_sites
3091: WHERE cust_account_id = gt.paying_customer_id))
3092: WHERE gt.paying_site_use_id IS NULL;
3093:
3094: IF pg_debug = 'Y' THEN

Line 3133: FROM hz_cust_acct_sites acct_site,

3129:
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

Line 3183: FROM hz_cust_acct_sites acct_site,

3179: SELECT su.site_use_id,
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

Line 3214: FROM hz_cust_acct_sites acct_site,

3210:
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

Line 3441: FROM hz_cust_acct_sites acct_site,

3437:
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

Line 3682: select cust_acct_site_id from hz_cust_acct_sites

3678: from hz_cust_site_uses
3679: where primary_flag = 'Y'
3680: and site_use_code = 'BILL_TO'
3681: and cust_acct_site_id in (
3682: select cust_acct_site_id from hz_cust_acct_sites
3683: where cust_account_id = gt.bill_to_customer_id))
3684: WHERE gt.bill_to_site_use_id IS NULL;
3685: -- Get the Term Id
3686: IF pg_debug = 'Y'