Table: CST_VALUE_REPORT_TEMP | Oracle EBS ETRM Search

Table: CST_VALUE_REPORT_TEMP 12.2.2

owner BOM·BOM - Bills of Material·3 columns

Temporary table used by inventory value report

BOM.CST_VALUE_REPORT_TEMP·Explore BOM module →

View: JA_CN_CODE_COMBINATION_V 12.1.1

FND - Application Object Library·9 columns

APPS.JA_CN_CODE_COMBINATION_V·↳ GL_CODE_COMBINATIONS·↳ GL_LEDGERS·Explore FND module →

Table: CST_VALUE_REPORT_TEMP 12.1.1

owner BOM·BOM - Bills of Material·3 columns

Temporary table used by inventory value report

BOM.CST_VALUE_REPORT_TEMP·Explore BOM module →

Table: JA_CN_COA_NA_EXCEPTIONS 12.1.1

owner JA·JA - Asia/Pacific Localizations·11 columns

The table 'JA_CN_COA_NA_EXCEPTIONS' stores natural accounts with invalid length. Each row includes column ACCOUNT_SEGMENT, which can identify one natural account.

JA.JA_CN_COA_NA_EXCEPTIONS·Explore JA module →

Table: JA_CN_ERROR_ACCOUNTS 12.1.1

owner JA·JA - Asia/Pacific Localizations·26 columns

JA_CN_ERROR_ACCOUNTS stores error accounts which has abnormal balances. The XML data template will read this table to export the error accounts if any.

JA.JA_CN_ERROR_ACCOUNTS·Explore JA module →

Table: JA_CN_COA_NA_EXCEPTIONS 12.2.2

owner JA·JA - Asia/Pacific Localizations·11 columns

The table 'JA_CN_COA_NA_EXCEPTIONS' stores natural accounts with invalid length. Each row includes column ACCOUNT_SEGMENT, which can identify one natural account.

JA.JA_CN_COA_NA_EXCEPTIONS·Explore JA module →

Table: AP_OPEN_ITEMS_REVAL_GT 12.2.2

owner AP·AP - Payables·29 columns

AP.AP_OPEN_ITEMS_REVAL_GT·Explore AP module →

Table: JA_CN_ACCOUNT_BALANCES_GT 12.1.1

owner JA·JA - Asia/Pacific Localizations·25 columns

JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat file.

JA.JA_CN_ACCOUNT_BALANCES_GT·Explore JA module →

Table: PA_UBR_UER_SUMM_ACCT 12.2.2 satellite-leaning

owner PA·PA - Projects·22 columns

The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue.

PA.PA_UBR_UER_SUMM_ACCT·Explore PA module →

Table: JA_CN_JOURNAL_LINES_REQ 12.1.1 standalone

owner JA·JA - Asia/Pacific Localizations·42 columns

The 'JA_CN_JOURNAL_LINES_REQ' table stores temporarily journal lines of current session, which itemized with information of related subsidiary accounts if any

JA.JA_CN_JOURNAL_LINES_REQ·Explore JA module →

Table: GL_RX_TRIAL_BALANCE_ITF 12.1.1 link

owner GL·GL - General Ledger·25 columns

Interface table for country-specific trial balance reports

GL.GL_RX_TRIAL_BALANCE_ITF·Explore GL module →

Table: GL_RX_TRIAL_BALANCE_ITF 12.2.2 link

owner GL·GL - General Ledger·25 columns

Interface table for country-specific trial balance reports

GL.GL_RX_TRIAL_BALANCE_ITF·Explore GL module →

Table: PA_UBR_UER_SUMM_ACCT 12.1.1 satellite-leaning

owner PA·PA - Projects·22 columns

The PA_UBR_UER_SUMM_ACCT table stores summary for Unbilled Receivable and Unearned Revenue.

PA.PA_UBR_UER_SUMM_ACCT·Explore PA module →

Table: JA_CN_ERROR_ACCOUNTS 12.2.2

owner JA·JA - Asia/Pacific Localizations·26 columns

JA_CN_ERROR_ACCOUNTS stores error accounts, which have abnormal balances. The XML data template 'Account Balance Export Exception Report' will read this table to export the error accounts if any.

JA.JA_CN_ERROR_ACCOUNTS·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES 12.1.1 standalone

owner JA·JA - Asia/Pacific Localizations·31 columns

The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.

JA.JA_CN_ACCOUNT_BALANCES·Explore JA module →

Table: JA_CN_JOURNAL_LINES 12.1.1 standalone

owner JA·JA - Asia/Pacific Localizations·39 columns

The 'JA_CN_JOURNAL_LINES' table stores GL journal lines with information of related subsidiary accounts if any.

JA.JA_CN_JOURNAL_LINES·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_POST_GT 12.1.1 standalone

owner JA·JA - Asia/Pacific Localizations·32 columns

The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency.

JA.JA_CN_ACCOUNT_BALANCES_POST_GT·Explore JA module →

Table: AX_BALANCES 12.1.1 link

owner AX·AX - Global Accounting Engine·25 columns

Subledger accounting balance information for control accounts

AX.AX_BALANCES·Explore AX module →

Table: AX_BALANCES 12.2.2 link

owner AX·AX - Global Accounting Engine·25 columns

Subledger accounting balance information for control accounts

AX.AX_BALANCES·Explore AX module →

View: JA_CN_ACCOUNT_BALANCES_V 12.1.1

FND - Application Object Library·33 columns

APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →

View: JA_CN_CODE_COMBINATION_V 12.2.2

FND - Application Object Library·34 columns

APPS.JA_CN_CODE_COMBINATION_V·↳ GL_CODE_COMBINATIONS·↳ GL_LEDGERS·Explore FND module →

Table: JA_CN_ACCOUNT_BALANCES 12.2.2 standalone

owner JA·JA - Asia/Pacific Localizations·61 columns

The table 'JA_CN_ACCOUNT_BALANCES_GT' is a global temporary table used by posting journal to balance.

JA.JA_CN_ACCOUNT_BALANCES·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_POST_GT 12.2.2 standalone

owner JA·JA - Asia/Pacific Localizations·62 columns

The table 'JA_CN_ACCOUNT_BALANCES' stores beginning balance, period net DR amount, period net CR amount and ending balance for nature account and subsidiary segments by period and currency.

JA.JA_CN_ACCOUNT_BALANCES_POST_GT·Explore JA module →

View: JA_CN_ACCOUNT_BALANCES_V 12.2.2

FND - Application Object Library·63 columns

APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore FND module →

Table: JA_CN_JOURNAL_LINES 12.2.2 standalone

owner JA·JA - Asia/Pacific Localizations·71 columns

The 'JA_CN_JOURNAL_LINES' table stores GL journal lines with information of related subsidiary accounts if any.

JA.JA_CN_JOURNAL_LINES·Explore JA module →

View: APFV_AP_INVOICE_LINES 12.2.2

AP - Payables·195 columns

Business View

APPS.APFV_AP_INVOICE_LINES·↳ AP_INVOICE_LINES_ALL·Explore AP module →

View: AP_INVOICE_LINES_V 12.2.2

AP - Payables·212 columns

APPS.AP_INVOICE_LINES_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS_ALL·↳ AP_INVOICES_ALL·Explore AP module →

View: JA_CN_ACCOUNT_BALANCES_V 12.2.2

JA - Asia/Pacific Localizations·63 columns

APPS.JA_CN_ACCOUNT_BALANCES_V·↳ JA_CN_ACCOUNT_BALANCES·Explore JA module →

Table: JA_CN_ACCOUNT_BALANCES_GT 12.2.2

owner JA·JA - Asia/Pacific Localizations·55 columns

JA_CN_ACCOUNT_BALANCES_GT is a session level global temporary table which stores combined account balances before they are exported to flat file.

JA.JA_CN_ACCOUNT_BALANCES_GT·Explore JA module →

Table: JA_CN_JOURNAL_LINES_REQ 12.2.2 standalone

owner JA·JA - Asia/Pacific Localizations·74 columns

The 'JA_CN_JOURNAL_LINES_REQ' table stores temporarily journal lines of current session, which itemized with information of related subsidiary accounts if any

JA.JA_CN_JOURNAL_LINES_REQ·Explore JA module →

View: AP_INVOICE_LINES_INTERFACE_V 12.2.2

AP - Payables·152 columns

APPS.AP_INVOICE_LINES_INTERFACE_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS·↳ AP_INVOICES_INTERFACE·Explore AP module →

View: AP_INVOICE_LINES_V 12.1.1

AP - Payables·212 columns

APPS.AP_INVOICE_LINES_V·↳ AP_AWT_GROUPS·↳ AP_DISTRIBUTION_SETS_ALL·↳ AP_INVOICES_ALL·Explore AP module →

Table: AP_INVOICE_LINES_INTERFACE 12.1.1 satellite-leaning

owner AP·AP - Payables·183 columns

Information used to create one or more invoice distributions

AP.AP_INVOICE_LINES_INTERFACE·Explore AP module →

Table: AP_INVOICE_LINES_INTERFACE 12.2.2 satellite-leaning