DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FUN_TRX_LINES

Line 331: , fun_trx_lines trxl

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

Line 724: -- AGIS: FUN_TRX_LINES

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;
728: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;

Line 725: l_trxl_num fun_trx_lines.line_id%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;
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;

Line 726: l_trxl_id fun_trx_lines.trx_id%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;
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;

Line 927: FROM FUN_TRX_LINES trl

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