[Home] [Help]
4279:
4280: update xla_ae_lines_gt xalg
4281: set code_combination_id =
4282: (select code_combination_id
4283: from gl_code_combinations gcc
4284: where gcc.chart_of_accounts_id = xalg.ccid_coa_id
4285: and gcc.template_id is null
4286: and (gcc.segment1= xalg.segment1 or (gcc.segment1 is null and xalg.segment1 is null))
4287: and (gcc.segment2= xalg.segment2 or (gcc.segment2 is null and xalg.segment2 is null))
4476: ,decode(segment_code, 'SEGMENT28', to_value, gcc.segment28)
4477: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
4478: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4479: from xla_merge_seg_maps map
4480: ,gl_code_combinations gcc
4481: ,XLA_LEDGER_RELATIONSHIPS_V rs
4482: ,gl_ledgers gld
4483: where map.application_id = p_application_id
4484: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4526: where reversal_code in ('REBOOKING', 'TRANSFER_BALANCE')
4527: AND exists
4528: (select 1
4529: from xla_merge_seg_maps map
4530: ,gl_code_combinations gcc
4531: ,XLA_LEDGER_RELATIONSHIPS_V rs
4532: ,gl_ledgers gld
4533: where map.application_id = p_application_id
4534: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4706: ,decode(segment_code, 'SEGMENT28', to_value, gcc.segment28)
4707: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
4708: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4709: FROM xla_merge_seg_maps map
4710: ,gl_code_combinations gcc
4711: ,xla_ae_lines ael
4712: ,xla_ae_headers aeh
4713: ,XLA_PARTIAL_MERGE_TXNS xpmt
4714: ,XLA_LEDGER_RELATIONSHIPS_V rs
4856: ,decode(segment_code, 'SEGMENT28', to_value, gcc.segment28)
4857: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
4858: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4859: FROM xla_merge_seg_maps map
4860: ,gl_code_combinations gcc
4861: ,xla_ae_lines ael
4862: ,xla_ae_headers aeh
4863: ,XLA_LEDGER_RELATIONSHIPS_V rs
4864: ,gl_ledgers gld