DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FUN_TRX_LINES

Line 284: , fun_trx_lines trxl

280: ) cash_related_item
281: INTO l_cash_flow_item_from_GL
282: FROM gl_je_lines jel
283: , fun_trx_headers trxh
284: , fun_trx_lines trxl
285: , fun_dist_lines distl
286: ,ja_cn_dff_assignments dffa
287: WHERE distl.dist_id = l_jt_id -- transaction header id
288: AND distl.line_id=trxl.line_id

Line 1335: l_trxl_num fun_trx_lines.line_id%TYPE;

1331: l_trx_line_le NUMBER;
1332: l_trx_line_com_seg fun_trx_batches.description%TYPE;
1333:
1334: -- trx_lines
1335: l_trxl_num fun_trx_lines.line_id%TYPE;
1336: l_trxl_id fun_trx_lines.trx_id%TYPE;
1337: l_distl_id NUMBER;
1338: l_distl_num fun_dist_lines.dist_number%TYPE;
1339: l_distl_party_id fun_dist_lines.party_id%Type;

Line 1336: l_trxl_id fun_trx_lines.trx_id%TYPE;

1332: l_trx_line_com_seg fun_trx_batches.description%TYPE;
1333:
1334: -- trx_lines
1335: l_trxl_num fun_trx_lines.line_id%TYPE;
1336: l_trxl_id fun_trx_lines.trx_id%TYPE;
1337: l_distl_id NUMBER;
1338: l_distl_num fun_dist_lines.dist_number%TYPE;
1339: l_distl_party_id fun_dist_lines.party_id%Type;
1340: l_distl_party_type_flg fun_dist_lines.party_type_flag%TYPE;

Line 1484: FROM FUN_TRX_LINES trl

1480: 'ATTRIBUTE9',trldist.attribute9, 'ATTRIBUTE10',trldist.attribute10, 'ATTRIBUTE11',trldist.attribute11,
1481: 'ATTRIBUTE12',trldist.attribute12, 'ATTRIBUTE13',trldist.attribute13, 'ATTRIBUTE14',trldist.attribute14,
1482: 'ATTRIBUTE15',trldist.attribute15)
1483: , '') trxh_cash_related_item
1484: FROM FUN_TRX_LINES trl
1485: ,FUN_DIST_LINES trldist
1486: ,GL_CODE_COMBINATIONS codecmb
1487: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1488: ,JA_CN_DFF_ASSIGNMENTS dff