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_PARTY_SITES

Line 694: update hz_party_sites set identifying_address_flag = 'N'

690: --
691: procedure identifying_address_flag(x_party_id in number ) is
692:
693: begin
694: update hz_party_sites set identifying_address_flag = 'N'
695: where party_id = x_party_id and identifying_address_flag = 'Y';
696:
697: end identifying_address_flag;
698: --

Line 1469: FROM HZ_PARTY_SITES

1465: CURSOR cu_version_party_site IS
1466: SELECT ROWID,
1467: OBJECT_VERSION_NUMBER,
1468: LAST_UPDATE_DATE
1469: FROM HZ_PARTY_SITES
1470: WHERE PARTY_SITE_ID = X_Party_site_id;
1471:
1472: CURSOR cu_version_account_site IS
1473: SELECT ROWID,

Line 1548: FND_MESSAGE.SET_TOKEN('RECORD','hz_party_sites');

1544: l_object_version_number,
1545: l_last_update_date ;
1546: IF cu_version_party_site%NOTFOUND THEN
1547: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1548: FND_MESSAGE.SET_TOKEN('RECORD','hz_party_sites');
1549: FND_MESSAGE.SET_TOKEN('ID',x_party_site_id);
1550: FND_MSG_PUB.ADD;
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: ELSE

Line 1561: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');

1557: IF TO_CHAR(X_party_site_Last_Update_Date,'DD-MON-YYYY HH:MI:SS') <>
1558: TO_CHAR(l_last_update_date,'DD-MON-YYYY HH:MI:SS')
1559: THEN
1560: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1561: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_party_sites');
1562: FND_MSG_PUB.ADD;
1563: x_return_status := FND_API.G_RET_STS_ERROR;
1564: END IF;
1565: ELSE

Line 1871: FROM hz_party_sites

1867: END IF;
1868:
1869: SELECT last_update_date
1870: INTO x_party_site_last_update_date
1871: FROM hz_party_sites
1872: WHERE party_site_id = x_party_site_id;
1873:
1874: ----------------------
1875: -- Account_Site update

Line 1987: hz_party_sites party_site,

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

Line 2369: hz_party_sites party_site,

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
2373: AND loc.location_id = p_location_id;

Line 2387: hz_party_sites party_site,

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
2391: and loc.location_id = p_location_id;

Line 2554: hz_party_sites party_site,

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
2558: AND loc.location_id = p_location_id;

Line 2571: hz_party_sites party_site,

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
2575: and loc.location_id = p_location_id;

Line 2740: hz_party_sites party_site,

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
2744: AND loc.location_id = p_location_id;

Line 2757: hz_party_sites party_site,

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
2761: and loc.location_id = p_location_id;

Line 3415: hz_party_sites party_site,

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
3419: and loc.location_id = p_location_id;

Line 3424: hz_party_sites party_site,

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
3428: and loc.location_id = p_location_id;