[Home] [Help]
48: SUM(A.AMOUNT) SUM_AMOUNT,
49: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
50: ,1.00)) SUM_AMOUNT_EXCHANGE
51: FROM
52: AR_CASH_RECEIPTS_ALL A
53: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
54: AND A.ORG_ID = NVL(P_ORGANIZATION_ID
55: ,A.ORG_ID)
56: AND A.CURRENCY_CODE = CURR_CODE
68: SUM(A.AMOUNT) SUM_AMOUNT,
69: SUM(A.AMOUNT * NVL(A.EXCHANGE_RATE
70: ,1.00)) SUM_AMOUNT_EXCHANGE
71: FROM
72: AR_CASH_RECEIPTS_ALL A,
73: AR_CASH_RECEIPT_HISTORY_ALL B
74: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
75: AND A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
76: AND B.GL_DATE <= TRUNC(P_START_DATE)
107: SUM(A.AMOUNT * NVL(B.EXCHANGE_RATE
108: ,1.00)) SUM_AMOUNT_EXCHANGE
109: FROM
110: AR_ADJUSTMENTS_ALL A,
111: AR_CASH_RECEIPTS_ALL B
112: WHERE A.ASSOCIATED_CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
113: AND B.PAY_FROM_CUSTOMER = CUSTOMER_ID
114: AND A.GL_DATE <= TRUNC(P_START_DATE)
115: AND B.ORG_ID = NVL(P_ORGANIZATION_ID
140: SUM(E.AMOUNT_CR) SUM_AMOUNT,
141: SUM(E.ACCTD_AMOUNT_CR) SUM_EXCHANGE_AMOUNT
142: FROM
143: RA_CUSTOMER_TRX_ALL B,
144: AR_CASH_RECEIPTS_ALL C,
145: AR_RECEIVABLE_APPLICATIONS_ALL D,
146: AR_DISTRIBUTIONS_ALL E
147: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
148: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID
158: SUM(E.AMOUNT_DR) SUM_AMOUNT,
159: SUM(E.ACCTD_AMOUNT_DR) SUM_EXCHANGE_AMOUNT
160: FROM
161: RA_CUSTOMER_TRX_ALL B,
162: AR_CASH_RECEIPTS_ALL C,
163: AR_RECEIVABLE_APPLICATIONS_ALL D,
164: AR_DISTRIBUTIONS_ALL E
165: WHERE B.CUSTOMER_TRX_ID = D.APPLIED_CUSTOMER_TRX_ID
166: AND C.CASH_RECEIPT_ID = D.CASH_RECEIPT_ID
198: SUM(C.AMOUNT_APPLIED) SUM_AMOUNT,
199: SUM(C.AMOUNT_APPLIED * NVL(A.EXCHANGE_RATE
200: ,1.00)) SUM_AMOUNT_EXCHANGE
201: FROM
202: AR_CASH_RECEIPTS_ALL A,
203: AR_CASH_RECEIPT_HISTORY_ALL B,
204: AR_RECEIVABLE_APPLICATIONS_ALL C
205: WHERE A.PAY_FROM_CUSTOMER = CUSTOMER_ID
206: AND TRUNC(B.GL_DATE) <= TRUNC(P_START_DATE)
349: Select
350: sum(a.amount) sum_amount,
351: sum(a.amount * NVL(a.exchange_rate,1.00)) sum_amount_exchange
352: From
353: ar_cash_receipts_all A
354: Where
355: a.pay_from_customer = P_CUSTOMER_ID
356: AND a.org_id = NVL( P_ORGANIZATION_ID, a.org_id)
357: AND a.currency_code = P_CURR_CODE
367: Select
368: sum(a.amount) sum_amount,
369: sum(a.amount * NVL(a.exchange_rate,1.00)) sum_amount_exchange
370: From
371: ar_cash_receipts_all A ,
372: ar_cash_receipt_history_all B
373: Where
374: a.pay_from_customer = P_CUSTOMER_ID
375: and a.cash_receipt_id = b.cash_receipt_id
404: Cursor get_adjustment_amount IS
405: SELECT SUM(A.amount),
406: SUM(A.amount * NVL(b.exchange_rate,1.00)) sum_amount_exchange
407: FROM ar_adjustments_all A,
408: ar_cash_receipts_all b
409: WHERE A.associated_cash_receipt_id = b.cash_receipt_id
410: and b.pay_from_customer = P_CUSTOMER_ID
411: --and trunc(a.apply_date) <= trunc( p_start_date)
412: and A.gl_date <= trunc( p_start_date)
439: SELECT
440: sum(e.amount_cr) sum_amount ,
441: sum(e.acctd_amount_cr) sum_exchange_amount
442: FROM ra_customer_trx_all b ,
443: ar_cash_receipts_all c,
444: ar_receivable_applications_all d,
445: ar_distributions_all e
446: WHERE b.customer_trx_id = d.APPLIED_CUSTOMER_TRX_ID
447: AND c.cash_receipt_id = d.cash_receipt_id
457: SELECT
458: sum(e.amount_dr) sum_amount ,
459: sum(e.acctd_amount_dr) sum_exchange_amount
460: FROM ra_customer_trx_all b ,
461: ar_cash_receipts_all c ,
462: ar_receivable_applications_all d ,
463: ar_distributions_all e
464: WHERE
465: b.customer_trx_id = d.APPLIED_CUSTOMER_TRX_ID
504: Select
505: sum(c.amount_applied) sum_amount,
506: sum(c.amount_applied * NVL(a.exchange_rate,1.00)) sum_amount_exchange
507: From
508: ar_cash_receipts_all A,
509: ar_cash_receipt_history_all B,
510: ar_receivable_applications_all c
511: Where
512: a.pay_from_customer = P_CUSTOMER_ID