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_SITE_USES_ALL

Line 41: HZ_CUST_SITE_USES_ALL site_use,

37: +-----------------------------------------------------------------------*/
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

Line 370: HZ_CUST_SITE_USES_ALL site_use,

366: role_resp.responsibility_type,
367: party.party_id,
368: sub_party.party_id
369: from
370: HZ_CUST_SITE_USES_ALL site_use,
371: HZ_CUST_ACCOUNT_ROLES acct_role,
372: HZ_ROLE_RESPONSIBILITY role_resp,
373: HZ_RELATIONSHIPS rel,
374: hz_parties party,

Line 422: HZ_CUST_SITE_USES_ALL site_use,

418: null, decode(cont_point.primary_flag, 'Y', 10, decode(cont_point.primary_by_purpose, 'Y', 11, 12))
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

Line 440: HZ_CUST_SITE_USES_ALL site_use,

436: -- get LOCATION_ID for specified site_use_id
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

Line 745: HZ_CUST_SITE_USES_ALL site_use

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
749: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 761: HZ_CUST_SITE_USES_ALL site_use

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
765: acct_site.cust_acct_site_id = site_use.cust_acct_site_id and

Line 1126: from HZ_CUST_SITE_USES_ALL site_use,

1122: acct_site.cust_account_id,
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

Line 1143: from HZ_CUST_SITE_USES_ALL site_use,

1139: P_SITE_USE_CODE varchar2,
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

Line 1295: hz_cust_site_uses_all site_use

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

Line 1522: hz_cust_site_uses_all site_use

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

Line 2786: select site_use_code into t_code from hz_cust_site_uses_all where site_use_id = l_object_id;

2782:
2783: -- begin Bills Receivables
2784: begin
2785: t_id := l_object_id;
2786: select site_use_code into t_code from hz_cust_site_uses_all where site_use_id = l_object_id;
2787: if t_code = 'BILL_TO' then
2788: t_id := iex_utilities.get_BR_DrweeSiteID(l_object_id);
2789: end if;
2790: exception

Line 5555: select site_use_code into t_code from hz_cust_site_uses_all where site_use_id = l_object_id;

5551:
5552: -- begin Bills Receivables
5553: begin
5554: t_id := l_object_id;
5555: select site_use_code into t_code from hz_cust_site_uses_all where site_use_id = l_object_id;
5556: if t_code = 'BILL_TO' then
5557: t_id := iex_utilities.get_BR_DrweeSiteID(l_object_id);
5558: end if;
5559: exception

Line 17944: 'hz_cust_site_uses_all site_uses, ' ||

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 ' ||
17948: 'where id.dunning_object_id = site_uses.site_use_id ' ||