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_GL_INTER_VALID_PKG dependencies on FUN_DIST_LINES

Line 288: , fun_dist_lines distl

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
292: AND trxh.trx_id = trxl.trx_id

Line 1375: l_distl_num fun_dist_lines.dist_number%TYPE;

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;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;

Line 1376: l_distl_party_id fun_dist_lines.party_id%Type;

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;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;
1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;

Line 1377: l_distl_party_type_flg fun_dist_lines.party_type_flag%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;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;
1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1381: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;

Line 1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%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;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;
1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1381: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
1382:

Line 1379: l_distl_ccid fun_dist_lines.ccid%TYPE;

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;
1378: l_distl_dist_type_flg fun_dist_lines.dist_type_flag%TYPE;
1379: l_distl_ccid fun_dist_lines.ccid%TYPE;
1380: l_codecmb_coa_id gl_code_combinations.chart_of_accounts_id%TYPE;
1381: l_codecmb_com_seg gl_code_combinations.segment1%TYPE;
1382:
1383: --trx date

Line 1522: ,FUN_DIST_LINES trldist

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
1526: WHERE trl.line_id=trldist.line_id