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_ACCOUNTS

Line 728: select party_id from hz_cust_accounts where cust_account_id = P_CUST_ACCOUNT_ID;

724: order by Display_Order;
725:
726: -- get party_id from cust_account_id
727: cursor get_party_crs(P_CUST_ACCOUNT_ID number) is
728: select party_id from hz_cust_accounts where cust_account_id = P_CUST_ACCOUNT_ID;
729:
730: -- get LOCATION_ID for specified cust_account_id
731: cursor get_data_crs2(P_CUST_ACCOUNT_ID number) is
732: select

Line 1288: from hz_cust_accounts

1284: l_party_id number;
1285:
1286: cursor c_get_party_from_acc(p_cust_account_id number) is
1287: select party_id
1288: from hz_cust_accounts
1289: where cust_account_id = p_cust_account_id;
1290:
1291: cursor c_get_party_from_site(p_site_use_id number) is
1292: select cust.party_id

Line 1293: from hz_cust_accounts cust,

1289: where cust_account_id = p_cust_account_id;
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

Line 1517: from hz_cust_accounts

1513: where delinquency_id = p_delinquency_id;
1514:
1515: cursor c_get_acct_info(p_cust_account_id number) is
1516: select party_id
1517: from hz_cust_accounts
1518: where cust_account_id = p_cust_account_id;
1519:
1520: cursor c_get_site_info(p_site_use_id number) is
1521: select cust.party_id, cust.cust_account_id

Line 1522: from hz_cust_accounts cust,

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

Line 9012: HZ_CUST_ACCOUNTS a,

9008: ar.payment_schedule_id,
9009: h.party_name
9010: FROM IEX_DELINQUENCIES d,
9011: HZ_PARTIES h,
9012: HZ_CUST_ACCOUNTS a,
9013: AR_PAYMENT_SCHEDULES ar
9014: WHERE d.delinquency_ID = in_del_ID
9015: AND h.party_id = d.party_cust_id
9016: AND d.cust_account_id = a.cust_account_id

Line 9028: HZ_CUST_ACCOUNTS a

9024: d.customer_site_use_id,
9025: h.party_name
9026: FROM IEX_DELINQUENCIES d,
9027: HZ_PARTIES h,
9028: HZ_CUST_ACCOUNTS a
9029: WHERE d.customer_site_use_id = in_SITE_ID
9030: AND h.party_id = d.party_cust_id
9031: AND d.cust_account_id = a.cust_account_id;
9032: --

Line 9040: HZ_CUST_ACCOUNTS a

9036: a.account_number,
9037: h.party_name
9038: FROM IEX_DELINQUENCIES d,
9039: HZ_PARTIES h,
9040: HZ_CUST_ACCOUNTS a
9041: WHERE d.cust_account_ID = in_ACCT_ID
9042: AND h.party_id = d.party_cust_id
9043: AND d.cust_account_id = a.cust_account_id;
9044: --