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.IEX_DUNNING_PVT dependencies on HZ_CUST_ACCT_SITES

Line 42: HZ_CUST_ACCT_SITES_ALL acct_site,

38: cursor get_data_crs(P_SITE_USE_ID number) is
39: select par_site.location_id
40: from
41: HZ_CUST_SITE_USES_ALL site_use,
42: HZ_CUST_ACCT_SITES_ALL acct_site,
43: hz_party_sites par_site
44: where
45: site_use.site_use_id = P_SITE_USE_ID and
46: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 166: -- from hz_cust_acct_sites_all where cust_acct_site_id =

162: --Start for bug 8771065 gnramasa 6th-Aug-09
163: -- from ast_locations_v where party_site_id =
164: from ast_locations_v where party_site_id in
165: (select party_site_id
166: -- from hz_cust_acct_sites_all where cust_acct_site_id =
167: from hz_cust_acct_sites_all where cust_acct_site_id in
168: (select address_id
169: from ar_contacts_v where contact_party_id = P_CONTACT_ID
170: AND address_id is not null

Line 167: from hz_cust_acct_sites_all where cust_acct_site_id in

163: -- from ast_locations_v where party_site_id =
164: from ast_locations_v where party_site_id in
165: (select party_site_id
166: -- from hz_cust_acct_sites_all where cust_acct_site_id =
167: from hz_cust_acct_sites_all where cust_acct_site_id in
168: (select address_id
169: from ar_contacts_v where contact_party_id = P_CONTACT_ID
170: AND address_id is not null
171: AND status = 'A'));

Line 423: HZ_CUST_ACCT_SITES_ALL acct_site,

419: ) Display_Order
420: ,cont_point.CONTACT_POINT_ID
421: from
422: HZ_CUST_SITE_USES_ALL site_use,
423: HZ_CUST_ACCT_SITES_ALL acct_site,
424: hz_contact_points cont_point
425: where
426: site_use.site_use_id = P_SITE_USE_ID and
427: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 441: HZ_CUST_ACCT_SITES_ALL acct_site,

437: cursor get_data_crs3(P_SITE_USE_ID number) is
438: select par_site.location_id
439: from
440: HZ_CUST_SITE_USES_ALL site_use,
441: HZ_CUST_ACCT_SITES_ALL acct_site,
442: hz_party_sites par_site
443: where
444: site_use.site_use_id = P_SITE_USE_ID and
445: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 744: HZ_CUST_ACCT_SITES_ALL acct_site,

740: site_use.site_use_code,
741: par_site.location_id
742: from
743: hz_party_sites par_site,
744: HZ_CUST_ACCT_SITES_ALL acct_site,
745: HZ_CUST_SITE_USES_ALL site_use
746: where
747: acct_site.cust_account_id = P_CUST_ACCOUNT_ID and
748: acct_site.status = 'A' and

Line 760: HZ_CUST_ACCT_SITES_ALL acct_site,

756: cursor get_data_crs3(P_CUST_ACCOUNT_ID number) is
757: select count(1)
758: from
759: hz_party_sites par_site,
760: HZ_CUST_ACCT_SITES_ALL acct_site,
761: HZ_CUST_SITE_USES_ALL site_use
762: where
763: acct_site.cust_account_id = P_CUST_ACCOUNT_ID and
764: acct_site.status = 'A' and

Line 1127: HZ_CUST_ACCT_SITES_ALL acct_site,

1123: site_use.site_use_code,
1124: par_site.identifying_address_flag,
1125: site_use.primary_flag
1126: from HZ_CUST_SITE_USES_ALL site_use,
1127: HZ_CUST_ACCT_SITES_ALL acct_site,
1128: hz_party_sites par_site
1129: where par_site.party_id = P_PARTY_ID and
1130: par_site.status in ('A', 'I') and
1131: par_site.party_site_id = acct_site.party_site_id and

Line 1144: HZ_CUST_ACCT_SITES_ALL acct_site,

1140: P_IDENT_FLAG varchar2,
1141: P_PRIMARY_FLAG varchar2) is
1142: select count(1)
1143: from HZ_CUST_SITE_USES_ALL site_use,
1144: HZ_CUST_ACCT_SITES_ALL acct_site,
1145: hz_party_sites par_site
1146: where par_site.party_id = P_PARTY_ID and
1147: par_site.status in ('A', 'I') and
1148: par_site.party_site_id = acct_site.party_site_id and

Line 1294: hz_cust_acct_sites_all acc_site,

1290:
1291: cursor c_get_party_from_site(p_site_use_id number) is
1292: select cust.party_id
1293: from hz_cust_accounts cust,
1294: hz_cust_acct_sites_all acc_site,
1295: hz_cust_site_uses_all site_use
1296: where site_use.site_use_id = p_site_use_id and
1297: site_use.cust_acct_site_id = acc_site.cust_acct_site_id and
1298: acc_site.cust_account_id = cust.cust_account_id;

Line 1521: hz_cust_acct_sites_all acc_site,

1517:
1518: cursor c_get_site_info(p_site_use_id number) is
1519: select cust.party_id, cust.cust_account_id
1520: from hz_cust_accounts cust,
1521: hz_cust_acct_sites_all acc_site,
1522: hz_cust_site_uses_all site_use
1523: where site_use.site_use_id = p_site_use_id and
1524: site_use.cust_acct_site_id = acc_site.cust_acct_site_id and
1525: acc_site.cust_account_id = cust.cust_account_id;

Line 17943: 'hz_cust_acct_sites_all acct_sites, ' ||

17939: --' ''http://techcm.us.oracle.com:8000/OA_HTML/IEXDUNCPRRedirect.jsp?RequestId='' || ixr.xml_request_id DOWNLOAD_URL ' ||
17940: 'from iex_xml_request_histories ixr, ' ||
17941: 'hz_parties p, ' ||
17942: 'hz_cust_accounts hcu,' ||
17943: 'hz_cust_acct_sites_all acct_sites, ' ||
17944: 'hz_cust_site_uses_all site_uses, ' ||
17945: 'iex_dunnings id, ' ||
17946: 'XDO_TEMPLATES_B xtb, ' ||
17947: 'XDO_TEMPLATES_TL xtvl ' ||

Line 18239: hz_cust_acct_sites acct_sites,

18235: If l_object_type = 'IEX_BILLTO' then
18236: l_source_id := l_object_id;
18237: SELECT ca.party_id into l_party_id
18238: FROM hz_cust_site_uses site_uses,
18239: hz_cust_acct_sites acct_sites,
18240: hz_cust_accounts ca
18241: WHERE site_uses.site_use_id = l_object_id
18242: AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id
18243: AND ca.cust_account_id = acct_sites.cust_account_id;