DBA Data[Home] [Help]

APPS.XLA_AE_LINES_PKG dependencies on FND_CURRENCIES

Line 5921: ,fnd_currencies fcu

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

Line 7153: ,fnd_currencies fcu

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)

Line 9672: ,fnd_currencies fc

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

Line 9673: ,fnd_currencies fc1

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) */

Line 9674: ,fnd_currencies fc2

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 */

Line 10517: ,FND_CURRENCIES fc

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 (+)=

Line 10518: ,FND_CURRENCIES fc1

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)