APPS.JA_JAINDTBR_XMLP_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 82: CURSOR GET_DISCOUNT_CUR(CP_APP_TYPE IN AR_RECEIVABLE_APPLICATIONS_ALL.APPLICATION_TYPE%TYPE) IS

78: AND A.REVERSAL_DATE is not null
79: AND A.ORG_ID = NVL(P_ORGANIZATION_ID
80: ,A.ORG_ID)
81: AND A.CURRENCY_CODE = CURR_CODE;
82: CURSOR GET_DISCOUNT_CUR(CP_APP_TYPE IN AR_RECEIVABLE_APPLICATIONS_ALL.APPLICATION_TYPE%TYPE) IS
83: SELECT
84: NVL(SUM(ABS(NVL(D.EARNED_DISCOUNT_TAKEN
85: ,0)))
86: ,0) SUM_AMOUNT,

Line 92: AR_RECEIVABLE_APPLICATIONS_ALL D

88: ,0)))
89: ,0) SUM_AMOUNT_EXCHANGE
90: FROM
91: RA_CUSTOMER_TRX_ALL B,
92: AR_RECEIVABLE_APPLICATIONS_ALL D
93: WHERE B.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
94: AND B.COMPLETE_FLAG = 'Y'
95: AND TRUNC(D.GL_DATE) <= TRUNC(P_START_DATE)
96: AND D.APPLIED_CUSTOMER_TRX_ID = B.CUSTOMER_TRX_ID

Line 145: AR_RECEIVABLE_APPLICATIONS_ALL D,

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
149: AND E.SOURCE_ID = D.RECEIVABLE_APPLICATION_ID

Line 163: AR_RECEIVABLE_APPLICATIONS_ALL D,

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
167: AND E.SOURCE_ID = D.RECEIVABLE_APPLICATION_ID

Line 204: AR_RECEIVABLE_APPLICATIONS_ALL C

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)
207: AND A.CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
208: AND A.CASH_RECEIPT_ID = C.CASH_RECEIPT_ID

Line 385: CURSOR Get_Discount_Cur(cp_app_type ar_receivable_applications_all.application_type%type) is--rchandan for bug#4428980

381: AND a.currency_code = P_CURR_CODE;
382:
383:
384:
385: CURSOR Get_Discount_Cur(cp_app_type ar_receivable_applications_all.application_type%type) is--rchandan for bug#4428980
386: Select
387: nvl(sum(abs(NVL(d.earned_discount_taken,0))),0) sum_amount,
388: nvl(sum(abs(NVL(d.ACCTD_EARNED_DISCOUNT_TAKEN,0))),0) sum_amount_exchange
389: From ra_customer_trx_ALL B,

Line 390: ar_receivable_applications_all d

386: Select
387: nvl(sum(abs(NVL(d.earned_discount_taken,0))),0) sum_amount,
388: nvl(sum(abs(NVL(d.ACCTD_EARNED_DISCOUNT_TAKEN,0))),0) sum_amount_exchange
389: From ra_customer_trx_ALL B,
390: ar_receivable_applications_all d
391: Where
392: b.bill_to_customer_id = P_CUSTOMER_ID
393: AND b.complete_flag = 'Y'
394: AND trunc(d.GL_DATE) <= trunc( p_start_date)

Line 444: ar_receivable_applications_all d,

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
448: AND e.SOURCE_ID = d.receivable_application_id

Line 462: ar_receivable_applications_all d ,

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
466: AND c.cash_receipt_id = d.cash_receipt_id

Line 510: ar_receivable_applications_all c

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
513: AND trunc(b.gl_date) <= trunc( p_start_date)
514: AND a.cash_receipt_id = b.cash_receipt_id