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_DIST_LINES

Line 321: , fun_dist_lines distl

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
324: AND distl.line_id=trxl.line_id
325: AND trxh.trx_id = trxl.trx_id

Line 704: l_distl_cash_rel_item fun_dist_lines.attribute1%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;
708: l_trxl_id fun_trx_lines.trx_id%TYPE;

Line 705: l_distl_cash_rel_item_l fun_dist_lines.attribute1%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;
708: l_trxl_id fun_trx_lines.trx_id%TYPE;
709: l_distl_party_id fun_dist_lines.party_id%Type;

Line 709: l_distl_party_id fun_dist_lines.party_id%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;
708: l_trxl_id fun_trx_lines.trx_id%TYPE;
709: l_distl_party_id fun_dist_lines.party_id%Type;
710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;

Line 710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;

706: -- AGIS: FUN_TRX_LINES
707: l_trxl_num fun_trx_lines.line_id%TYPE;
708: l_trxl_id fun_trx_lines.trx_id%TYPE;
709: l_distl_party_id fun_dist_lines.party_id%Type;
710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;

Line 711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;

707: l_trxl_num fun_trx_lines.line_id%TYPE;
708: l_trxl_id fun_trx_lines.trx_id%TYPE;
709: l_distl_party_id fun_dist_lines.party_id%Type;
710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;

Line 712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;

708: l_trxl_id fun_trx_lines.trx_id%TYPE;
709: l_distl_party_id fun_dist_lines.party_id%Type;
710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;
716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

Line 713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;

709: l_distl_party_id fun_dist_lines.party_id%Type;
710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;
716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

Line 714: l_distl_number fun_dist_lines.dist_number%TYPE;

710: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;
716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
718: l_distl_id NUMBER;

Line 715: l_distl_ccid fun_dist_lines.ccid%TYPE;

711: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
712: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
713: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
714: l_distl_number fun_dist_lines.dist_number%TYPE;
715: l_distl_ccid fun_dist_lines.ccid%TYPE;
716: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
717: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
718: l_distl_id NUMBER;
719:

Line 908: ,FUN_DIST_LINES trldist

904: 'ATTRIBUTE12',trldist.attribute12, 'ATTRIBUTE13',trldist.attribute13, 'ATTRIBUTE14',trldist.attribute14,
905: 'ATTRIBUTE15',trldist.attribute15)
906: , '') distl_cash_related_item
907: FROM FUN_TRX_LINES trl
908: ,FUN_DIST_LINES trldist
909: ,GL_CODE_COMBINATIONS codecmb
910: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
911: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
912: ,JA_CN_DFF_ASSIGNMENTS dff