APPS.JA_JAINDTBR_XMLP_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 26: RA_CUSTOMER_TRX_ALL A,

22: SUM((B.AMOUNT)) SUM_EXT_AMOUNT,
23: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
24: ,1))
25: FROM
26: RA_CUSTOMER_TRX_ALL A,
27: AR_PAYMENT_SCHEDULES_ALL C,
28: RA_CUST_TRX_LINE_GL_DIST_ALL B
29: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
30: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID

Line 91: RA_CUSTOMER_TRX_ALL B,

87: NVL(SUM(ABS(NVL(D.ACCTD_EARNED_DISCOUNT_TAKEN
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)

Line 125: RA_CUSTOMER_TRX_ALL C,

121: SUM(B.AMOUNT * NVL(C.EXCHANGE_RATE
122: ,1.00)) SUM_AMOUNT_EXCHANGE
123: FROM
124: AR_ADJUSTMENTS_ALL B,
125: RA_CUSTOMER_TRX_ALL C,
126: AR_PAYMENT_SCHEDULES_ALL D,
127: GL_CODE_COMBINATIONS E
128: WHERE B.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID
129: AND C.BILL_TO_CUSTOMER_ID = CUSTOMER_ID

Line 143: RA_CUSTOMER_TRX_ALL B,

139: SELECT
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

Line 161: RA_CUSTOMER_TRX_ALL B,

157: SELECT
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

Line 231: RA_CUSTOMER_TRX_ALL A,

227: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE
228: ,1))
229: INTO V_CRE_MEMO_AMT,V_CRE_MEMO_FUNC_AMT
230: FROM
231: RA_CUSTOMER_TRX_ALL A,
232: AR_PAYMENT_SCHEDULES_ALL C,
233: RA_CUST_TRX_LINE_GL_DIST_ALL B
234: WHERE A.BILL_TO_CUSTOMER_ID = CUSTOMER_ID
235: AND A.CUSTOMER_TRX_ID = C.CUSTOMER_TRX_ID

Line 326: ra_customer_trx_all A,

322: Select
323: sum((b.amount)) sum_ext_amount,
324: sum((b.amount) * NVL(a.exchange_rate,1))
325: From
326: ra_customer_trx_all A,
327: ar_payment_schedules_all C,
328: ra_cust_trx_line_gl_dist_all B
329: Where
330: a.bill_to_customer_id = P_CUSTOMER_ID

Line 389: From ra_customer_trx_ALL B,

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,
390: ar_receivable_applications_all d
391: Where
392: b.bill_to_customer_id = P_CUSTOMER_ID
393: AND b.complete_flag = 'Y'

Line 421: ra_customer_trx_all c,

417: cursor c_get_nonfc_adj_amount is
418: select sum(b.amount),
419: sum(b.amount * NVL(c.exchange_rate,1.00)) sum_amount_exchange
420: FROM ar_adjustments_all b,
421: ra_customer_trx_all c,
422: ar_payment_schedules_all d,
423: gl_code_combinations e
424: WHERE
425: b.customer_trx_id = c.customer_trx_id

Line 442: FROM ra_customer_trx_all b ,

438: Cursor get_exchange_gainloss_cr is
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

Line 460: FROM ra_customer_trx_all b ,

456: Cursor get_exchange_gainloss_dr is
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

Line 539: ra_customer_trx_all A,

535: sum((b.amount) * NVL(a.exchange_rate,1))
536: Into v_cre_memo_amt,
537: v_cre_memo_func_amt
538: From
539: ra_customer_trx_all A,
540: ar_payment_schedules_all C,
541: ra_cust_trx_line_gl_dist_all B
542: Where
543: a.bill_to_customer_id = P_CUSTOMER_ID