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 1336: FROM ar_cash_receipts cr,

1332: ) IS
1333: CURSOR cust_risk_receipts IS
1334: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1335: crh.amount)), 0)
1336: FROM ar_cash_receipts cr,
1337: ar_cash_receipt_history crh
1338: WHERE cr.pay_from_customer = p_filter_id
1339: /* bug no : 1274152. Aging form did not consider the receipts done
1340: without customer location for the calculation of receipt at risk.

Line 1365: FROM ar_cash_receipts cr,

1361:
1362: CURSOR party_risk_receipts IS
1363: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1364: crh.amount)), 0)
1365: FROM ar_cash_receipts cr,
1366: ar_cash_receipt_history crh,
1367: hz_cust_accounts hzca
1368: WHERE cr.pay_from_customer = hzca.cust_account_id
1369: AND hzca.party_id = p_filter_id

Line 1396: FROM ar_cash_receipts cr,

1392:
1393: CURSOR party_paying_risk_receipts IS
1394: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1395: crh.amount)), 0)
1396: FROM ar_cash_receipts cr,
1397: ar_cash_receipt_history crh,
1398: hz_cust_accounts hzca
1399: WHERE cr.pay_from_customer = hzca.cust_account_id
1400: AND hzca.party_id IN

Line 1435: FROM ar_cash_receipts cr,

1431:
1432: CURSOR cust_site_risk_receipts IS
1433: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1434: crh.amount)), 0)
1435: FROM ar_cash_receipts cr,
1436: ar_cash_receipt_history crh,
1437: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1438: hz_cust_acct_sites_all acct_site,
1439: hz_cust_site_uses_all site_uses,

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

1433: SELECT NVL( SUM( DECODE(p_currency_code, NULL, crh.acctd_amount,
1434: crh.amount)), 0)
1435: FROM ar_cash_receipts cr,
1436: ar_cash_receipt_history crh,
1437: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1438: hz_cust_acct_sites_all acct_site,
1439: hz_cust_site_uses_all site_uses,
1440: hz_cust_accounts_all cust_acct
1441: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */

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

1437: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1438: hz_cust_acct_sites_all acct_site,
1439: hz_cust_site_uses_all site_uses,
1440: hz_cust_accounts_all cust_acct
1441: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1442: WHERE cr.customer_site_use_id = p_filter_id
1443: /* bug no : 1274152. Aging form did not consider the receipts done
1444: without customer location for the calculation of receipt at risk.
1445: NVL is added for ps.customer_site_use_id in the procedure

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

1458: from ar_receivable_applications rap
1459: where rap.cash_receipt_id = cr.cash_receipt_id
1460: and rap.applied_payment_schedule_id = -2
1461: and rap.display = 'Y')
1462: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1463: and site_uses.site_use_id = p_filter_id
1464: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
1465: and cust_acct.cust_account_id = acct_site.cust_account_id
1466: and cust_acct.party_id = cr.pay_from_customer;

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

1463: and site_uses.site_use_id = p_filter_id
1464: AND acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
1465: and cust_acct.cust_account_id = acct_site.cust_account_id
1466: and cust_acct.party_id = cr.pay_from_customer;
1467: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1468:
1469:
1470: BEGIN
1471: