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_SITE_USES

Line 534: hz_cust_site_uses site_uses

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
538: AND site_uses.site_use_code IN

Line 1637: FROM hz_cust_site_uses ct

1633: FROM ar_trx_header_gt gt
1634: WHERE gt.bill_to_site_use_id IS NOT NULL
1635: AND NOT EXISTS (
1636: SELECT 'X'
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

Line 1686: HZ_CUST_SITE_USES SU

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
1690: --AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 1779: FROM hz_cust_site_uses ct

1775: WHERE gt.ship_to_site_use_id IS NOT NULL
1776: AND gt.ship_to_customer_id IS NOT NULL
1777: AND NOT EXISTS (
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)

Line 1839: HZ_CUST_SITE_USES SU

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'
1843: ) asa

Line 1880: FROM hz_cust_site_uses

1876:
1877: UPDATE ar_trx_header_gt gt
1878: SET ship_to_site_use_id = (
1879: SELECT site_use_id
1880: FROM hz_cust_site_uses
1881: WHERE site_use_code = 'SHIP_TO'
1882: AND cust_acct_site_id = gt.ship_to_address_id
1883: AND gt.ship_to_site_use_id IS NULL
1884: AND gt.ship_to_address_id IS NOT NULL)

Line 1894: FROM hz_cust_site_uses

1890:
1891: UPDATE ar_trx_header_gt gt
1892: SET ship_to_site_use_id = (
1893: SELECT site_use_id
1894: FROM hz_cust_site_uses
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

Line 1957: HZ_CUST_SITE_USES SU

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'
1961: )asa

Line 2083: HZ_CUST_SITE_USES SU,

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
2087: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 2883: HZ_CUST_SITE_USES SU,

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
2887: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID

Line 3013: FROM hz_cust_site_uses

3009:
3010: UPDATE ar_trx_header_gt gt
3011: SET bill_to_site_use_id = (
3012: SELECT site_use_id
3013: FROM hz_cust_site_uses
3014: WHERE site_use_code = 'BILL_TO'
3015: AND cust_acct_site_id = gt.bill_to_address_id
3016: AND gt.bill_to_site_use_id IS NULL
3017: AND gt.bill_to_address_id IS NOT NULL)

Line 3027: FROM hz_cust_site_uses

3023:
3024: UPDATE ar_trx_header_gt gt
3025: SET bill_to_site_use_id = (
3026: SELECT site_use_id
3027: FROM hz_cust_site_uses
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

Line 3085: FROM hz_cust_site_uses

3081:
3082: UPDATE ar_trx_header_gt gt
3083: SET paying_site_use_id = (
3084: SELECT site_use_id
3085: FROM hz_cust_site_uses
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

Line 3119: FROM hz_cust_site_uses

3115:
3116: UPDATE ar_trx_header_gt gt
3117: SET bill_to_address_id = (
3118: SELECT site_use_id
3119: FROM hz_cust_site_uses
3120: WHERE site_use_code = 'BILL_TO'
3121: AND site_use_id= gt.bill_to_site_use_id
3122: AND gt.bill_to_address_id IS NULL
3123: AND gt.bill_to_site_use_id IS NOT NULL)

Line 3136: hz_cust_site_uses su,

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
3140: AND loc.location_id = party_site.location_id

Line 3186: hz_cust_site_uses su

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
3190: AND loc.location_id = party_site.location_id;

Line 3426: FROM hz_cust_site_uses

3422:
3423: UPDATE ar_trx_header_gt gt
3424: SET ship_to_address_id = (
3425: SELECT site_use_id
3426: FROM hz_cust_site_uses
3427: WHERE site_use_code = 'SHIP_TO'
3428: AND site_use_id= gt.ship_to_site_use_id
3429: AND gt.ship_to_address_id IS NULL
3430: AND gt.ship_to_site_use_id IS NOT NULL)

Line 3444: hz_cust_site_uses su,

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
3448: AND loc.location_id = party_site.location_id

Line 3561: FROM HZ_CUST_SITE_USES hz, ar_trx_header_gt gt

3557: AND NVL(st.end_date_active(+), gt.trx_date );
3558:
3559: CURSOR cBillTo IS
3560: SELECT /*+ LEADING(gt) */ hz.territory_id, gt.bill_to_site_use_id
3561: FROM HZ_CUST_SITE_USES hz, ar_trx_header_gt gt
3562: WHERE hz.site_use_id = gt.bill_to_site_use_id;
3563:
3564: CURSOR cShipTo IS
3565: SELECT /*+ LEADING(gt) */ site_uses.territory_id, gt.ship_to_site_use_id,

Line 3567: FROM HZ_CUST_SITE_USES site_uses,

3563:
3564: CURSOR cShipTo IS
3565: SELECT /*+ LEADING(gt) */ site_uses.territory_id, gt.ship_to_site_use_id,
3566: gt.ship_to_customer_id
3567: FROM HZ_CUST_SITE_USES site_uses,
3568: ar_trx_header_gt gt
3569: WHERE site_uses.SITE_USE_CODE = 'SHIP_TO'
3570: AND site_uses.site_use_id = gt.ship_to_site_use_id
3571: AND site_uses.primary_flag = 'Y';

Line 3678: from hz_cust_site_uses

3674: x_return_status := FND_API.G_RET_STS_SUCCESS;
3675:
3676: UPDATE ar_trx_header_gt gt
3677: SET bill_to_site_use_id = (select site_use_id
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

Line 3700: hz_cust_site_uses su

3696: ra_terms t_cp2,
3697: ra_terms tl, /*Bug 3984916*/
3698: hz_customer_profiles cp1,
3699: hz_customer_profiles cp2,
3700: hz_cust_site_uses su
3701: WHERE gt.bill_to_customer_id = cp1.cust_account_id(+)
3702: AND su.site_use_id = gt.bill_to_site_use_id
3703: AND cp2.cust_account_id = gt.bill_to_customer_id
3704: AND su.site_use_id = cp1.site_use_id(+)