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_DEPOSIT_LIB_PVT dependencies on HZ_CUST_ACCT_SITES

Line 103: hz_cust_acct_sites acct_site,

99: hz_parties party,
100: hz_relationships rel,
101: hz_org_contacts org_cont,
102: hz_parties rel_party,
103: hz_cust_acct_sites acct_site,
104: hz_cust_site_uses site_uses
105: where acct_role.party_id = rel.party_id
106: and acct_role.role_type = 'CONTACT'
107: and org_cont.party_relationship_id = rel.relationship_id

Line 273: from hz_cust_acct_sites acct_site,

269:
270: begin
271: select su.primary_salesrep_id
272: into l_default_srep_id_1
273: from hz_cust_acct_sites acct_site,
274: hz_party_sites party_site,
275: hz_locations loc,
276: hz_cust_site_uses su,
277: fnd_territories_vl t

Line 323: HZ_CUST_ACCT_SITES A,

319: SU.STATUS SU_STATUS ,
320: SU.SITE_USE_ID SITE_USE_ID ,
321: SU.PRIMARY_SALESREP_ID
322: FROM
323: HZ_CUST_ACCT_SITES A,
324: HZ_CUST_SITE_USES SU
325: WHERE
326: A.CUST_ACCT_SITE_ID = SU.CUST_ACCT_SITE_ID
327: AND SU.SITE_USE_CODE = 'SHIP_TO'

Line 970: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,

966: | FUNCTION Get_Site_Use_Id will get Site_Use_Id of customer location
967: +=======================================================================*/
968:
969: FUNCTION Get_Site_Use_Id(
970: p_customer_id IN hz_cust_acct_sites.cust_account_id%TYPE,
971: p_location IN hz_cust_site_uses.location%TYPE,
972: p_site_use_code1 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
973: p_site_use_code2 IN hz_cust_site_uses.site_use_code%TYPE DEFAULT NULL,
974: p_return_status OUT NOCOPY VARCHAR2)

Line 991: hz_cust_acct_sites acct_site

987:
988: SELECT site_use.site_use_id
989: INTO l_selected_id
990: FROM hz_cust_site_uses site_use,
991: hz_cust_acct_sites acct_site
992: WHERE acct_site.cust_account_id = p_customer_id
993: AND acct_site.status = 'A'
994: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
995: AND (site_use.site_use_code = nvl(p_site_use_code1,

Line 1020: hz_cust_acct_sites acct_site

1016:
1017: SELECT site_use.site_use_id
1018: INTO l_selected_id
1019: FROM hz_cust_site_uses site_use,
1020: hz_cust_acct_sites acct_site
1021: WHERE acct_site.cust_account_id = p_customer_id
1022: AND acct_site.status = 'A'
1023: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id
1024: AND (site_use.site_use_code = nvl(p_site_use_code1,

Line 1946: from hz_cust_acct_sites acct_site,

1942: -- find default for l_bill_to_location
1943: Begin
1944: select su.location
1945: into l_dft_bill_to_location
1946: from hz_cust_acct_sites acct_site,
1947: hz_party_sites party_site,
1948: hz_locations loc,
1949: hz_cust_site_uses su,
1950: fnd_territories_vl t

Line 1980: from hz_cust_acct_sites acct_site,

1976: -- find default for l_ship_to_location
1977: Begin
1978: select su.location
1979: into l_dft_ship_to_location
1980: from hz_cust_acct_sites acct_site,
1981: hz_party_sites party_site,
1982: hz_locations loc,
1983: hz_cust_site_uses su,
1984: fnd_territories_vl t

Line 2577: from hz_cust_acct_sites acct_site,

2573: --get default location of paying customer
2574: Begin
2575: select su.site_use_id
2576: into x_paying_customer_site_use_id
2577: from hz_cust_acct_sites acct_site,
2578: hz_party_sites party_site,
2579: hz_locations loc,
2580: hz_cust_site_uses su,
2581: fnd_territories_vl t