[Home] [Help]
5918: ,xla_distribution_links xdl
5919: ,xla_ae_lines ael
5920: ,xla_ae_headers aeh
5921: ,fnd_currencies fcu
5922: ,xla_events evt
5923: WHERE lgt.reversal_code = 'DUMMY_LR'
5924: AND xdl.application_id = l_application_id
5925: AND xdl.source_distribution_type = lgt.reverse_distribution_type
5926: AND xdl.source_distribution_id_num_1 = nvl(lgt.reverse_dist_id_num_1,-99)
6810: FROM
6811: xla_ae_lines_gt lgt
6812: ,xla_ae_lines ael
6813: ,xla_ae_headers aeh
6814: ,xla_events xet -- 5262950
6815: WHERE aeh.application_id = l_application_id
6816: AND lgt.reversal_code = 'DUMMY_TR'
6817: AND xet.application_id = l_application_id -- 5262950
6818: AND xet.entity_id = lgt.entity_id -- 5262950
7150: xla_ae_lines ael
7151: ,xla_ae_headers aeh
7152: ,xla_distribution_links xdl
7153: ,fnd_currencies fcu
7154: ,xla_events xe
7155: WHERE aeh.application_id = l_application_id
7156: AND aeh.ledger_id = l_array_ledger_id(i)
7157: AND aeh.entity_id = l_array_entity_id(i)
7158: -- AND aeh.event_number < l_array_event_number(i)
9671: ,gl_ledgers gl
9672: ,fnd_currencies fc
9673: ,fnd_currencies fc1
9674: ,fnd_currencies fc2
9675: ,xla_events_gt xeg
9676: WHERE xal.ledger_id = gl.ledger_id
9677: AND gl.object_type_code = 'L' /* only ledgers (not ledger sets) */
9678: AND gl.le_ledger_type_code = 'L' /* only legal ledgers */
9679: AND xal.currency_code <> gl.currency_code
10021: AND (xal.currency_conversion_type = l_array_conversion_type(i)
10022: or (xal.currency_conversion_type is null and l_array_conversion_type(i) is null))
10023: AND l_array_conversion_date(i) =
10024: (select TRUNC(nvl(xal.currency_conversion_date, xeg.transaction_date))
10025: from xla_events_gt xeg
10026: where xal.event_id = xeg.event_id)
10027: AND decode(currency_conversion_type, 'User', currency_conversion_rate, -1) = l_array_conversion_rate(i)
10028: AND nvl(xal.reversal_code,'dd') <> C_DUMMY_PRIOR
10029: ;