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_CN_CFS_DATA_CLT_PKG dependencies on FUN_TRX_BATCHES

Line 683: -- AGIS: FUN_TRX_BATCHES

679: l_cash_related_item varchar2(150); --cash related item of a line
680: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
681: l_csi_check varchar2(2); --blank or not of cash related item
682: l_line_check varchar2(16); --result of a line's validation
683: -- AGIS: FUN_TRX_BATCHES
684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;

Line 684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;

680: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
681: l_csi_check varchar2(2); --blank or not of cash related item
682: l_line_check varchar2(16); --result of a line's validation
683: -- AGIS: FUN_TRX_BATCHES
684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;

Line 685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;

681: l_csi_check varchar2(2); --blank or not of cash related item
682: l_line_check varchar2(16); --result of a line's validation
683: -- AGIS: FUN_TRX_BATCHES
684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;

Line 686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;

682: l_line_check varchar2(16); --result of a line's validation
683: -- AGIS: FUN_TRX_BATCHES
684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;

Line 687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;

683: -- AGIS: FUN_TRX_BATCHES
684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
691: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type

Line 688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;

684: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
691: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
692: -- AGIS: FUN_TRX_HEADERES

Line 689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;

685: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
691: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
692: -- AGIS: FUN_TRX_HEADERES
693: l_trxh_header_id fun_trx_headers.trx_id%TYPE;

Line 690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;

686: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
691: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
692: -- AGIS: FUN_TRX_HEADERES
693: l_trxh_header_id fun_trx_headers.trx_id%TYPE;
694: l_trxh_header_num fun_trx_headers.trx_number%TYPE;

Line 691: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type

687: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
688: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
689: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
690: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
691: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
692: -- AGIS: FUN_TRX_HEADERES
693: l_trxh_header_id fun_trx_headers.trx_id%TYPE;
694: l_trxh_header_num fun_trx_headers.trx_number%TYPE;
695: l_trxh_desc fun_trx_headers.description%TYPE;

Line 864: , FUN_TRX_BATCHES trxb

860: 'ATTRIBUTE12',trxh.attribute12, 'ATTRIBUTE13',trxh.attribute13, 'ATTRIBUTE14',trxh.attribute14,
861: 'ATTRIBUTE15',trxh.attribute15)
862: , '') trxh_cash_related_item*/
863: FROM FUN_TRX_HEADERS trxh
864: , FUN_TRX_BATCHES trxb
865: , FUN_TRX_TYPES_TL trxtype
866: --, JA_CN_DFF_ASSIGNMENTS dff
867: WHERE trxh.batch_id=trxb.batch_id
868: AND trxb.trx_type_id=trxtype.trx_type_id