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.ARH_ADDR_PKG dependencies on HZ_LOCATIONS

Line 730: --Bug Fix:1956757,hz_locations table is replaced by hz_cust_acct_sites in the following select statement.

726: dummy number;
727: --
728: begin
729:
730: --Bug Fix:1956757,hz_locations table is replaced by hz_cust_acct_sites in the following select statement.
731: select count(1)
732: into dummy
733: from hz_cust_acct_sites addr
734: where addr.orig_system_reference = p_orig_system_reference;

Line 941: from hz_locations

937: WHILE l_count > 0 loop
938: select hr_locations_s.nextval into x_location_id from dual;
939:
940: select count(*) into l_count
941: from hz_locations
942: where location_id = x_location_id;
943:
944: END LOOP;
945: ELSE

Line 968: from hz_locations

964: WHILE l_count > 0 loop
965: select hr_locations_s.nextval into x_location_id from dual;
966:
967: select count(*) into l_count
968: from hz_locations
969: where location_id = x_location_id;
970:
971: END LOOP;
972: i_create_location := 'Y';

Line 1462: FROM HZ_LOCATIONS

1458: CURSOR cu_version_location IS
1459: SELECT ROWID,
1460: OBJECT_VERSION_NUMBER,
1461: LAST_UPDATE_DATE
1462: FROM HZ_LOCATIONS
1463: WHERE LOCATION_ID = x_location_id;
1464:
1465: CURSOR cu_version_party_site IS
1466: SELECT ROWID,

Line 1510: FND_MESSAGE.SET_TOKEN('RECORD','hz_locations');

1506: l_object_version_number,
1507: l_last_update_date ;
1508: IF cu_version_location%NOTFOUND THEN
1509: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1510: FND_MESSAGE.SET_TOKEN('RECORD','hz_locations');
1511: FND_MESSAGE.SET_TOKEN('ID',x_location_id);
1512: FND_MSG_PUB.ADD;
1513: x_return_status := FND_API.G_RET_STS_ERROR;
1514: ELSE

Line 1523: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_locations');

1519: IF TO_CHAR(X_loc_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1520: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1521: THEN
1522: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1523: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_locations');
1524: FND_MSG_PUB.ADD;
1525: x_return_status := FND_API.G_RET_STS_ERROR;
1526: END IF;
1527: ELSE

Line 1844: FROM hz_locations

1840: END IF;
1841:
1842: SELECT last_update_date
1843: INTO x_loc_last_update_date
1844: FROM hz_locations
1845: WHERE location_id = x_location_id;
1846:
1847: --------------------
1848: -- Party_Site update

Line 1988: hz_locations loc,

1984: select loc_assign.loc_id
1985: into location_identifier
1986: from hz_cust_acct_sites acct_site,
1987: hz_party_sites party_site,
1988: hz_locations loc,
1989: hz_loc_assignments loc_assign
1990: where acct_site.party_site_id = party_site.party_site_id
1991: and loc.location_id = party_site.location_id
1992: and loc.location_id = loc_assign.location_id

Line 2368: FROM hz_locations loc,

2364: -- find all possible customer accounts which use this location
2365: CURSOR c_cust_addrs IS
2366: SELECT acct_site.cust_account_id,
2367: acct_site.cust_acct_site_id
2368: FROM hz_locations loc,
2369: hz_party_sites party_site,
2370: hz_cust_acct_sites_all acct_site
2371: WHERE loc.location_id = party_site.location_id
2372: AND party_site.party_site_id = acct_site.party_site_id

Line 2386: from hz_locations loc,

2382: */
2383: --
2384: CURSOR c_org_for_loc IS
2385: select distinct acct_site.org_id
2386: from hz_locations loc,
2387: hz_party_sites party_site,
2388: hz_cust_acct_sites_all acct_site
2389: where loc.location_id = party_site.location_id
2390: and party_site.party_site_id = acct_site.party_site_id

Line 2553: FROM hz_locations loc,

2549: -- find all possible customer accounts which use this location
2550: CURSOR c_cust_addrs IS
2551: SELECT acct_site.cust_account_id,
2552: acct_site.cust_acct_site_id
2553: FROM hz_locations loc,
2554: hz_party_sites party_site,
2555: hz_cust_acct_sites_all acct_site
2556: WHERE loc.location_id = party_site.location_id
2557: AND party_site.party_site_id = acct_site.party_site_id

Line 2570: from hz_locations loc,

2566: FROM ar_system_parameters;
2567: */
2568: CURSOR c_org_for_loc IS
2569: select distinct acct_site.org_id
2570: from hz_locations loc,
2571: hz_party_sites party_site,
2572: hz_cust_acct_sites_all acct_site
2573: where loc.location_id = party_site.location_id
2574: and party_site.party_site_id = acct_site.party_site_id

Line 2739: FROM hz_locations loc,

2735: -- find all possible customer accounts which use this location
2736: CURSOR c_cust_addrs IS
2737: SELECT acct_site.cust_account_id,
2738: acct_site.cust_acct_site_id
2739: FROM hz_locations loc,
2740: hz_party_sites party_site,
2741: hz_cust_acct_sites_all acct_site
2742: WHERE loc.location_id = party_site.location_id
2743: AND party_site.party_site_id = acct_site.party_site_id

Line 2756: from hz_locations loc,

2752: FROM ar_system_parameters;
2753: */
2754: CURSOR c_org_for_loc IS
2755: select distinct acct_site.org_id
2756: from hz_locations loc,
2757: hz_party_sites party_site,
2758: hz_cust_acct_sites_all acct_site
2759: where loc.location_id = party_site.location_id
2760: and party_site.party_site_id = acct_site.party_site_id

Line 2921: FROM hz_locations loc

2917: loc.street_suffix,
2918: loc.suite ,
2919: loc.Sales_Tax_Inside_City_Limits,
2920: loc.Sales_Tax_Geocode
2921: FROM hz_locations loc
2922: WHERE location_id = p_location_id;
2923: l_location_rec hz_location_v2pub.location_rec_type;
2924: loc_modified VARCHAR2(1) := 'N';
2925: BEGIN

Line 3414: from hz_locations loc,

3410:
3411: -- find all possible customer accounts which use this location
3412: cursor c_cust_addrs is
3413: select acct_site.cust_account_id, acct_site.cust_acct_site_id
3414: from hz_locations loc,
3415: hz_party_sites party_site,
3416: hz_cust_acct_sites_all acct_site
3417: where loc.location_id = party_site.location_id
3418: and party_site.party_site_id = acct_site.party_site_id

Line 3423: from hz_locations loc,

3419: and loc.location_id = p_location_id;
3420: /*bug 4605384 cursor for loc*/
3421: cursor c_org_for_loc is
3422: select distinct acct_site.org_id
3423: from hz_locations loc,
3424: hz_party_sites party_site,
3425: hz_cust_acct_sites_all acct_site
3426: where loc.location_id = party_site.location_id
3427: and party_site.party_site_id = acct_site.party_site_id