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.XLA_JE_VALIDATION_PKG dependencies on GL_CODE_COMBINATIONS

Line 1278: ,gl_code_combinations ccid

1274: ,h.period_name
1275: ,l.gain_or_loss_flag
1276: FROM xla_ae_headers_gt h
1277: ,xla_ae_lines l
1278: ,gl_code_combinations ccid
1279: ,fnd_currencies fcu
1280: WHERE ccid.code_combination_id(+) = l.code_combination_id
1281: AND l.ae_header_id = h.ae_header_id
1282: AND h.ledger_id = :5

Line 1716: ,gl_code_combinations ccid

1712: ,h.accounting_entry_status_code
1713: ,h.period_name
1714: FROM xla_ae_headers_gt h
1715: ,xla_ae_lines l
1716: ,gl_code_combinations ccid
1717: ,gl_code_combinations ccid1
1718: ,gl_suspense_accounts gsa
1719: ,gl_suspense_accounts gsa1
1720: ,gl_suspense_accounts gsa2

Line 1717: ,gl_code_combinations ccid1

1713: ,h.period_name
1714: FROM xla_ae_headers_gt h
1715: ,xla_ae_lines l
1716: ,gl_code_combinations ccid
1717: ,gl_code_combinations ccid1
1718: ,gl_suspense_accounts gsa
1719: ,gl_suspense_accounts gsa1
1720: ,gl_suspense_accounts gsa2
1721: ,gl_suspense_accounts gsa3

Line 1902: FROM gl_code_combinations ccid

1898: or (l.accounted_cr is NULL and l.accounted_dr is NULL and l.currency_conversion_rate is NULL)
1899: THEN ''Y''
1900: ELSE NULL
1901: END
1902: FROM gl_code_combinations ccid
1903: WHERE ccid.code_combination_id = l.code_combination_id )
1904: WHERE l.substituted_by_suspense_flag= ''Y''';
1905:
1906: IF (C_LEVEL_STATEMENT>= g_log_level) THEN

Line 2253: ,gl_code_combinations ccid

2249: ,h.period_name
2250: ,l.gain_or_loss_flag
2251: FROM xla_ae_headers_gt h
2252: ,xla_ae_lines l
2253: ,gl_code_combinations ccid
2254: ,gl_code_combinations ccid1
2255: ,fnd_currencies fcu
2256: WHERE ccid.code_combination_id(+) = l.code_combination_id
2257: AND l.ae_header_id = h.ae_header_id

Line 2254: ,gl_code_combinations ccid1

2250: ,l.gain_or_loss_flag
2251: FROM xla_ae_headers_gt h
2252: ,xla_ae_lines l
2253: ,gl_code_combinations ccid
2254: ,gl_code_combinations ccid1
2255: ,fnd_currencies fcu
2256: WHERE ccid.code_combination_id(+) = l.code_combination_id
2257: AND l.ae_header_id = h.ae_header_id
2258: AND h.ledger_id = :9

Line 2595: ,gl_code_combinations ccid

2591: ELSE NULL
2592: END
2593: FROM xla_ae_headers h
2594: ,xla_ae_lines l
2595: ,gl_code_combinations ccid
2596: ,fnd_currencies fcu
2597: WHERE ccid.code_combination_id(+) = l.code_combination_id
2598: AND l.ae_header_id = h.ae_header_id
2599: AND l.application_id = h.application_id

Line 5413: FROM gl_code_combinations t

5409: , decode(p_bal_seg_column,'SEGMENT27',p_bal_seg_val,t.segment27)
5410: , decode(p_bal_seg_column,'SEGMENT28',p_bal_seg_val,t.segment28)
5411: , decode(p_bal_seg_column,'SEGMENT29',p_bal_seg_val,t.segment29)
5412: , decode(p_bal_seg_column,'SEGMENT30',p_bal_seg_val,t.segment30)
5413: FROM gl_code_combinations t
5414: WHERE t.code_combination_id = p_sus_ccid;
5415:
5416: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
5417: SELECT display_order

Line 5462: FROM gl_code_combinations

5458: ELSIF (g_mgt_seg_column_name = g_bal_seg_column_name) THEN
5459: l_mgt_seg_val := l_bal.bal_seg_val;
5460: ELSE
5461: l_stmt := 'SELECT '||g_mgt_seg_column_name||'
5462: FROM gl_code_combinations
5463: WHERE code_combination_id = '||g_sla_ledger_cur_bal_sus_ccid;
5464:
5465: EXECUTE IMMEDIATE l_stmt INTO l_mgt_seg_val;
5466: END IF;

Line 5491: l_stmt := 'SELECT code_combination_id, reference3 FROM gl_code_combinations '||

5487: l_seg2(21), l_seg2(22), l_seg2(23), l_seg2(24), l_seg2(25),
5488: l_seg2(26), l_seg2(27), l_seg2(28), l_seg2(29), l_seg2(30);
5489: CLOSE c_sccid_segs;
5490:
5491: l_stmt := 'SELECT code_combination_id, reference3 FROM gl_code_combinations '||
5492: 'WHERE chart_of_accounts_id = :1 ';
5493: FOR i in 1 .. 30 LOOP
5494: IF l_seg2(i) IS NOT NULL THEN
5495: l_stmt := l_stmt || ' AND segment'||i||' = '''||l_seg2(i)||'''';

Line 5595: FROM gl_code_combinations

5591: l_result := 1;
5592: l_ref3 := 'N';
5593: ELSE
5594: SELECT reference3 INTO l_ref3
5595: FROM gl_code_combinations
5596: WHERE code_combination_id = l_sus_ccid;
5597: END IF;
5598: END IF;
5599: END IF;

Line 6128: FROM gl_code_combinations t

6124: , decode(p_bal_seg_column,'SEGMENT27',p_bal_seg_val,t.segment27)
6125: , decode(p_bal_seg_column,'SEGMENT28',p_bal_seg_val,t.segment28)
6126: , decode(p_bal_seg_column,'SEGMENT29',p_bal_seg_val,t.segment29)
6127: , decode(p_bal_seg_column,'SEGMENT30',p_bal_seg_val,t.segment30)
6128: FROM gl_code_combinations t
6129: WHERE t.code_combination_id = p_rounding_ccid;
6130:
6131: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
6132: SELECT display_order

Line 6218: FROM gl_code_combinations

6214: ELSIF (g_mgt_seg_column_name = g_bal_seg_column_name) THEN
6215: l_mgt_seg_val := l_bal.bal_seg_val;
6216: ELSE
6217: l_stmt := 'SELECT '||g_mgt_seg_column_name||'
6218: FROM gl_code_combinations
6219: WHERE code_combination_id = '||g_sla_rounding_ccid;
6220:
6221: EXECUTE IMMEDIATE l_stmt INTO l_mgt_seg_val;
6222: END IF;

Line 6247: l_stmt := 'SELECT code_combination_id, reference3 FROM gl_code_combinations '||

6243: l_seg2(21), l_seg2(22), l_seg2(23), l_seg2(24), l_seg2(25),
6244: l_seg2(26), l_seg2(27), l_seg2(28), l_seg2(29), l_seg2(30);
6245: CLOSE c_rccid_segs;
6246:
6247: l_stmt := 'SELECT code_combination_id, reference3 FROM gl_code_combinations '||
6248: 'WHERE chart_of_accounts_id = :1 ';
6249: FOR i in 1 .. 30 LOOP
6250: IF l_seg2(i) IS NOT NULL THEN
6251: l_stmt := l_stmt || ' AND segment'||i||' = '''||l_seg2(i)||'''';

Line 6360: FROM gl_code_combinations

6356: g_err_event_ids(g_err_count) := l_bal.event_id;
6357: ELSE
6358: SELECT reference3
6359: INTO l_ref3
6360: FROM gl_code_combinations
6361: WHERE code_combination_id = l_rounding_ccid;
6362: END IF;
6363: END IF;
6364: END IF;

Line 7247: ,gl_code_combinations ccid

7243: C_LINE_TYPE_IC_BAL_INTER)
7244: ,l.balance_type_code
7245: FROM fun_bal_results_gt res
7246: ,xla_validation_lines_gt l
7247: ,gl_code_combinations ccid
7248: ,fnd_currencies fcu
7249: WHERE l.ae_line_num = l.max_ae_line_num
7250: AND l.ae_header_id = res.group_id
7251: AND ccid.code_combination_id= res.ccid

Line 7346: ,gl_code_combinations ccid

7342: C_LINE_TYPE_IC_BAL_INTER)
7343: ,l.balance_type_code
7344: FROM fun_bal_results_gt res
7345: ,xla_validation_lines_gt l
7346: ,gl_code_combinations ccid
7347: ,fnd_currencies fcu
7348: WHERE l.ae_line_num = l.max_ae_line_num
7349: AND l.ae_header_id = res.group_id
7350: AND ccid.code_combination_id= res.ccid

Line 7498: FROM gl_code_combinations

7494: WHERE application_column_name = p_seg_col_name;
7495:
7496: CURSOR c_ref3 (p_ccid INTEGER) IS
7497: SELECT reference3
7498: FROM gl_code_combinations
7499: WHERE code_combination_id = p_ccid;
7500:
7501: BEGIN
7502: IF g_log_enabled THEN

Line 8228: FROM gl_code_combinations nc,

8224: 'SEGMENT23', sc.segment23, 'SEGMENT24', sc.segment24,
8225: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
8226: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
8227: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
8228: FROM gl_code_combinations nc,
8229: gl_code_combinations sc
8230: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
8231: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
8232: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',

Line 8229: gl_code_combinations sc

8225: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
8226: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
8227: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
8228: FROM gl_code_combinations nc,
8229: gl_code_combinations sc
8230: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
8231: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
8232: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',
8233: t.bal_seg_value,nvl(sc.segment2,C_CHAR))

Line 8672: FROM gl_code_combinations nc,

8668: 'SEGMENT23', sc.segment23, 'SEGMENT24', sc.segment24,
8669: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
8670: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
8671: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
8672: FROM gl_code_combinations nc,
8673: gl_code_combinations sc
8674: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
8675: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
8676: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',

Line 8673: gl_code_combinations sc

8669: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
8670: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
8671: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
8672: FROM gl_code_combinations nc,
8673: gl_code_combinations sc
8674: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
8675: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
8676: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',
8677: t.bal_seg_value,nvl(sc.segment2,C_CHAR))

Line 8933: ,gl_code_combinations ccid

8929: ,l.party_id
8930: ,l.party_site_id
8931: ,'N' -- 4262811
8932: FROM xla_validation_lines_gt l
8933: ,gl_code_combinations ccid
8934: ,xla_lookups xl -- added line for bug 6902085
8935: WHERE l.balancing_line_type NOT IN (C_LINE_TYPE_PROCESS, C_LINE_TYPE_COMPLETE)
8936: AND ccid.code_combination_id(+) = l.code_combination_id
8937: AND xl.lookup_type = 'XLA_JE_VALD_LINE_DESC' -- added filter for bug 6902085