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 1543: ,gl_code_combinations ccid

1539: ,h.period_name
1540: ,l.gain_or_loss_flag
1541: FROM xla_ae_headers_gt h
1542: ,xla_ae_lines l
1543: ,gl_code_combinations ccid
1544: ,fnd_currencies fcu
1545: WHERE ccid.code_combination_id(+) = l.code_combination_id
1546: AND l.ae_header_id = h.ae_header_id
1547: AND h.ledger_id = :5

Line 1984: ,gl_code_combinations ccid

1980: ,h.accounting_entry_status_code
1981: ,h.period_name
1982: FROM xla_ae_headers_gt h
1983: ,xla_ae_lines l
1984: ,gl_code_combinations ccid
1985: ,gl_code_combinations ccid1
1986: ,gl_suspense_accounts gsa
1987: ,gl_suspense_accounts gsa1
1988: ,gl_suspense_accounts gsa2

Line 1985: ,gl_code_combinations ccid1

1981: ,h.period_name
1982: FROM xla_ae_headers_gt h
1983: ,xla_ae_lines l
1984: ,gl_code_combinations ccid
1985: ,gl_code_combinations ccid1
1986: ,gl_suspense_accounts gsa
1987: ,gl_suspense_accounts gsa1
1988: ,gl_suspense_accounts gsa2
1989: ,gl_suspense_accounts gsa3

Line 2174: FROM gl_code_combinations ccid

2170: or (l.accounted_cr is NULL and l.accounted_dr is NULL and l.currency_conversion_rate is NULL)
2171: THEN ''Y''
2172: ELSE NULL
2173: END
2174: FROM gl_code_combinations ccid
2175: WHERE ccid.code_combination_id = l.code_combination_id )
2176: WHERE l.substituted_by_suspense_flag= ''Y''
2177: AND l.code_combination_id > 0 ';
2178: --bug#10047740 added CCID condition not to update if unable to derive Suspense Account with BSV Overridden

Line 2527: ,gl_code_combinations ccid

2523: ,h.period_name
2524: ,l.gain_or_loss_flag
2525: FROM xla_ae_headers_gt h
2526: ,xla_ae_lines l
2527: ,gl_code_combinations ccid
2528: ,gl_code_combinations ccid1
2529: ,fnd_currencies fcu
2530: WHERE ccid.code_combination_id(+) = l.code_combination_id
2531: AND l.ae_header_id = h.ae_header_id

Line 2528: ,gl_code_combinations ccid1

2524: ,l.gain_or_loss_flag
2525: FROM xla_ae_headers_gt h
2526: ,xla_ae_lines l
2527: ,gl_code_combinations ccid
2528: ,gl_code_combinations ccid1
2529: ,fnd_currencies fcu
2530: WHERE ccid.code_combination_id(+) = l.code_combination_id
2531: AND l.ae_header_id = h.ae_header_id
2532: AND h.ledger_id = :9

Line 2870: ,gl_code_combinations ccid

2866: ELSE NULL
2867: END
2868: FROM xla_ae_headers h
2869: ,xla_ae_lines l
2870: ,gl_code_combinations ccid
2871: ,fnd_currencies fcu
2872: WHERE ccid.code_combination_id(+) = l.code_combination_id
2873: AND l.ae_header_id = h.ae_header_id
2874: AND l.application_id = h.application_id

Line 5717: FROM gl_code_combinations t

5713: , decode(p_bal_seg_column,'SEGMENT27',p_bal_seg_val,t.segment27)
5714: , decode(p_bal_seg_column,'SEGMENT28',p_bal_seg_val,t.segment28)
5715: , decode(p_bal_seg_column,'SEGMENT29',p_bal_seg_val,t.segment29)
5716: , decode(p_bal_seg_column,'SEGMENT30',p_bal_seg_val,t.segment30)
5717: FROM gl_code_combinations t
5718: WHERE t.code_combination_id = p_sus_ccid;
5719:
5720: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
5721: SELECT display_order

Line 5766: FROM gl_code_combinations

5762: ELSIF (g_mgt_seg_column_name = g_bal_seg_column_name) THEN
5763: l_mgt_seg_val := l_bal.bal_seg_val;
5764: ELSE
5765: l_stmt := 'SELECT '||g_mgt_seg_column_name||'
5766: FROM gl_code_combinations
5767: WHERE code_combination_id = '||g_sla_ledger_cur_bal_sus_ccid;
5768:
5769: EXECUTE IMMEDIATE l_stmt INTO l_mgt_seg_val;
5770: END IF;

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

5791: l_seg2(21), l_seg2(22), l_seg2(23), l_seg2(24), l_seg2(25),
5792: l_seg2(26), l_seg2(27), l_seg2(28), l_seg2(29), l_seg2(30);
5793: CLOSE c_sccid_segs;
5794:
5795: l_stmt := 'SELECT code_combination_id, reference3 FROM gl_code_combinations '||
5796: 'WHERE chart_of_accounts_id = :1 ';
5797: FOR i in 1 .. 30 LOOP
5798: IF l_seg2(i) IS NOT NULL THEN
5799: l_stmt := l_stmt || ' AND segment'||i||' = '''||l_seg2(i)||'''';

Line 5899: FROM gl_code_combinations

5895: l_result := 1;
5896: l_ref3 := 'N';
5897: ELSE
5898: SELECT reference3 INTO l_ref3
5899: FROM gl_code_combinations
5900: WHERE code_combination_id = l_sus_ccid;
5901: END IF;
5902: END IF;
5903: END IF;

Line 6442: FROM gl_code_combinations t

6438: , decode(p_bal_seg_column,'SEGMENT27',p_bal_seg_val,t.segment27)
6439: , decode(p_bal_seg_column,'SEGMENT28',p_bal_seg_val,t.segment28)
6440: , decode(p_bal_seg_column,'SEGMENT29',p_bal_seg_val,t.segment29)
6441: , decode(p_bal_seg_column,'SEGMENT30',p_bal_seg_val,t.segment30)
6442: FROM gl_code_combinations t
6443: WHERE t.code_combination_id = p_rounding_ccid;
6444:
6445: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
6446: SELECT display_order

Line 6532: FROM gl_code_combinations

6528: ELSIF (g_mgt_seg_column_name = g_bal_seg_column_name) THEN
6529: l_mgt_seg_val := l_bal.bal_seg_val;
6530: ELSE
6531: l_stmt := 'SELECT '||g_mgt_seg_column_name||'
6532: FROM gl_code_combinations
6533: WHERE code_combination_id = '||g_sla_rounding_ccid;
6534:
6535: EXECUTE IMMEDIATE l_stmt INTO l_mgt_seg_val;
6536: END IF;

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

6557: l_seg2(21), l_seg2(22), l_seg2(23), l_seg2(24), l_seg2(25),
6558: l_seg2(26), l_seg2(27), l_seg2(28), l_seg2(29), l_seg2(30);
6559: CLOSE c_rccid_segs;
6560:
6561: l_stmt := 'SELECT code_combination_id, reference3 FROM gl_code_combinations '||
6562: 'WHERE chart_of_accounts_id = :1 ';
6563: FOR i in 1 .. 30 LOOP
6564: IF l_seg2(i) IS NOT NULL THEN
6565: l_stmt := l_stmt || ' AND segment'||i||' = '''||l_seg2(i)||'''';

Line 6674: FROM gl_code_combinations

6670: g_err_event_ids(g_err_count) := l_bal.event_id;
6671: ELSE
6672: SELECT reference3
6673: INTO l_ref3
6674: FROM gl_code_combinations
6675: WHERE code_combination_id = l_rounding_ccid;
6676: END IF;
6677: END IF;
6678: END IF;

Line 7698: ,gl_code_combinations ccid

7694: C_LINE_TYPE_IC_BAL_INTER)
7695: ,l.balance_type_code
7696: FROM fun_bal_results_gt res
7697: ,xla_validation_lines_gt l
7698: ,gl_code_combinations ccid
7699: ,fnd_currencies fcu
7700: WHERE l.ae_line_num = l.max_ae_line_num
7701: AND l.ae_header_id = res.group_id
7702: AND ccid.code_combination_id= res.ccid

Line 7796: ,gl_code_combinations ccid

7792: C_LINE_TYPE_IC_BAL_INTER)
7793: ,l.balance_type_code
7794: FROM fun_bal_results_gt res
7795: ,xla_validation_lines_gt l
7796: ,gl_code_combinations ccid
7797: ,fnd_currencies fcu
7798: WHERE l.ae_line_num = l.max_ae_line_num
7799: AND l.balancing_line_type NOT IN (C_LINE_TYPE_IC_BAL_INTRA, C_LINE_TYPE_IC_BAL_INTER)
7800: AND l.ae_header_id = res.group_id * -1

Line 7948: FROM gl_code_combinations

7944: WHERE application_column_name = p_seg_col_name;
7945:
7946: CURSOR c_ref3 (p_ccid INTEGER) IS
7947: SELECT reference3
7948: FROM gl_code_combinations
7949: WHERE code_combination_id = p_ccid;
7950:
7951: BEGIN
7952: IF g_log_enabled THEN

Line 8826: FROM gl_code_combinations nc,

8822: 'SEGMENT23', sc.segment23, 'SEGMENT24', sc.segment24,
8823: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
8824: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
8825: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
8826: FROM gl_code_combinations nc,
8827: gl_code_combinations sc
8828: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
8829: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
8830: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',

Line 8827: gl_code_combinations sc

8823: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
8824: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
8825: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
8826: FROM gl_code_combinations nc,
8827: gl_code_combinations sc
8828: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
8829: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
8830: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',
8831: t.bal_seg_value,nvl(sc.segment2,C_CHAR))

Line 9274: FROM gl_code_combinations nc,

9270: 'SEGMENT23', sc.segment23, 'SEGMENT24', sc.segment24,
9271: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
9272: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
9273: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
9274: FROM gl_code_combinations nc,
9275: gl_code_combinations sc
9276: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
9277: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
9278: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',

Line 9275: gl_code_combinations sc

9271: 'SEGMENT25', sc.segment25, 'SEGMENT26', sc.segment26,
9272: 'SEGMENT27', sc.segment27, 'SEGMENT28', sc.segment28,
9273: 'SEGMENT29', sc.segment29, 'SEGMENT30', sc.segment30, NULL)
9274: FROM gl_code_combinations nc,
9275: gl_code_combinations sc
9276: WHERE nvl(nc.segment1,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT1',
9277: t.bal_seg_value,nvl(sc.segment1,C_CHAR))
9278: AND nvl(nc.segment2,C_CHAR) = DECODE(g_bal_seg_column_name,'SEGMENT2',
9279: t.bal_seg_value,nvl(sc.segment2,C_CHAR))

Line 9366: FROM gl_code_combinations nc,

9362: ''SEGMENT23'', sc.segment23, ''SEGMENT24'', sc.segment24,
9363: ''SEGMENT25'', sc.segment25, ''SEGMENT26'', sc.segment26,
9364: ''SEGMENT27'', sc.segment27, ''SEGMENT28'', sc.segment28,
9365: ''SEGMENT29'', sc.segment29, ''SEGMENT30'', sc.segment30, NULL)
9366: FROM gl_code_combinations nc,
9367: gl_code_combinations sc
9368: WHERE ';
9369:
9370:

Line 9367: gl_code_combinations sc

9363: ''SEGMENT25'', sc.segment25, ''SEGMENT26'', sc.segment26,
9364: ''SEGMENT27'', sc.segment27, ''SEGMENT28'', sc.segment28,
9365: ''SEGMENT29'', sc.segment29, ''SEGMENT30'', sc.segment30, NULL)
9366: FROM gl_code_combinations nc,
9367: gl_code_combinations sc
9368: WHERE ';
9369:
9370:
9371: l_stmt2 := ' ';

Line 9614: ,gl_code_combinations ccid

9610: ,l.party_id
9611: ,l.party_site_id
9612: ,'N' -- 4262811
9613: FROM xla_validation_lines_gt l
9614: ,gl_code_combinations ccid
9615: ,xla_lookups xl -- added line for bug 6902085
9616: WHERE l.balancing_line_type NOT IN (C_LINE_TYPE_PROCESS, C_LINE_TYPE_COMPLETE)
9617: AND ccid.code_combination_id(+) = l.code_combination_id
9618: AND xl.lookup_type = 'XLA_JE_VALD_LINE_DESC' -- added filter for bug 6902085