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_AGING_BUCKETS_PKG dependencies on AR_CASH_RECEIPTS

Line 1316: FROM ar_cash_receipts cr,

1312: ) IS
1313: CURSOR cust_risk_receipts IS
1314: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1315: crh.amount)), 0)
1316: FROM ar_cash_receipts cr,
1317: ar_cash_receipt_history crh
1318: WHERE cr.pay_from_customer = p_filter_id
1319: /* bug no : 1274152. Aging form did not consider the receipts done
1320: without customer location for the calculation of receipt at risk.

Line 1345: FROM ar_cash_receipts cr,

1341:
1342: CURSOR party_risk_receipts IS
1343: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1344: crh.amount)), 0)
1345: FROM ar_cash_receipts cr,
1346: ar_cash_receipt_history crh,
1347: hz_cust_accounts hzca
1348: WHERE cr.pay_from_customer = hzca.cust_account_id
1349: AND hzca.party_id = p_filter_id

Line 1376: FROM ar_cash_receipts cr,

1372:
1373: CURSOR party_paying_risk_receipts IS
1374: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1375: crh.amount)), 0)
1376: FROM ar_cash_receipts cr,
1377: ar_cash_receipt_history crh,
1378: hz_cust_accounts hzca
1379: WHERE cr.pay_from_customer = hzca.cust_account_id
1380: AND hzca.party_id IN

Line 1415: FROM ar_cash_receipts cr,

1411:
1412: CURSOR cust_site_risk_receipts IS
1413: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1414: crh.amount)), 0)
1415: FROM ar_cash_receipts cr,
1416: ar_cash_receipt_history crh,
1417: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1418: hz_cust_acct_sites_all acct_site,
1419: hz_cust_site_uses_all site_uses,

Line 1417: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */

1413: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1414: crh.amount)), 0)
1415: FROM ar_cash_receipts cr,
1416: ar_cash_receipt_history crh,
1417: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1418: hz_cust_acct_sites_all acct_site,
1419: hz_cust_site_uses_all site_uses,
1420: hz_cust_accounts_all cust_acct
1421: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */

Line 1421: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */

1417: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1418: hz_cust_acct_sites_all acct_site,
1419: hz_cust_site_uses_all site_uses,
1420: hz_cust_accounts_all cust_acct
1421: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1422: WHERE cr.customer_site_use_id = p_filter_id
1423: /* bug no : 1274152. Aging form did not consider the receipts done
1424: without customer location for the calculation of receipt at risk.
1425: NVL is added for ps.customer_site_use_id in the procedure

Line 1442: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */

1438: from ar_receivable_applications rap
1439: where rap.cash_receipt_id = cr.cash_receipt_id
1440: and rap.applied_payment_schedule_id = -2
1441: and rap.display = 'Y')
1442: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1443: and site_uses.site_use_id = p_filter_id
1444: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
1445: and cust_acct.cust_account_id = acct_site.cust_account_id
1446: and cust_acct.party_id = cr.pay_from_customer;

Line 1447: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */

1443: and site_uses.site_use_id = p_filter_id
1444: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
1445: and cust_acct.cust_account_id = acct_site.cust_account_id
1446: and cust_acct.party_id = cr.pay_from_customer;
1447: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1448:
1449:
1450: BEGIN
1451: