[Home] [Help]
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$
347: WHERE xah.ae_header_id BETWEEN :7 AND :8
565: ,xla_tb_defn_je_sources xjs
566: ,xla_subledgers xsu
567: ,xla_transaction_entities_upg PARTITION (AP) xteu
568: ,xla_ae_lines PARTITION (AP) xal
569: ,gl_code_combinations gcc
570: ,( SELECT /*+ NO_MERGE*/ id_flex_num
571: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_BALANCING'', application_column_name, NULL)) balancing_segment
572: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_ACCOUNT'', application_column_name, NULL)) account_segment
573: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''FA_COST_CTR'', application_column_name, NULL)) cost_crt_segment
855: ,xla_tb_defn_je_sources xjs
856: ,xla_subledgers xsu
857: ,xla_transaction_entities_upg PARTITION (AP) xteu
858: ,xla_ae_lines PARTITION (AP) xal
859: ,gl_code_combinations gcc
860: ,( SELECT /*+ NO_MERGE*/ id_flex_num
861: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_BALANCING'', application_column_name, NULL)) balancing_segment
862: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''GL_ACCOUNT'', application_column_name, NULL)) account_segment
863: ,MAX(DECODE(SEGMENT_ATTRIBUTE_TYPE, ''FA_COST_CTR'', application_column_name, NULL)) cost_crt_segment
1077: ,:8 -- g_prog_appl_id
1078: ,:9 -- g_program_id
1079: ,sysdate
1080: FROM
1081: gl_code_combinations gcc
1082: ,xla_subledgers xsu
1083: ,xla_tb_defn_je_sources xjs
1084: ,xla_tb_defn_details xdd
1085: WHERE xdd.definition_code = :10
1462: ,gcc.segment29 segment29_to
1463: ,gcc.segment30 segment30_from
1464: ,gcc.segment30 segment30_to
1465: FROM xla_tb_defn_details tdd
1466: ,gl_code_combinations gcc
1467: WHERE tdd.definition_code = p_definition_code
1468: AND gcc.code_combination_id = tdd.code_combination_id;
1469:
1470: IF (C_LEVEL_STATEMENT >= g_log_level) THEN