[Home] [Help]
4234:
4235: update xla_ae_lines_gt xalg
4236: set code_combination_id =
4237: (select code_combination_id
4238: from gl_code_combinations gcc
4239: where gcc.chart_of_accounts_id = xalg.ccid_coa_id
4240: and gcc.template_id is null
4241: and (gcc.segment1= xalg.segment1 or (gcc.segment1 is null and xalg.segment1 is null))
4242: and (gcc.segment2= xalg.segment2 or (gcc.segment2 is null and xalg.segment2 is null))
4431: ,decode(segment_code, 'SEGMENT28', to_value, gcc.segment28)
4432: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
4433: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4434: from xla_merge_seg_maps map
4435: ,gl_code_combinations gcc
4436: ,XLA_LEDGER_RELATIONSHIPS_V rs
4437: ,gl_ledgers gld
4438: where map.application_id = p_application_id
4439: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4481: where reversal_code in ('REBOOKING', 'TRANSFER_BALANCE')
4482: AND exists
4483: (select 1
4484: from xla_merge_seg_maps map
4485: ,gl_code_combinations gcc
4486: ,XLA_LEDGER_RELATIONSHIPS_V rs
4487: ,gl_ledgers gld
4488: where map.application_id = p_application_id
4489: and rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
4661: ,decode(segment_code, 'SEGMENT28', to_value, gcc.segment28)
4662: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
4663: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4664: FROM xla_merge_seg_maps map
4665: ,gl_code_combinations gcc
4666: ,xla_ae_lines ael
4667: ,xla_ae_headers aeh
4668: ,XLA_PARTIAL_MERGE_TXNS xpmt
4669: ,XLA_LEDGER_RELATIONSHIPS_V rs
4811: ,decode(segment_code, 'SEGMENT28', to_value, gcc.segment28)
4812: ,decode(segment_code, 'SEGMENT29', to_value, gcc.segment29)
4813: ,decode(segment_code, 'SEGMENT30', to_value, gcc.segment30)
4814: FROM xla_merge_seg_maps map
4815: ,gl_code_combinations gcc
4816: ,xla_ae_lines ael
4817: ,xla_ae_headers aeh
4818: ,XLA_LEDGER_RELATIONSHIPS_V rs
4819: ,gl_ledgers gld