eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINDTBR_XMLP_PKG dependencies on AR_DISTRIBUTIONS_ALL

Line 18: LV_LOSS_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_LOSS';

14: LV_DEP_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DEP';
15: LV_REC_ACCOUNT_CLASS CONSTANT RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE DEFAULT 'REC';
16: LV_REV_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'REVERSED';
17: LV_ACT_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'ACTIVITY';
18: LV_LOSS_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_LOSS';
19: LV_GAIN_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_GAIN';
20: CURSOR GET_DEBIT_AMOUNT IS
21: SELECT
22: SUM((B.AMOUNT)) SUM_EXT_AMOUNT,

Line 19: LV_GAIN_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_GAIN';

15: LV_REC_ACCOUNT_CLASS CONSTANT RA_CUST_TRX_LINE_GL_DIST_ALL.ACCOUNT_CLASS%TYPE DEFAULT 'REC';
16: LV_REV_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'REVERSED';
17: LV_ACT_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'ACTIVITY';
18: LV_LOSS_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_LOSS';
19: LV_GAIN_SOURCE_TYPE CONSTANT AR_DISTRIBUTIONS_ALL.SOURCE_TYPE%TYPE DEFAULT 'EXCH_GAIN';
20: CURSOR GET_DEBIT_AMOUNT IS
21: SELECT
22: SUM((B.AMOUNT)) SUM_EXT_AMOUNT,
23: SUM((B.AMOUNT) * NVL(A.EXCHANGE_RATE

Line 146: AR_DISTRIBUTIONS_ALL E

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
150: AND B.ORG_ID = NVL(P_ORGANIZATION_ID

Line 164: AR_DISTRIBUTIONS_ALL E

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
168: AND B.ORG_ID = NVL(P_ORGANIZATION_ID

Line 318: lv_loss_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_LOSS'; --rchandan for bug#4428980

314: lv_dep_class constant ar_payment_schedules_all.class%type:= 'DEP'; --rchandan for bug#4428980
315: lv_rec_account_class CONSTANT ra_cust_trx_line_gl_dist_all.account_class%TYPE := 'REC'; --rchandan for bug#4428980
316: lv_rev_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'REVERSED'; --rchandan for bug#4428980
317: lv_act_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'ACTIVITY'; --rchandan for bug#4428980
318: lv_loss_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_LOSS'; --rchandan for bug#4428980
319: lv_gain_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_GAIN' ; --rchandan for bug#4428980
320:
321: Cursor Get_debit_amount IS
322: Select

Line 319: lv_gain_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_GAIN' ; --rchandan for bug#4428980

315: lv_rec_account_class CONSTANT ra_cust_trx_line_gl_dist_all.account_class%TYPE := 'REC'; --rchandan for bug#4428980
316: lv_rev_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'REVERSED'; --rchandan for bug#4428980
317: lv_act_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'ACTIVITY'; --rchandan for bug#4428980
318: lv_loss_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_LOSS'; --rchandan for bug#4428980
319: lv_gain_source_Type CONSTANT ar_distributions_all.source_Type%TYPE := 'EXCH_GAIN' ; --rchandan for bug#4428980
320:
321: Cursor Get_debit_amount IS
322: Select
323: sum((b.amount)) sum_ext_amount,

Line 445: ar_distributions_all e

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
449: AND b.org_id = nvl( p_organization_id,b.org_id)

Line 463: ar_distributions_all e

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