5917: xla_ae_lines_gt lgt
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
7149: FROM
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)
9668: decode( sign( trunc(nvl(xal.currency_conversion_date, xeg.transaction_date)) -
9669: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
9670: FROM xla_ae_lines_gt xal
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
9669: trunc(fc2.derive_effective)), -1, 'OTHER', 'EMU'), 'OTHER' ) primary_type
9670: FROM xla_ae_lines_gt xal
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) */
9670: FROM xla_ae_lines_gt xal
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 */
10513: END
10514: END
10515: FROM gl_daily_rates ra
10516: ,xla_ae_headers_gt xah
10517: ,FND_CURRENCIES fc
10518: ,FND_CURRENCIES fc1
10519: WHERE ra.conversion_date(+)=
10520: nvl(trunc(xal.currency_conversion_date), trunc(xah.accounting_date))
10521: AND ra.conversion_type (+)=
10514: END
10515: FROM gl_daily_rates ra
10516: ,xla_ae_headers_gt xah
10517: ,FND_CURRENCIES fc
10518: ,FND_CURRENCIES fc1
10519: WHERE ra.conversion_date(+)=
10520: nvl(trunc(xal.currency_conversion_date), trunc(xah.accounting_date))
10521: AND ra.conversion_type (+)=
10522: CASE l_ledger_attrs.array_ledger_type(i)