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_CUST_ACCT_SITES

Line 670: update hz_cust_acct_sites

666: --
667: -- The procedure is only callled if one of the flags requires updating
668: -- therfore the if then else logic has been pushed into the sql
669: --
670: update hz_cust_acct_sites
671: set bill_to_flag = decode(p_site_use_code,
672: 'BILL_TO',p_site_use_flag,
673: bill_to_flag),
674: ship_to_flag = decode(p_site_use_code,

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 733: from hz_cust_acct_sites addr

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;
735: --
736: --
737: if ( dummy >=1 ) then

Line 763: from hz_cust_acct_sites

759: ) then
760: --
761: select status
762: into l_status
763: from hz_cust_acct_sites
764: where rowid = p_rowid;
765: --
766: if ( l_status = 'A' ) then
767: --

Line 1236: UPDATE hz_cust_acct_sites

1232: return;
1233: END IF;
1234:
1235:
1236: UPDATE hz_cust_acct_sites
1237: SET party_site_id = x_party_site_id
1238: WHERE cust_acct_site_id = x_cust_acct_site_id;
1239:
1240: END IF;

Line 1278: arp_standard.debug('ARHADDRB:Insert Row: After Insert into hz_cust_Acct_sites');

1274:
1275: END IF;
1276: --}
1277:
1278: arp_standard.debug('ARHADDRB:Insert Row: After Insert into hz_cust_Acct_sites');
1279:
1280: IF ( x_address_mode = 'QUICK' ) THEN
1281: IF ( x_su_bill_to_flag = 'Y' ) THEN
1282: insert_site_use (X_Cust_account_id,x_address_id,'BILL_TO',x_msg_count,x_msg_data, x_return_status);

Line 1476: FROM HZ_CUST_ACCT_SITES

1472: CURSOR cu_version_account_site IS
1473: SELECT ROWID,
1474: OBJECT_VERSION_NUMBER,
1475: LAST_UPDATE_DATE
1476: FROM HZ_CUST_ACCT_SITES
1477: WHERE CUST_ACCT_SITE_ID = X_address_id;
1478:
1479: l_object_version_number NUMBER;
1480: l_rowid ROWID;

Line 1595: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_acct_sites');

1591: l_object_version_number,
1592: l_last_update_date ;
1593: IF cu_version_account_site%NOTFOUND THEN
1594: FND_MESSAGE.SET_NAME('AR','HZ_API_NO_RECORD');
1595: FND_MESSAGE.SET_TOKEN('RECORD','hz_cust_acct_sites');
1596: FND_MESSAGE.SET_TOKEN('ID',x_cust_acct_site_id);
1597: FND_MSG_PUB.ADD;
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599: ELSE

Line 1898: FROM hz_cust_acct_sites

1894: END IF;
1895:
1896: SELECT last_update_date
1897: INTO x_last_update_date
1898: FROM hz_cust_acct_sites
1899: WHERE cust_acct_site_id = x_address_id;
1900:
1901: --
1902: --

Line 1986: from hz_cust_acct_sites acct_site,

1982: BEGIN
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

Line 2059: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);

2055: select change_printed_invoice_flag
2056: into check_value
2057: from ar_system_parameters_all
2058: where org_id =
2059: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);
2060:
2061: --Bug fix 2183072 Handled the exception.
2062: EXCEPTION
2063: WHEN NO_DATA_FOUND THEN

Line 2213: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);

2209: select change_printed_invoice_flag
2210: into check_value
2211: from ar_system_parameters_all
2212: where org_id =
2213: (select org_id from hz_cust_acct_sites_all where cust_acct_site_id = p_address_id);
2214:
2215: --Bug fix 2183072 Handled the exception.
2216: EXCEPTION
2217: WHEN NO_DATA_FOUND THEN

Line 2370: hz_cust_acct_sites_all acct_site

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;
2374: --

Line 2388: hz_cust_acct_sites_all acct_site

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;
2392:

Line 2555: hz_cust_acct_sites_all acct_site

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;
2559: --

Line 2572: hz_cust_acct_sites_all acct_site

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;
2576: --

Line 2741: hz_cust_acct_sites_all acct_site

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;
2745: --

Line 2758: hz_cust_acct_sites_all acct_site

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;
2762:

Line 3416: hz_cust_acct_sites_all acct_site

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;
3420: /*bug 4605384 cursor for loc*/

Line 3425: hz_cust_acct_sites_all acct_site

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;
3429: BEGIN

Line 3519: from hz_cust_acct_sites addr

3515: begin
3516:
3517: select count(1)
3518: into dummy
3519: from hz_cust_acct_sites addr
3520: where addr.cust_account_id = p_customer_id
3521: and addr.ece_tp_location_code = p_edi_location
3522: and addr.orig_system_reference <> p_orig_system_reference;
3523: --