[Home] [Help]
122: COUNT(DISTINCT invps.payment_schedule_id) cmt_adj_amount,
123: NVL(SUM(DECODE(adj.adjustment_type, 'C', 0, adj.amount)), 0) /
124: COUNT(DISTINCT invps.payment_schedule_id) adj_amount
125: FROM
126: ra_customer_trx inv,
127: ar_payment_schedules invps,
128: ra_cust_trx_types itt,
129: ra_batch_sources cmbs,
130: ra_customer_trx cm,
126: ra_customer_trx inv,
127: ar_payment_schedules invps,
128: ra_cust_trx_types itt,
129: ra_batch_sources cmbs,
130: ra_customer_trx cm,
131: ar_adjustments adj
132: WHERE
133: inv.customer_trx_id = cm.previous_customer_trx_id
134: AND inv.customer_trx_id = p_customer_trx_id
397: inv.invoice_currency_code,
398: inv.exchange_rate,
399: invps.amount_due_remaining inv_balance
400: FROM
401: ra_customer_trx inv,
402: ar_payment_schedules invps
403: WHERE
404: invps.payment_schedule_id = p_payment_schedule_id
405: AND inv.customer_trx_id = invps.customer_trx_id;
761: select party_id
762: into l_party_id
763: from
764: hz_cust_accounts acc,
765: ra_customer_trx trx
766: where trx.bill_to_customer_id = acc.cust_account_id
767: and trx.customer_trx_id = app_info(i).customer_trx_id; /* bug 9909157 */
768:
769: ar_receipt_api_pub.activity_application(
1020: FROM
1021: ar_receivable_applications ra
1022: ,ar_cash_receipts cr
1023: ,ar_receipt_methods rm
1024: ,ra_customer_trx inv
1025: WHERE
1026: ra.applied_customer_trx_id = p_customer_trx_id
1027: AND ra.cash_receipt_id = cr.cash_receipt_id
1028: AND rm.receipt_method_id = cr.receipt_method_id
1303: --
1304: FUNCTION get_total_cm_amount (p_inv_customer_trx_id IN NUMBER,
1305: p_request_id IN NUMBER) RETURN NUMBER AS
1306:
1307: l_total_cm_amount RA_CUSTOMER_TRX_LINES.EXTENDED_AMOUNT%TYPE;
1308:
1309: BEGIN
1310: --
1311: IF PG_DEBUG in ('Y', 'C') THEN
1315: END IF;
1316: --
1317: SELECT NVL(SUM(extended_amount) , 0)
1318: INTO l_total_cm_amount
1319: FROM RA_CUSTOMER_TRX_LINES
1320: WHERE previous_customer_trx_id = p_inv_customer_trx_id
1321: AND request_id = p_request_id;
1322: --
1323: IF PG_DEBUG in ('Y', 'C') THEN
1667: ---
1668: select count(*)
1669: into l_count
1670: from ar_receivable_applications app,
1671: ra_customer_trx oncm
1672: where app.applied_customer_trx_id = p_customer_trx_id
1673: and app.status = 'APP'
1674: and app.application_type = 'CM'
1675: and app.display = 'Y'
1777: ---
1778: select count(*)
1779: into l_count
1780: from ar_activity_details aad,
1781: ra_customer_trx_lines lines
1782: where
1783: lines.customer_trx_id = p_customer_trx_id
1784: and nvl(aad.CURRENT_ACTIVITY_FLAG,'Y') = 'Y'
1785: and aad.customer_trx_line_id = lines.customer_trx_line_id;