[Home] [Help]
338: ,xla_ae_lines xal
339: ,xla_distribution_links xdl
340: ,xla_ledger_options xlo
341: ,fnd_currencies fdc
342: ,gl_ledgers gl
343: ,gl_code_combinations gcc
344: ,xla_event_types_b xet
345: ,xla_tb_definitions_b xtd
346: $l_from$
2105: SELECT work_unit
2106: ,num_of_workers
2107: INTO g_work_unit
2108: ,g_num_of_workers
2109: FROM xla_gl_ledgers
2110: WHERE ledger_id = p_ledger_id ;
2111: EXCEPTION
2112: WHEN no_data_found THEN
2113: l_ledger_info := get_ledger_info
2175: ,l_ledger_info.ledger_category_code
2176: ,l_ledger_info.currency_code
2177: ,l_ledger_info.coa_id
2178: ,l_ledger_info.object_type_code
2179: FROM gl_ledgers gl
2180: WHERE gl.ledger_id = p_ledger_id;
2181:
2182:
2183: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2235:
2236: IF p_object_type_code = 'S' THEN
2237: l_ledger_where := ' AND xah.ledger_id IN
2238: (SELECT gl.ledger_id
2239: FROM gl_ledgers gl
2240: ,gl_ledger_set_assignments sa
2241: WHERE gl.ledger_id = sa.ledger_id
2242: AND sa.ledger_set_id = :9) ';
2243: ELSE
2445: BEGIN
2446:
2447: SELECT chart_of_accounts_id
2448: INTO l_coa_id
2449: FROM gl_ledgers
2450: WHERE ledger_id = p_ledger_id;
2451:
2452: FOR c1 IN csr_segments(l_coa_id) LOOP
2453: l_return_string := l_return_string||
3091: REPLACE(l_sql,'$mgt_segment$',l_mgt_segment_column);
3092:
3093: --
3094: -- If object type is 'S' (Ledger Set) then
3095: -- use joins between gl_ledgers and gl_ledger_set_assignments
3096: -- else
3097: -- use a simple join with gl_ledgers
3098: -- end if
3099: l_ledger_where := get_ledger_where
3093: --
3094: -- If object type is 'S' (Ledger Set) then
3095: -- use joins between gl_ledgers and gl_ledger_set_assignments
3096: -- else
3097: -- use a simple join with gl_ledgers
3098: -- end if
3099: l_ledger_where := get_ledger_where
3100: (p_ledger_id => g_ledger_id
3101: ,p_object_type_code => l_ledger_info.object_type_code);
3183: /*Deriving primary ledger bug#7717479 */
3184: FOR i IN
3185: (
3186: SELECT ledger_id
3187: FROM gl_ledgers
3188: WHERE ledger_category_code = 'PRIMARY'
3189: AND configuration_id =
3190: (SELECT configuration_id
3191: FROM gl_ledgers WHERE ledger_id = g_ledger_id )
3187: FROM gl_ledgers
3188: WHERE ledger_category_code = 'PRIMARY'
3189: AND configuration_id =
3190: (SELECT configuration_id
3191: FROM gl_ledgers WHERE ledger_id = g_ledger_id )
3192: )
3193: LOOP
3194: l_derived_primary_ledger := i.ledger_id;
3195: END LOOP;
3597: END IF;
3598:
3599: --
3600: -- If object type is 'S' (Ledger Set) then
3601: -- use joins between gl_ledgers and gl_ledger_set_assignments
3602: -- else
3603: -- use a simple join with gl_ledgers
3604: -- end if
3605: l_ledger_where := get_ledger_where
3599: --
3600: -- If object type is 'S' (Ledger Set) then
3601: -- use joins between gl_ledgers and gl_ledger_set_assignments
3602: -- else
3603: -- use a simple join with gl_ledgers
3604: -- end if
3605: l_ledger_where := get_ledger_where
3606: (p_ledger_id => g_ledger_id
3607: ,p_object_type_code => l_ledger_info.object_type_code);
3960: FROM xla_ae_headers
3961: WHERE group_id = p_group_id
3962: AND ledger_id IN (
3963: SELECT lg.ledger_id
3964: FROM gl_ledgers lg
3965: ,gl_ledger_set_assignments sa
3966: WHERE lg.ledger_id = sa.ledger_id
3967: AND sa.ledger_set_id = p_ledger_id)
3968: GROUP BY ae_header_id
4061: ,xla_tb_defn_je_sources xjs
4062: WHERE gl_transfer_status_code IN ('Y','NT')
4063: AND aeh.ledger_id IN (
4064: SELECT lg.ledger_id
4065: FROM gl_ledgers lg
4066: ,gl_ledger_set_assignments sa
4067: WHERE lg.ledger_id = sa.ledger_id
4068: AND sa.ledger_set_id = p_ledger_id)
4069: AND xtd.definition_code = p_definition_code
4167: ,xla_tb_defn_je_sources xjs
4168: WHERE gl_transfer_status_code IN ('Y','NT')
4169: AND aeh.ledger_id IN (
4170: SELECT lg.ledger_id
4171: FROM gl_ledgers lg
4172: ,gl_ledger_set_assignments sa
4173: WHERE lg.ledger_id = sa.ledger_id
4174: AND sa.ledger_set_id = p_ledger_id)
4175: AND xtd.definition_code = p_definition_code