APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_MERGE_SEG_MAPS

Line 444: FROM XLA_MERGE_SEG_MAPS_GT

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

Line 585: XLA_MERGE_SEG_MAPS_GT gt,

581: FROM DUAL
582: WHERE EXISTS
583: (SELECT 'X'
584: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
585: XLA_MERGE_SEG_MAPS_GT gt,
586: gl_ledgers gld
587: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
588: AND rs.ledger_id = gld.ledger_id
589: AND gld.complete_flag = 'Y'

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

665:
666:
667: IF (v_mapping_flag = 'Y')
668: THEN
669: -- Populate the table XLA_MERGE_SEG_MAPS based on XLA_MERGE_SEG_MAPS_GT
670: -- for this current event/associated ledgers
671: trace( p_msg => 'Insert mapping rows'
672: , p_level => C_LEVEL_STATEMENT
673: , p_module => v_module);

Line 674: INSERT INTO XLA_MERGE_SEG_MAPS

670: -- for this current event/associated ledgers
671: trace( p_msg => 'Insert mapping rows'
672: , p_level => C_LEVEL_STATEMENT
673: , p_module => v_module);
674: INSERT INTO XLA_MERGE_SEG_MAPS
675: ( APPLICATION_ID, LEDGER_ID, SEGMENT_CODE, FROM_VALUE,
676: TO_VALUE, EVENT_ID, CHART_OF_ACCOUNTS_ID, CREATION_DATE,
677: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
678: LAST_UPDATE_LOGIN, PROGRAM_UPDATE_DATE,

Line 695: XLA_MERGE_SEG_MAPS_GT gt,

691: XLA_ENVIRONMENT_PKG.g_login_id,
692: sysdate,
693: XLA_ENVIRONMENT_PKG.g_prog_appl_id
694: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
695: XLA_MERGE_SEG_MAPS_GT gt,
696: GL_LEDGERS gl
697: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
698: AND rs.ledger_id = gl.ledger_id
699: AND gl.complete_flag = 'Y'

Line 710: || ' rows into XLA_MERGE_SEG_MAPS'

706: AND gt.LEDGER_ID = rs.LEDGER_ID;
707:
708: -- Log the number of rows inserted
709: trace( p_msg => 'Insert ' || SQL%ROWCOUNT
710: || ' rows into XLA_MERGE_SEG_MAPS'
711: , p_level => C_LEVEL_STATEMENT
712: , p_module => v_module);
713:
714: END IF; -- IF (v_mapping_flag = 'Y')

Line 4479: from xla_merge_seg_maps map

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

Line 4529: from xla_merge_seg_maps map

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

Line 4709: FROM xla_merge_seg_maps map

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

Line 4859: FROM xla_merge_seg_maps map

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