APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_LEDGER_RELATIONSHIPS_V

Line 167: XLA_LEDGER_RELATIONSHIPS_V rs,

163:
164: CURSOR ledger_cur IS
165: SELECT DISTINCT opt.LEDGER_ID
166: FROM XLA_LEDGER_OPTIONS opt,
167: XLA_LEDGER_RELATIONSHIPS_V rs,
168: gl_ledgers gl
169: WHERE (p_ledger_id IS NULL OR opt.LEDGER_ID = p_ledger_id)
170: AND opt.APPLICATION_ID = p_application_id
171: AND opt.ENABLED_FLAG = 'Y'

Line 276: XLA_LEDGER_RELATIONSHIPS_V rs,

272: BEGIN
273: SELECT 'X'
274: INTO v_dummy
275: FROM XLA_LEDGER_OPTIONS opt,
276: XLA_LEDGER_RELATIONSHIPS_V rs,
277: gl_ledgers gl
278: WHERE opt.LEDGER_ID = p_ledger_id
279: AND opt.APPLICATION_ID = p_application_id
280: AND opt.ENABLED_FLAG = 'Y'

Line 579: FROM XLA_LEDGER_RELATIONSHIPS_V rs,

575: INTO v_mapping_flag
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

Line 687: FROM XLA_LEDGER_RELATIONSHIPS_V rs,

683: XLA_ENVIRONMENT_PKG.g_usr_id,
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

Line 794: XLA_LEDGER_RELATIONSHIPS_V rs,

790: FROM DUAL
791: WHERE EXISTS
792: (SELECT 'Ledger without access'
793: FROM XLA_LEDGER_OPTIONS opt,
794: XLA_LEDGER_RELATIONSHIPS_V rs,
795: GL_LEDGERS gld
796: WHERE opt.APPLICATION_ID = p_application_id
797: AND opt.ENABLED_FLAG = 'Y'
798: AND opt.MERGE_ACCT_OPTION_CODE <> 'NONE'

Line 4436: ,XLA_LEDGER_RELATIONSHIPS_V rs

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'
4440: AND rs.ledger_id = gld.ledger_id

Line 4486: ,XLA_LEDGER_RELATIONSHIPS_V rs

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'
4490: AND rs.ledger_id = gld.ledger_id

Line 4669: ,XLA_LEDGER_RELATIONSHIPS_V rs

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
4670: ,gl_ledgers gld
4671: WHERE ael.PARTY_ID = p_old_party_id
4672: AND (p_old_site_id IS NULL
4673: OR ael.PARTY_SITE_ID = p_old_site_id)

Line 4818: ,XLA_LEDGER_RELATIONSHIPS_V rs

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
4820: WHERE ael.PARTY_ID = p_old_party_id
4821: AND (p_old_site_id IS NULL
4822: OR ael.PARTY_SITE_ID = p_old_site_id)

Line 5218: FROM XLA_LEDGER_RELATIONSHIPS_V rs,

5214: AND ( g_use_ledger_security = 'N'
5215: OR (g_use_ledger_security = 'Y'
5216: AND NOT EXISTS
5217: (SELECT 'Ledger without access'
5218: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5219: XLA_LEDGER_OPTIONS lgopt2,
5220: gl_ledgers gld
5221: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
5222: AND rs.ledger_id = gld.ledger_id

Line 5457: FROM XLA_LEDGER_RELATIONSHIPS_V rs,

5453: v_array_rounding_rule_code,
5454: v_array_currency_code,
5455: v_array_mau,
5456: v_array_submit_transfer
5457: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5458: XLA_LEDGER_OPTIONS lgopt,
5459: FND_CURRENCIES fcu,
5460: GL_LEDGERS gld
5461: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'