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.JAI_CMN_RPT_BBR_PKG dependencies on AR_CASH_RECEIPT_HISTORY_ALL

Line 34: lv_status_cleared ar_cash_receipt_history_all.status%type ;

30: /* Added by Ramananda for bug#4407165 */
31: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rpt_bbr_pkg.get_credit_balance';
32:
33: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
34: lv_status_cleared ar_cash_receipt_history_all.status%type ;
35: lv_status_remitted ar_cash_receipt_history_all.status%type ;
36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;
37: lv_status_reversed ar_cash_receipt_history_all.status%type ;
38:

Line 35: lv_status_remitted ar_cash_receipt_history_all.status%type ;

31: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rpt_bbr_pkg.get_credit_balance';
32:
33: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
34: lv_status_cleared ar_cash_receipt_history_all.status%type ;
35: lv_status_remitted ar_cash_receipt_history_all.status%type ;
36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;
37: lv_status_reversed ar_cash_receipt_history_all.status%type ;
38:
39: lv_src_payables gl_je_headers.je_source%type ;

Line 36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;

32:
33: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
34: lv_status_cleared ar_cash_receipt_history_all.status%type ;
35: lv_status_remitted ar_cash_receipt_history_all.status%type ;
36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;
37: lv_status_reversed ar_cash_receipt_history_all.status%type ;
38:
39: lv_src_payables gl_je_headers.je_source%type ;
40: lv_src_rcv gl_je_headers.je_source%type ;

Line 37: lv_status_reversed ar_cash_receipt_history_all.status%type ;

33: /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
34: lv_status_cleared ar_cash_receipt_history_all.status%type ;
35: lv_status_remitted ar_cash_receipt_history_all.status%type ;
36: lv_status_confirmed ar_cash_receipt_history_all.status%type ;
37: lv_status_reversed ar_cash_receipt_history_all.status%type ;
38:
39: lv_src_payables gl_je_headers.je_source%type ;
40: lv_src_rcv gl_je_headers.je_source%type ;
41:

Line 60: FROM ar_cash_receipt_history_all acrh,

56:
57:
58: SELECT SUM(DECODE(acrh.status, 'REVERSED',(acrh.amount*NVL(acrh.exchange_rate,1))*-1,
59: NVL(acrh.amount, 0)*NVL(acrh.exchange_rate,1))) INTO amt
60: FROM ar_cash_receipt_history_all acrh,
61: ar_cash_receipts_all acr,
62: hz_cust_accounts rc,
63: ce_bank_accounts ceba
64: WHERE acrh.cash_receipt_id = acr.cash_receipt_id