[Home] [Help]
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.
1321: NVL is added for ps.customer_site_use_id in the procedure
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
1350: /* bug no : 1274152. Aging form did not consider the receipts done
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
1381: (SELECT p_filter_id FROM dual
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,
1420: hz_cust_accounts_all cust_acct