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 332: , fun_dist_lines distl

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

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

Line 723: l_distl_cash_rel_item_l fun_dist_lines.attribute1%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;
726: l_trxl_id fun_trx_lines.trx_id%TYPE;
727: l_distl_party_id fun_dist_lines.party_id%Type;

Line 727: l_distl_party_id fun_dist_lines.party_id%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;
726: l_trxl_id fun_trx_lines.trx_id%TYPE;
727: l_distl_party_id fun_dist_lines.party_id%Type;
728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;

Line 728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;

724: -- AGIS: FUN_TRX_LINES
725: l_trxl_num fun_trx_lines.line_id%TYPE;
726: l_trxl_id fun_trx_lines.trx_id%TYPE;
727: l_distl_party_id fun_dist_lines.party_id%Type;
728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;

Line 729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;

725: l_trxl_num fun_trx_lines.line_id%TYPE;
726: l_trxl_id fun_trx_lines.trx_id%TYPE;
727: l_distl_party_id fun_dist_lines.party_id%Type;
728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;

Line 730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;

726: l_trxl_id fun_trx_lines.trx_id%TYPE;
727: l_distl_party_id fun_dist_lines.party_id%Type;
728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;
734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

Line 731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;

727: l_distl_party_id fun_dist_lines.party_id%Type;
728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;
734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

Line 732: l_distl_number fun_dist_lines.dist_number%TYPE;

728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;
729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;
734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
736: l_distl_id NUMBER;

Line 733: l_distl_ccid fun_dist_lines.ccid%TYPE;

729: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
730: l_distl_amount_cr fun_dist_lines.amount_cr%TYPE;
731: l_distl_amount_dr fun_dist_lines.amount_dr%TYPE;
732: l_distl_number fun_dist_lines.dist_number%TYPE;
733: l_distl_ccid fun_dist_lines.ccid%TYPE;
734: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
735: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
736: l_distl_id NUMBER;
737:

Line 928: ,FUN_DIST_LINES trldist

924: 'ATTRIBUTE12',trldist.attribute12, 'ATTRIBUTE13',trldist.attribute13, 'ATTRIBUTE14',trldist.attribute14,
925: 'ATTRIBUTE15',trldist.attribute15)
926: , '') distl_cash_related_item
927: FROM FUN_TRX_LINES trl
928: ,FUN_DIST_LINES trldist
929: ,GL_CODE_COMBINATIONS codecmb
930: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
931: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
932: ,JA_CN_DFF_ASSIGNMENTS dff