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 701: -- AGIS: FUN_TRX_BATCHES

697: l_cash_related_item varchar2(150); --cash related item of a line
698: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
699: l_csi_check varchar2(2); --blank or not of cash related item
700: l_line_check varchar2(16); --result of a line's validation
701: -- AGIS: FUN_TRX_BATCHES
702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;

Line 702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;

698: l_cash_related_item_1 varchar2(150); --copy of cash related item of a line
699: l_csi_check varchar2(2); --blank or not of cash related item
700: l_line_check varchar2(16); --result of a line's validation
701: -- AGIS: FUN_TRX_BATCHES
702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;

Line 703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;

699: l_csi_check varchar2(2); --blank or not of cash related item
700: l_line_check varchar2(16); --result of a line's validation
701: -- AGIS: FUN_TRX_BATCHES
702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;

Line 704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;

700: l_line_check varchar2(16); --result of a line's validation
701: -- AGIS: FUN_TRX_BATCHES
702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;

Line 705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;

701: -- AGIS: FUN_TRX_BATCHES
702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
709: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type

Line 706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;

702: l_trxb_batch_id fun_trx_batches.batch_id%TYPE;
703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
709: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
710: -- AGIS: FUN_TRX_HEADERES

Line 707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;

703: l_trxb_batch_num fun_trx_batches.batch_number%TYPE;
704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
709: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
710: -- AGIS: FUN_TRX_HEADERES
711: l_trxh_header_id fun_trx_headers.trx_id%TYPE;

Line 708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;

704: l_trxb_gl_date fun_trx_batches.gl_date%TYPE;
705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
709: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
710: -- AGIS: FUN_TRX_HEADERES
711: l_trxh_header_id fun_trx_headers.trx_id%TYPE;
712: l_trxh_header_num fun_trx_headers.trx_number%TYPE;

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

705: l_trxb_curr_code fun_trx_batches.currency_code%TYPE;
706: l_trxb_entered_date fun_trx_batches.batch_date%TYPE;
707: l_trxb_from_le_id fun_trx_batches.from_le_id%TYPE;
708: l_trxb_from_ledger_id fun_trx_batches.from_ledger_id%TYPE;
709: l_trxb_curr_cov_type fun_trx_batches.exchange_rate_type%TYPE; --currency convertion type
710: -- AGIS: FUN_TRX_HEADERES
711: l_trxh_header_id fun_trx_headers.trx_id%TYPE;
712: l_trxh_header_num fun_trx_headers.trx_number%TYPE;
713: l_trxh_desc fun_trx_headers.description%TYPE;

Line 884: , FUN_TRX_BATCHES trxb

880: 'ATTRIBUTE12',trxh.attribute12, 'ATTRIBUTE13',trxh.attribute13, 'ATTRIBUTE14',trxh.attribute14,
881: 'ATTRIBUTE15',trxh.attribute15)
882: , '') trxh_cash_related_item*/
883: FROM FUN_TRX_HEADERS trxh
884: , FUN_TRX_BATCHES trxb
885: , FUN_TRX_TYPES_TL trxtype
886: --, JA_CN_DFF_ASSIGNMENTS dff
887: WHERE trxh.batch_id=trxb.batch_id
888: AND trxb.trx_type_id=trxtype.trx_type_id