APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_MERGE_SEG_MAPS

Line 442: FROM XLA_MERGE_SEG_MAPS_GT

438: -- Validate only one segment code is provided per application/ledger/COA
439: BEGIN
440: SELECT 'Y'
441: INTO v_dummy
442: FROM XLA_MERGE_SEG_MAPS_GT
443: HAVING COUNT(DISTINCT SEGMENT_CODE) > 1
444: GROUP BY APPLICATION_ID, LEDGER_ID, CHART_OF_ACCOUNTS_ID;
445: EXCEPTION
446: WHEN NO_DATA_FOUND THEN

Line 580: XLA_MERGE_SEG_MAPS_GT gt,

576: FROM DUAL
577: WHERE EXISTS
578: (SELECT 'X'
579: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
580: XLA_MERGE_SEG_MAPS_GT gt,
581: gl_ledgers gld
582: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
583: AND rs.ledger_id = gld.ledger_id
584: AND gld.complete_flag = 'Y'

Line 662: -- Populate the table XLA_MERGE_SEG_MAPS based on XLA_MERGE_SEG_MAPS_GT

658: , p_module => v_module);
659:
660: IF (v_mapping_flag = 'Y')
661: THEN
662: -- Populate the table XLA_MERGE_SEG_MAPS based on XLA_MERGE_SEG_MAPS_GT
663: -- for this current event/associated ledgers
664: trace( p_msg => 'Insert mapping rows'
665: , p_level => C_LEVEL_STATEMENT
666: , p_module => v_module);

Line 667: INSERT INTO XLA_MERGE_SEG_MAPS

663: -- for this current event/associated ledgers
664: trace( p_msg => 'Insert mapping rows'
665: , p_level => C_LEVEL_STATEMENT
666: , p_module => v_module);
667: INSERT INTO XLA_MERGE_SEG_MAPS
668: ( APPLICATION_ID, LEDGER_ID, SEGMENT_CODE, FROM_VALUE,
669: TO_VALUE, EVENT_ID, CHART_OF_ACCOUNTS_ID, CREATION_DATE,
670: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
671: LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE,

Line 688: XLA_MERGE_SEG_MAPS_GT gt,

684: XLA_ENVIRONMENT_PKG.g_login_id,
685: sysdate,
686: XLA_ENVIRONMENT_PKG.g_prog_appl_id
687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
688: XLA_MERGE_SEG_MAPS_GT gt,
689: GL_LEDGERS gl
690: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
691: AND rs.ledger_id = gl.ledger_id
692: AND gl.complete_flag = 'Y'

Line 703: || ' rows into XLA_MERGE_SEG_MAPS'

699: AND gt.LEDGER_ID = rs.LEDGER_ID;
700:
701: -- Log the number of rows inserted
702: trace( p_msg => 'Insert ' || SQL%ROWCOUNT
703: || ' rows into XLA_MERGE_SEG_MAPS'
704: , p_level => C_LEVEL_STATEMENT
705: , p_module => v_module);
706:
707: END IF; -- IF (v_mapping_flag = 'Y')

Line 4434: from xla_merge_seg_maps map

4430: ,decode(segment_code, 'SEGMENT27', to_value, gcc.segment27)
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

Line 4484: from xla_merge_seg_maps map

4480: )
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

Line 4664: FROM xla_merge_seg_maps map

4660: ,decode(segment_code, 'SEGMENT27', to_value, gcc.segment27)
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

Line 4814: FROM xla_merge_seg_maps map

4810: ,decode(segment_code, 'SEGMENT27', to_value, gcc.segment27)
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