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_TB_DATA_MANAGER_PVT dependencies on GL_LEDGERS

Line 357: ,gl_ledgers gl

353: ,xla_ae_lines xal
354: ,xla_distribution_links xdl
355: ,xla_ledger_options xlo
356: ,fnd_currencies fdc
357: ,gl_ledgers gl
358: ,gl_code_combinations gcc
359: ,xla_event_types_b xet
360: ,xla_tb_definitions_b xtd
361: $l_from$

Line 2158: FROM xla_gl_ledgers

2154: SELECT work_unit
2155: ,num_of_workers
2156: INTO g_work_unit
2157: ,g_num_of_workers
2158: FROM xla_gl_ledgers
2159: WHERE ledger_id = p_ledger_id ;
2160: EXCEPTION
2161: WHEN no_data_found THEN
2162: l_ledger_info := get_ledger_info

Line 2228: FROM gl_ledgers gl

2224: ,l_ledger_info.ledger_category_code
2225: ,l_ledger_info.currency_code
2226: ,l_ledger_info.coa_id
2227: ,l_ledger_info.object_type_code
2228: FROM gl_ledgers gl
2229: WHERE gl.ledger_id = p_ledger_id;
2230:
2231:
2232: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2288: FROM gl_ledgers gl

2284:
2285: IF p_object_type_code = 'S' THEN
2286: l_ledger_where := ' AND xah.ledger_id IN
2287: (SELECT gl.ledger_id
2288: FROM gl_ledgers gl
2289: ,gl_ledger_set_assignments sa
2290: WHERE gl.ledger_id = sa.ledger_id
2291: AND sa.ledger_set_id = :9) ';
2292: ELSE

Line 2498: FROM gl_ledgers

2494: BEGIN
2495:
2496: SELECT chart_of_accounts_id
2497: INTO l_coa_id
2498: FROM gl_ledgers
2499: WHERE ledger_id = p_ledger_id;
2500:
2501: FOR c1 IN csr_segments(l_coa_id) LOOP
2502: l_return_string := l_return_string||

Line 3150: -- use joins between gl_ledgers and gl_ledger_set_assignments

3146: REPLACE(l_sql,'$mgt_segment$',l_mgt_segment_column);
3147:
3148: --
3149: -- If object type is 'S' (Ledger Set) then
3150: -- use joins between gl_ledgers and gl_ledger_set_assignments
3151: -- else
3152: -- use a simple join with gl_ledgers
3153: -- end if
3154: l_ledger_where := get_ledger_where

Line 3152: -- use a simple join with gl_ledgers

3148: --
3149: -- If object type is 'S' (Ledger Set) then
3150: -- use joins between gl_ledgers and gl_ledger_set_assignments
3151: -- else
3152: -- use a simple join with gl_ledgers
3153: -- end if
3154: l_ledger_where := get_ledger_where
3155: (p_ledger_id => g_ledger_id
3156: ,p_object_type_code => l_ledger_info.object_type_code);

Line 3245: FROM gl_ledgers

3241: /*Deriving primary ledger bug#7717479 */
3242: FOR i IN
3243: (
3244: SELECT ledger_id
3245: FROM gl_ledgers
3246: WHERE ledger_category_code = 'PRIMARY'
3247: AND configuration_id =
3248: (SELECT configuration_id
3249: FROM gl_ledgers WHERE ledger_id = g_ledger_id )

Line 3249: FROM gl_ledgers WHERE ledger_id = g_ledger_id )

3245: FROM gl_ledgers
3246: WHERE ledger_category_code = 'PRIMARY'
3247: AND configuration_id =
3248: (SELECT configuration_id
3249: FROM gl_ledgers WHERE ledger_id = g_ledger_id )
3250: )
3251: LOOP
3252: l_derived_primary_ledger := i.ledger_id;
3253: END LOOP;

Line 3369: FROM gl_ledgers

3365: /*Deriving primary ledger bug#7717479 */
3366: FOR i IN
3367: (
3368: SELECT ledger_id
3369: FROM gl_ledgers
3370: WHERE ledger_category_code = 'PRIMARY'
3371: AND configuration_id =
3372: (SELECT configuration_id
3373: FROM gl_ledgers WHERE ledger_id = g_ledger_id )

Line 3373: FROM gl_ledgers WHERE ledger_id = g_ledger_id )

3369: FROM gl_ledgers
3370: WHERE ledger_category_code = 'PRIMARY'
3371: AND configuration_id =
3372: (SELECT configuration_id
3373: FROM gl_ledgers WHERE ledger_id = g_ledger_id )
3374: )
3375: LOOP
3376: l_derived_primary_ledger := i.ledger_id;
3377: END LOOP;

Line 3754: -- use joins between gl_ledgers and gl_ledger_set_assignments

3750: END IF;
3751:
3752: --
3753: -- If object type is 'S' (Ledger Set) then
3754: -- use joins between gl_ledgers and gl_ledger_set_assignments
3755: -- else
3756: -- use a simple join with gl_ledgers
3757: -- end if
3758: l_ledger_where := get_ledger_where

Line 3756: -- use a simple join with gl_ledgers

3752: --
3753: -- If object type is 'S' (Ledger Set) then
3754: -- use joins between gl_ledgers and gl_ledger_set_assignments
3755: -- else
3756: -- use a simple join with gl_ledgers
3757: -- end if
3758: l_ledger_where := get_ledger_where
3759: (p_ledger_id => g_ledger_id
3760: ,p_object_type_code => l_ledger_info.object_type_code);

Line 4117: FROM gl_ledgers lg

4113: FROM xla_ae_headers
4114: WHERE group_id = p_group_id
4115: AND ledger_id IN (
4116: SELECT lg.ledger_id
4117: FROM gl_ledgers lg
4118: ,gl_ledger_set_assignments sa
4119: WHERE lg.ledger_id = sa.ledger_id
4120: AND sa.ledger_set_id = p_ledger_id)
4121: GROUP BY ae_header_id

Line 4218: FROM gl_ledgers lg

4214: ,xla_tb_defn_je_sources xjs
4215: WHERE gl_transfer_status_code IN ('Y','NT')
4216: AND aeh.ledger_id IN (
4217: SELECT lg.ledger_id
4218: FROM gl_ledgers lg
4219: ,gl_ledger_set_assignments sa
4220: WHERE lg.ledger_id = sa.ledger_id
4221: AND sa.ledger_set_id = p_ledger_id)
4222: AND xtd.definition_code = p_definition_code

Line 4324: FROM gl_ledgers lg

4320: ,xla_tb_defn_je_sources xjs
4321: WHERE gl_transfer_status_code IN ('Y','NT')
4322: AND aeh.ledger_id IN (
4323: SELECT lg.ledger_id
4324: FROM gl_ledgers lg
4325: ,gl_ledger_set_assignments sa
4326: WHERE lg.ledger_id = sa.ledger_id
4327: AND sa.ledger_set_id = p_ledger_id)
4328: AND xtd.definition_code = p_definition_code