APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FUN_TRX_LINES

Line 287: , fun_trx_lines trxl

283: SELECT global_attribute6 cash_related_item
284: INTO l_cash_flow_item_from_GL
285: FROM gl_je_lines jel
286: , fun_trx_headers trxh
287: , fun_trx_lines trxl
288: , fun_dist_lines distl
289: --,ja_cn_dff_assignments dffa
290: WHERE distl.dist_id = l_jt_id -- transaction header id
291: AND distl.line_id=trxl.line_id

Line 1372: l_trxl_num fun_trx_lines.line_id%TYPE;

1368: l_trx_line_le NUMBER;
1369: l_trx_line_com_seg fun_trx_batches.description%TYPE;
1370:
1371: -- trx_lines
1372: l_trxl_num fun_trx_lines.line_id%TYPE;
1373: l_trxl_id fun_trx_lines.trx_id%TYPE;
1374: l_distl_id NUMBER;
1375: l_distl_num fun_dist_lines.dist_number%TYPE;
1376: l_distl_party_id fun_dist_lines.party_id%Type;

Line 1373: l_trxl_id fun_trx_lines.trx_id%TYPE;

1369: l_trx_line_com_seg fun_trx_batches.description%TYPE;
1370:
1371: -- trx_lines
1372: l_trxl_num fun_trx_lines.line_id%TYPE;
1373: l_trxl_id fun_trx_lines.trx_id%TYPE;
1374: l_distl_id NUMBER;
1375: l_distl_num fun_dist_lines.dist_number%TYPE;
1376: l_distl_party_id fun_dist_lines.party_id%Type;
1377: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;

Line 1521: FROM FUN_TRX_LINES trl

1517: 'ATTRIBUTE9',trldist.attribute9, 'ATTRIBUTE10',trldist.attribute10, 'ATTRIBUTE11',trldist.attribute11,
1518: 'ATTRIBUTE12',trldist.attribute12, 'ATTRIBUTE13',trldist.attribute13, 'ATTRIBUTE14',trldist.attribute14,
1519: 'ATTRIBUTE15',trldist.attribute15)
1520: , '') trxh_cash_related_item
1521: FROM FUN_TRX_LINES trl
1522: ,FUN_DIST_LINES trldist
1523: ,GL_CODE_COMBINATIONS codecmb
1524: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1525: ,JA_CN_DFF_ASSIGNMENTS dff