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_HEADERS

Line 319: , fun_trx_headers trxh

315: 'ATTRIBUTE15',jel.attribute15)
316: ) cash_related_item
317: INTO l_tr_csi_check
318: FROM gl_je_lines jel
319: , fun_trx_headers trxh
320: , fun_trx_lines trxl
321: , fun_dist_lines distl
322: ,ja_cn_dff_assignments dffa --
323: WHERE distl.dist_id = l_jt_id -- transaction header id

Line 693: l_trxh_header_id fun_trx_headers.trx_id%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;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;

Line 694: l_trxh_header_num fun_trx_headers.trx_number%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;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;

Line 695: l_trxh_desc fun_trx_headers.description%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;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;

Line 696: l_trxh_initiator_id fun_trx_headers.initiator_id%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;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;

Line 697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;

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;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;

Line 698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;

694: l_trxh_header_num fun_trx_headers.trx_number%TYPE;
695: l_trxh_desc fun_trx_headers.description%TYPE;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;

Line 699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;

695: l_trxh_desc fun_trx_headers.description%TYPE;
696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
703: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;

Line 700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;

696: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
703: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
704: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;

Line 701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;

697: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
703: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
704: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;
705: l_distl_cash_rel_item_l fun_dist_lines.attribute1%TYPE;

Line 702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;

698: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
703: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
704: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;
705: l_distl_cash_rel_item_l fun_dist_lines.attribute1%TYPE;
706: -- AGIS: FUN_TRX_LINES

Line 703: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;

699: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
700: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
701: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
702: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
703: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
704: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;
705: l_distl_cash_rel_item_l fun_dist_lines.attribute1%TYPE;
706: -- AGIS: FUN_TRX_LINES
707: l_trxl_num fun_trx_lines.line_id%TYPE;

Line 724: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;

720: -- AGIS: CURRENCY RATE
721: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;
722:
723: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
724: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
725: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
726: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
727: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
728: l_get_trx_cov_rate_flg BOOLEAN := FALSE;

Line 725: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;

721: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;
722:
723: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
724: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
725: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
726: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
727: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
728: l_get_trx_cov_rate_flg BOOLEAN := FALSE;
729: l_tr_func_amount number:=0;

Line 726: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;

722:
723: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
724: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
725: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
726: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
727: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
728: l_get_trx_cov_rate_flg BOOLEAN := FALSE;
729: l_tr_func_amount number:=0;
730:

Line 727: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;

723: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
724: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
725: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
726: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
727: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
728: l_get_trx_cov_rate_flg BOOLEAN := FALSE;
729: l_tr_func_amount number:=0;
730:
731: --cursor

Line 863: FROM FUN_TRX_HEADERS trxh

859: 'ATTRIBUTE9',trxh.attribute9, 'ATTRIBUTE10',trxh.attribute10, 'ATTRIBUTE11',trxh.attribute11,
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