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_CASH_RECEIPT_HISTORY_ALL

Line 16: LV_REV_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'REVERSED';

12: LV_DM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'DM';
13: LV_CM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'CM';
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

Line 17: LV_ACT_STATUS CONSTANT AR_CASH_RECEIPT_HISTORY_ALL.STATUS%TYPE DEFAULT 'ACTIVITY';

13: LV_CM_CLASS CONSTANT AR_PAYMENT_SCHEDULES_ALL.CLASS%TYPE DEFAULT 'CM';
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

Line 61: AR_CASH_RECEIPT_HISTORY_ALL

57: AND EXISTS (
58: SELECT
59: 1
60: FROM
61: AR_CASH_RECEIPT_HISTORY_ALL
62: WHERE CASH_RECEIPT_ID = A.CASH_RECEIPT_ID
63: AND ORG_ID = NVL(P_ORGANIZATION_ID
64: ,A.ORG_ID)
65: AND GL_DATE <= TRUNC(P_START_DATE) );

Line 73: AR_CASH_RECEIPT_HISTORY_ALL B

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)
77: AND B.STATUS = LV_REV_STATUS

Line 203: AR_CASH_RECEIPT_HISTORY_ALL B,

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

Line 221: AR_CASH_RECEIPT_HISTORY_ALL

217: AND not exists (
218: SELECT
219: 1
220: FROM
221: AR_CASH_RECEIPT_HISTORY_ALL
222: WHERE CASH_RECEIPT_ID = B.CASH_RECEIPT_ID
223: AND STATUS = LV_REV_STATUS );
224: BEGIN
225: SELECT

Line 316: lv_rev_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'REVERSED'; --rchandan for bug#4428980

312: lv_dm_class constant ar_payment_schedules_all.class%type:= 'DM'; --rchandan for bug#4428980
313: lv_cm_class constant ar_payment_schedules_all.class%type:= 'CM'; --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:

Line 317: lv_act_status CONSTANT ar_cash_receipt_history_all.status%TYPE := 'ACTIVITY'; --rchandan for bug#4428980

313: lv_cm_class constant ar_payment_schedules_all.class%type:= 'CM'; --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

Line 360: FROM ar_cash_receipt_history_all

356: AND a.org_id = NVL( P_ORGANIZATION_ID, a.org_id)
357: AND a.currency_code = P_CURR_CODE
358: --Added the below by Sanjikum for Bug #3962497
359: AND EXISTS ( SELECT 1
360: FROM ar_cash_receipt_history_all
361: WHERE cash_receipt_id = a.cash_receipt_id
362: AND org_id = NVL( P_ORGANIZATION_ID, a.org_id)
363: AND gl_date <= trunc( p_start_date)
364: );

Line 372: ar_cash_receipt_history_all B

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
376: AND b.gl_date <= trunc( p_start_date)

Line 509: ar_cash_receipt_history_all B,

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

Line 525: from ar_cash_receipt_history_all

521: AND b.current_record_flag = 'Y'
522: AND a.org_id=NVL( P_ORGANIZATION_ID, a.org_id)
523: and not exists -- writing this query coz when a receipt is reversed , its write off details should not be shown
524: (select 1
525: from ar_cash_receipt_history_all
526: where cash_receipt_id = b.cash_receipt_id
527: and status = lv_rev_status--rchandan for bug#4428980
528: )
529: ;