APPS.XLA_MPA_ACCRUAL_RPRTG_PKG dependencies on XLA_AE_HEADERS

Line 78: FROM xla_ae_headers aeh

74: SELECT DISTINCT aeh.application_id APPLICATION_ID
75: ,xcl.entity_code ENTITY_CODE
76: ,xcl.event_class_code EVENT_CLASS_CODE
77: ,xatr.reporting_view_name REPORTING_VIEW_NAME
78: FROM xla_ae_headers aeh
79: ,xla_event_types_b xcl
80: ,xla_event_class_attrs xatr
81: WHERE xcl.application_id = aeh.application_id
82: AND xcl.event_type_code = aeh.event_type_code

Line 300: FROM xla_ae_headers xah

296: ,DECODE(xah.balance_type_code,''B''
297: ,xah.accounting_entry_status_code) BUDGET_B
298: ,DECODE(xah.balance_type_code,''E''
299: ,xah.accounting_entry_status_code) ENCUMBRANCE_B
300: FROM xla_ae_headers xah
301: ,xla_gl_ledgers_v xgl
302: ,xla_event_classes_tl xec
303: ,xla_event_types_b xet
304: ,xla_subledgers xls

Line 355: FROM xla_ae_headers xah

351: ,SUM(CASE WHEN xah.parent_ae_header_id IS NOT NULL
352: AND xah.parent_ae_line_num IS NULL THEN 1
353: ELSE 0
354: END) ACCRUAL_REVERSAL
355: FROM xla_ae_headers xah
356: ,xla_ae_lines xal
357: ,xla_gl_ledgers_v xgl
358: ,xla_subledgers xls
359: ,xla_lookups lk1

Line 382: ,XLA_AE_HEADERS XAH

378: ' SELECT ERR.MESSAGE_NUMBER ERROR_NO
379: ,ERR.ENCODED_MSG ERROR_MSG
380: ,ERR.AE_LINE_NUM LINE_NUM
381: FROM XLA_ACCOUNTING_ERRORS ERR
382: ,XLA_AE_HEADERS XAH
383: ,xla_subledgers XLS
384: WHERE err.ae_header_id = xah.ae_header_id
385: AND err.application_id = xah.application_id
386: AND xls.application_id = xah.application_id ';

Line 428: ' FROM xla_ae_headers xah

424: total_accted_debits
425: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
426: total_accted_credits ';
427: xla_mpa_accrual_rprtg_pkg.C_MPA_FROM_QUERY :=
428: ' FROM xla_ae_headers xah
429: ,xla_ae_lines xal
430: ,xla_events xae
431: ,xla_event_types_tl xet
432: ,xla_transaction_entities ent

Line 517: ' FROM xla_ae_headers xah

513: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
514: total_accted_credits ';
515:
516: xla_mpa_accrual_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=
517: ' FROM xla_ae_headers xah
518: ,xla_events xae
519: ,xla_event_types_tl xet
520: ,xla_event_classes_tl xec
521: ,xla_transaction_entities ent

Line 611: ' FROM xla_ae_headers xah

607: ,err.message_number error_number
608: ,err.encoded_msg error_message ';
609:
610: xla_mpa_accrual_rprtg_pkg.C_ERRORS_FROM_QUERY :=
611: ' FROM xla_ae_headers xah
612: ,xla_events xae
613: ,xla_event_types_tl xet
614: ,xla_event_classes_tl xec
615: ,xla_gl_ledgers_v gld