[Home] [Help]
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$
362: WHERE xah.ae_header_id BETWEEN :7 AND :8
582: ,xla_tb_definitions_b xtd
583: $l_from$
584: ,xla_transaction_entities_upg PARTITION (AP) xteu
585: ,xla_ae_lines PARTITION (AP) xal
586: ,gl_code_combinations gcc
587: ,( SELECT /*+ NO_MERGE*/ id_flex_num
588: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_BALANCING'', application_column_name, NULL)) balancing_segment
589: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_ACCOUNT'', application_column_name, NULL)) account_segment
590: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''FA_COST_CTR'', application_column_name, NULL)) cost_crt_segment
887: ,xla_tb_definitions_b xtd
888: $l_from$
889: ,xla_transaction_entities_upg PARTITION (AP) xteu
890: ,xla_ae_lines PARTITION (AP) xal
891: ,gl_code_combinations gcc
892: ,( SELECT /*+ NO_MERGE*/ id_flex_num
893: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_BALANCING'', application_column_name, NULL)) balancing_segment
894: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_ACCOUNT'', application_column_name, NULL)) account_segment
895: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''FA_COST_CTR'', application_column_name, NULL)) cost_crt_segment
1122: ,:8 -- g_prog_appl_id
1123: ,:9 -- g_program_id
1124: ,sysdate
1125: FROM
1126: gl_code_combinations gcc
1127: ,xla_subledgers xsu
1128: ,xla_tb_defn_je_sources xjs
1129: ,xla_tb_defn_details xdd
1130: WHERE xdd.definition_code = :10
1507: ,gcc.segment29 segment29_to
1508: ,gcc.segment30 segment30_from
1509: ,gcc.segment30 segment30_to
1510: FROM xla_tb_defn_details tdd
1511: ,gl_code_combinations gcc
1512: WHERE tdd.definition_code = p_definition_code
1513: AND gcc.code_combination_id = tdd.code_combination_id;
1514:
1515: IF (C_LEVEL_STATEMENT >= g_log_level) THEN