XLA Views (165)

XLA - Subledger Accounting — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
XLA_AAD_HDR_ACCT_ATTRS_FVL
XLA_AAD_HEADER_AC_ASSGNS_F_V
XLA_AAD_LINE_DEFN_ASSGNS_F_V
XLA_ACCTG_METHODS_FVL
XLA_ACCTG_METHODS_VL The view XLA_ACCTG_METHODS_VL returns translated information about accounting method definition.
XLA_ACCTG_METHOD_RULES_FVL
XLA_ACCT_ATTRIBUTES_VL
XLA_ACCT_CLASS_ASSGNS_F_V
XLA_ACCT_LINE_TYPES_FVL
XLA_ACCT_LINE_TYPES_VL
XLA_ACCT_PROG_SEQ_V This view is used in assigning the completion based sequence numbers to the journal entries generated during a run of accounting program.
XLA_AEL_GL_V
XLA_AEL_SL_V
XLA_AE_HDR_DTL_VALS_V
XLA_AE_HEADERS_V
XLA_AE_LINE_DTL_VALS_V
XLA_ALT_CURR_LEDGERS_V
XLA_ANALYTICAL_ASSGNS_FVL
XLA_ANALYTICAL_DTLS_VL
XLA_ANALYTICAL_HDRS_VL
XLA_APPLICATIONS_V This view returns untranslated information related to application set with XLA.
XLA_APPLICATIONS_XVL This view returns translated information related to application set with XLA.
XLA_AP_AEL_SL_V
XLA_AP_INV_AEL_GL_V
XLA_AP_INV_AEL_SL_V
XLA_AP_PAY_AEL_GL_V
XLA_AP_PAY_AEL_SL_V
XLA_AR_ADJ_AEL_GL_V
XLA_AR_ADJ_AEL_SL_MRC_V
XLA_AR_ADJ_AEL_SL_V
XLA_AR_CB_REC_AEL_SL_V
XLA_AR_INV_AEL_GL_V
XLA_AR_INV_AEL_SL_MRC_V
XLA_AR_INV_AEL_SL_V
XLA_AR_REC_AEL_GL_V
XLA_AR_REC_AEL_SL_MRC_V
XLA_AR_REC_AEL_SL_V
XLA_ASSIGNMENT_DEFNS_F_V
XLA_ASSIGNMENT_DEFNS_VL
XLA_DESCRIPTIONS_FVL
XLA_DESCRIPTIONS_VL
XLA_DESCRIPT_DETAILS_FVL
XLA_DESCRIPT_DETAILS_VL
XLA_DIAG_LINES_V This view retrieves the different extract line numbers for an event identifier stored in XLA_DIAG_SOURCES. This view is defined for the XLA_
XLA_DIAG_NUMBERS_V This view retrieves the different transaction numbers for an event stored in XLA_DIAG_EVENTS table. This view is defined for the XLA_DIAG_TR
XLA_DIAG_REQUESTS_V This view retrieves the different Accounting program request identifiers from the XLA_DIAG_LEDGERS table. This view is used by the Transacti
XLA_ENTITY_EVENTS_V
XLA_ENTITY_TYPES_FVL
XLA_ENTITY_TYPES_VL
XLA_EVENT_CLASSES_FVL The view XLA_EVENT_CLASSES_FVL returns entity name and user je category name for the entity code and je category name selected.
XLA_EVENT_CLASSES_VL
XLA_EVENT_CLASS_ATTRS_FVL
XLA_EVENT_CLASS_GRPS_VL
XLA_EVENT_CLASS_PREDECS_F_V View created to pick up columns from xla_event_class_predecs table and additonal columns to be shown on the form.
XLA_EVENT_MAPPINGS_VL
XLA_EVENT_SOURCES_FVL
XLA_EVENT_TYPES_VL
XLA_EVT_CLASS_ACCT_ATTRS_FVL
XLA_EXTRACT_OBJECTS_V
XLA_FA_AEL_GL_V
XLA_FA_AEL_SL_MRC_V
XLA_FA_AEL_SL_V
XLA_FV_BE_GL_V
XLA_FV_PYA_GL_V
XLA_FV_TC_GL_V
XLA_GL_JE_AEL_V
XLA_GL_LEDGERS_V
XLA_GL_TRANSFER_BATCHES
XLA_INV_AEL_GL_PAC_V
XLA_INV_AEL_GL_V
XLA_INV_AEL_SL_PAC_V
XLA_INV_AEL_SL_V
XLA_JE_CATEGORIES_VL View displays a list of journal categories that are translated.
XLA_JE_SOURCES_VL
XLA_JLT_ACCT_ATTRS_FVL
XLA_JL_BR_AR_BT_AEL_GL_V
XLA_JL_BR_AR_BT_AEL_SL_V
XLA_JL_FA_AEL_GL_V
XLA_JL_FA_AEL_SL_V
XLA_LEDGER_RELATIONSHIPS_V
XLA_LINE_DEFINITIONS_F_V
XLA_LINE_DEFINITIONS_VL
XLA_LINE_DEFN_AC_ASSGNS_F_V
XLA_LINE_DEFN_ADR_ASSGNS_F_V
XLA_LINE_DEFN_JLT_ASSGNS_F_V
XLA_LOOKUPS
XLA_MAPPING_SETS_FVL
XLA_MAPPING_SETS_VL
XLA_MO_REPORTING_ENTITIES_V
XLA_MO_REPORTING_ENT_MRC_V
XLA_MPA_HEADER_AC_ASSGNS_F_V Internal form view for the xla_mpa_header_ac_assgns table.
XLA_MPA_JLT_AC_ASSGNS_F_V Internal form view for the xla_mpa_header_ac_assgns table
XLA_MPA_JLT_ADR_ASSGNS_F_V Internal form view for the xla_mpa_jlt_adr_assgns table
XLA_MPA_JLT_ASSGNS_F_V Internal form view for the xla_mpa_jlt_ac_assgns table
XLA_OKL_AEL_GL_AST_V
XLA_OKL_AEL_GL_CTR_V
XLA_OKL_AEL_GL_QTE_V
XLA_OKL_AEL_GL_TRX_V
XLA_OKL_AEL_SL_V
XLA_OZF_CLA_AEL_GL_V
XLA_OZF_CLA_AEL_SL_V
XLA_OZF_UTL_AEL_GL_V
XLA_OZF_UTL_AEL_SL_V
XLA_PAD_INQ_HEADERS_AC_FVL
XLA_PAD_INQ_HEADERS_FVL
XLA_PAD_INQ_LINES_AC_AF_FVL
XLA_PAD_INQ_LINES_AC_FVL
XLA_PAD_INQ_LINES_AC_SD_FVL
XLA_PAD_INQ_LINES_AC_SS_FVL
XLA_PAD_INQ_LINES_AF_FVL
XLA_PAD_INQ_LINES_AF_SD_FVL
XLA_PAD_INQ_LINES_FVL
XLA_PAD_INQ_LINES_SD_FVL
XLA_PAD_INQ_LINES_SS_FVL
XLA_PAD_INQ_LINES_SUB_FVL
XLA_PAD_INQ_SEG_RULES_FVL
XLA_PA_AEL_DR_MRC_GL_V
XLA_PA_AEL_EI_MRC_GL_V
XLA_PA_DR_AEL_GL_V
XLA_PA_DR_AEL_SL_MRC_V
XLA_PA_DR_AEL_SL_V
XLA_PA_EI_AEL_GL_V
XLA_PA_EI_AEL_SL_MRC_V
XLA_PA_EI_AEL_SL_V
XLA_POST_ACCTG_EVENTS_V
XLA_POST_ACCT_PROGS_F_V
XLA_POST_ACCT_PROGS_VL
XLA_PO_AEL_GL_PAC_V
XLA_PO_AEL_GL_V
XLA_PO_AEL_SL_MRC_V
XLA_PO_AEL_SL_PAC_V
XLA_PO_AEL_SL_V
XLA_PO_ENC_AEL_GL_V
XLA_PRODUCT_RULES_FVL
XLA_PRODUCT_RULES_VL
XLA_PROD_ACCT_HEADERS_FVL
XLA_PROD_ACCT_LINES_FVL
XLA_PROD_HEADER_DESC_FVL
XLA_PROD_SEG_RULES_FVL
XLA_PSA_AP_INV_BC_GL_V
XLA_PSA_BC_LINES_V
XLA_PSA_PO_ENC_BC_GL_V
XLA_PSA_REQ_ENC_BC_GL_V
XLA_REFERENCE_OBJECTS_F_V This is the base view of the Reference Objects region of the Accounting Event Class Options form.
XLA_REQ_ENC_AEL_GL_V
XLA_SEG_RULES_FVL
XLA_SEG_RULES_VL
XLA_SOURCES_ASSIGNABLE_V
XLA_SOURCES_ASSIGNABLE_XVL
XLA_SOURCES_AVAILABLE_V
XLA_SOURCES_AVAILABLE_XVL
XLA_SOURCES_FVL
XLA_SOURCES_VL
XLA_SUBLEDGERS_FVL
XLA_SUBLEDGER_OPTIONS_V
XLA_TAB_ACCT_DEFS_VL
XLA_TAB_ACCT_TYPES_VL
XLA_TACCOUNTS_V
XLA_TB_DEFINITIONS_VL
XLA_THIRD_PARTIES_V Third party id, third party type and third party number information
XLA_THIRD_PARTY_SITES_V third party site information
XLA_WIP_AEL_GL_PAC_V
XLA_WIP_AEL_GL_V
XLA_WIP_AEL_SL_PAC_V
XLA_WIP_AEL_SL_V