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 330: , fun_trx_headers trxh

326: ) cash_related_item*/
327: jel.GLOBAL_ATTRIBUTE6 cash_related_item
328: INTO l_tr_csi_check
329: FROM gl_je_lines jel
330: , fun_trx_headers trxh
331: , fun_trx_lines trxl
332: , fun_dist_lines distl
333: -- ,ja_cn_dff_assignments dffa --
334: WHERE distl.dist_id = l_jt_id -- transaction header id

Line 711: l_trxh_header_id fun_trx_headers.trx_id%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;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;

Line 712: l_trxh_header_num fun_trx_headers.trx_number%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;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;

Line 713: l_trxh_desc fun_trx_headers.description%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;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;

Line 714: l_trxh_initiator_id fun_trx_headers.initiator_id%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;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;

Line 715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;

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;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;

Line 716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;

712: l_trxh_header_num fun_trx_headers.trx_number%TYPE;
713: l_trxh_desc fun_trx_headers.description%TYPE;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;

Line 717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;

713: l_trxh_desc fun_trx_headers.description%TYPE;
714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
721: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;

Line 718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;

714: l_trxh_initiator_id fun_trx_headers.initiator_id%TYPE;
715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
721: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
722: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;

Line 719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;

715: l_trxh_recipient_id fun_trx_headers.recipient_id%TYPE;
716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
721: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
722: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;
723: l_distl_cash_rel_item_l fun_dist_lines.attribute1%TYPE;

Line 720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;

716: l_trxh_to_le_id fun_trx_headers.to_le_id%TYPE;
717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
721: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
722: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;
723: l_distl_cash_rel_item_l fun_dist_lines.attribute1%TYPE;
724: -- AGIS: FUN_TRX_LINES

Line 721: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;

717: l_trxh_to_ledger_id fun_trx_headers.to_ledger_id%TYPE;
718: l_trxh_init_amount_cr fun_trx_headers.init_amount_cr%TYPE;
719: l_trxh_init_amount_dr fun_trx_headers.init_amount_dr%TYPE;
720: l_trxh_reci_amount_cr fun_trx_headers.reci_amount_cr%TYPE;
721: l_trxh_reci_amount_dr fun_trx_headers.reci_amount_dr%TYPE;
722: l_distl_cash_rel_item fun_dist_lines.attribute1%TYPE;
723: l_distl_cash_rel_item_l fun_dist_lines.attribute1%TYPE;
724: -- AGIS: FUN_TRX_LINES
725: l_trxl_num fun_trx_lines.line_id%TYPE;

Line 742: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;

738: -- AGIS: CURRENCY RATE
739: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;
740:
741: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
742: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
743: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
744: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
745: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
746: l_get_trx_cov_rate_flg BOOLEAN := FALSE;

Line 743: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;

739: l_trxh_curr_cov_rate GL_DAILY_RATES.CONVERSION_RATE%TYPE := 1;
740:
741: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
742: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
743: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
744: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
745: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
746: l_get_trx_cov_rate_flg BOOLEAN := FALSE;
747: l_tr_func_amount number:=0;

Line 744: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;

740:
741: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
742: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
743: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
744: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
745: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
746: l_get_trx_cov_rate_flg BOOLEAN := FALSE;
747: l_tr_func_amount number:=0;
748:

Line 745: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;

741: -- AGIS: tempory parameters, to deal with the data in logic no matter it is sender or receiver;
742: l_current_initiator_id fun_trx_headers.initiator_id%TYPE;
743: l_current_recipient_id fun_trx_headers.recipient_id%TYPE;
744: l_current_amount_cr fun_trx_headers.init_amount_cr%TYPE;
745: l_current_amount_dr fun_trx_headers.init_amount_cr%TYPE;
746: l_get_trx_cov_rate_flg BOOLEAN := FALSE;
747: l_tr_func_amount number:=0;
748:
749: --cursor

Line 883: FROM FUN_TRX_HEADERS trxh

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