[Home] [Help]
2812: FROM
2813: xla_ae_lines ael
2814: ,xla_ae_headers aeh
2815: ,xla_distribution_links xdl
2816: ,fnd_currencies fcu
2817: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2818: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2819: = nvl(p_old_site_id, -1)
2820: and nvl(ael.party_type_code , p_party_type) = p_party_type
2978: FROM
2979: xla_ae_lines ael
2980: ,xla_ae_headers aeh
2981: ,xla_distribution_links xdl
2982: ,fnd_currencies fcu
2983: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2984: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2985: = nvl(p_old_site_id, -1)
2986: and nvl(ael.party_type_code , p_party_type) = p_party_type
3306: FROM
3307: xla_ae_lines ael
3308: ,xla_ae_headers aeh
3309: ,xla_distribution_links xdl
3310: ,fnd_currencies fcu
3311: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3312: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
3313: = nvl(p_old_site_id, -1)
3314: and nvl(ael.party_type_code , p_party_type) = p_party_type
3492: FROM
3493: xla_ae_lines ael
3494: ,xla_ae_headers aeh
3495: ,xla_distribution_links xdl
3496: ,fnd_currencies fcu
3497: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3498: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
3499: = nvl(p_old_site_id, -1)
3500: and nvl(ael.party_type_code , p_party_type) = p_party_type
5620: v_array_mau,
5621: v_array_submit_transfer
5622: FROM XLA_LEDGER_RELATIONSHIPS_V rs,
5623: XLA_LEDGER_OPTIONS lgopt,
5624: FND_CURRENCIES fcu,
5625: GL_LEDGERS gld
5626: WHERE rs.RELATIONSHIP_ENABLED_FLAG = 'Y'
5627: AND rs.ledger_id = gld.ledger_id
5628: AND gld.complete_flag = 'Y'