DBA Data[Home] [Help]

APPS.XLA_DATAFIXES_PUB dependencies on XLA_GL_LEDGERS_V

Line 291: FROM xla_gl_ledgers_v xgl

287: SELECT xgl.currency_code, xsu.je_source_name,
288: xah.entity_id, xah.accounting_date,
289: xah.ledger_id, e.legal_entity_id, xah.accrual_reversal_flag,
290: xe.budgetary_control_flag
291: FROM xla_gl_ledgers_v xgl
292: , xla_ae_headers xah
293: , xla_subledgers xsu
294: , xla_transaction_entities e
295: , xla_events xe

Line 314: l_functional_curr xla_gl_ledgers_v.currency_code%TYPE;

310: AND xah2.event_id = p_event_id
311: AND xah2.accounting_entry_status_code = C_STATUS_FINAL_CODE
312: AND NVL(xah2.gl_transfer_status_code,'N') IN ('N','NT')); -- can be reversed only if it is transferred
313:
314: l_functional_curr xla_gl_ledgers_v.currency_code%TYPE;
315: l_je_source_name xla_subledgers.je_source_name%TYPE;
316: l_entity_id INTEGER;
317: l_pri_ae_header_id INTEGER;
318: l_pri_gl_date DATE;

Line 390: FROM xla_gl_ledgers_v xgl

386:
387: /* Bug 7011889 - Bulk collecting header ids into an array */
388:
389: SELECT xah.ae_header_id BULK COLLECT INTO l_array_je_header_id
390: FROM xla_gl_ledgers_v xgl
391: , xla_ae_headers xah
392: , xla_subledgers xsu
393: , xla_transaction_entities e
394: , xla_events xe