[Home] [Help]
119: COUNT(DISTINCT invps.payment_schedule_id) cmt_adj_amount,
120: NVL(SUM(DECODE(adj.adjustment_type, 'C', 0, adj.amount)), 0) /
121: COUNT(DISTINCT invps.payment_schedule_id) adj_amount
122: FROM
123: ra_customer_trx inv,
124: ar_payment_schedules invps,
125: ra_cust_trx_types itt,
126: ra_batch_sources cmbs,
127: ra_customer_trx cm,
123: ra_customer_trx inv,
124: ar_payment_schedules invps,
125: ra_cust_trx_types itt,
126: ra_batch_sources cmbs,
127: ra_customer_trx cm,
128: ar_adjustments adj
129: WHERE
130: inv.customer_trx_id = cm.previous_customer_trx_id
131: AND inv.customer_trx_id = p_customer_trx_id
394: inv.invoice_currency_code,
395: inv.exchange_rate,
396: invps.amount_due_remaining inv_balance
397: FROM
398: ra_customer_trx inv,
399: ar_payment_schedules invps
400: WHERE
401: invps.payment_schedule_id = p_payment_schedule_id
402: AND inv.customer_trx_id = invps.customer_trx_id;
757: select party_id
758: into l_party_id
759: from
760: hz_cust_accounts acc,
761: ra_customer_trx trx
762: where trx.bill_to_customer_id = acc.cust_account_id
763: and trx.trx_number = app_info(i).trx_number;
764:
765: ar_receipt_api_pub.activity_application(
1006: FROM
1007: ar_receivable_applications ra
1008: ,ar_cash_receipts cr
1009: ,ar_receipt_methods rm
1010: ,ra_customer_trx inv
1011: WHERE
1012: ra.applied_customer_trx_id = p_customer_trx_id
1013: AND ra.cash_receipt_id = cr.cash_receipt_id
1014: AND rm.receipt_method_id = cr.receipt_method_id
1275: --
1276: FUNCTION get_total_cm_amount (p_inv_customer_trx_id IN NUMBER,
1277: p_request_id IN NUMBER) RETURN NUMBER AS
1278:
1279: l_total_cm_amount RA_CUSTOMER_TRX_LINES.EXTENDED_AMOUNT%TYPE;
1280:
1281: BEGIN
1282: --
1283: IF PG_DEBUG in ('Y', 'C') THEN
1287: END IF;
1288: --
1289: SELECT NVL(SUM(extended_amount) , 0)
1290: INTO l_total_cm_amount
1291: FROM RA_CUSTOMER_TRX_LINES
1292: WHERE previous_customer_trx_id = p_inv_customer_trx_id
1293: AND request_id = p_request_id;
1294: --
1295: IF PG_DEBUG in ('Y', 'C') THEN
1639: ---
1640: select count(*)
1641: into l_count
1642: from ar_receivable_applications app,
1643: ra_customer_trx oncm
1644: where app.applied_customer_trx_id = p_customer_trx_id
1645: and app.status = 'APP'
1646: and app.application_type = 'CM'
1647: and app.display = 'Y'
1749: ---
1750: select count(*)
1751: into l_count
1752: from ar_activity_details aad,
1753: ra_customer_trx_lines lines
1754: where
1755: lines.customer_trx_id = p_customer_trx_id
1756: and nvl(aad.CURRENT_ACTIVITY_FLAG,'Y') = 'Y'
1757: and aad.customer_trx_line_id = lines.customer_trx_line_id;