Table: JA_CN_ERROR_ACCOUNTS | Oracle EBS ETRM Search

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_JOURNAL_LINES_GT 12.1.1

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

JA_CN_JOURNAL_LINES_GT is a session level global temporary table which stores combined journal lines before they are exported to flat file. The reason to create this temporary is that according to the logic of procedure run_export, the jour

JA.JA_CN_JOURNAL_LINES_GT·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_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: 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 →

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 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 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_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 →

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 →

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_JOURNAL_LINES_GT 12.2.2

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

JA_CN_JOURNAL_LINES_GT is a session level global temporary table which stores combined journal lines before they are exported to flat file. The reason to create this temporary is that according to the logic of procedure run_export, the jour

JA.JA_CN_JOURNAL_LINES_GT·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 →

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: JA.JA_CN_ERROR_ACCOUNTS# 12.2.2

APPS.JA_CN_AB_EXP_PKG SQL Statements 12.1.1

APPS.JA_CN_AB_EXP_PKG SQL Statements 12.2.2

VIEW: JA.JA_CN_ERROR_ACCOUNTS# 12.2.2

owner JA

VIEW: JA.JA_CN_ACCOUNT_BALANCES# 12.2.2

TABLE: JA.JA_CN_ACCOUNT_BALANCES_GT 12.1.1

owner JA

VIEW: JA.JA_CN_JOURNAL_LINES# 12.2.2

VIEW: JA.JA_CN_JOURNAL_LINES_REQ# 12.2.2

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.1.1

APPS.JA_CN_POST_UTILITY_PKG SQL Statements 12.1.1

TABLE: JA.JA_CN_ACCOUNT_BALANCES 12.1.1

owner JA

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.2.2

VIEW: JA.JA_CN_ACCOUNT_BALANCES# 12.2.2

owner JA

TABLE: JA.JA_CN_ERROR_ACCOUNTS 12.1.1

owner JA

VIEW: JA.JA_CN_JOURNAL_LINES# 12.2.2

owner JA

VIEW: JA.JA_CN_JOURNAL_LINES_REQ# 12.2.2

owner JA

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG SQL Statements 12.1.1

TABLE: JA.JA_CN_ERROR_ACCOUNTS 12.2.2

owner JA

TABLE: JA.JA_CN_ACCOUNT_BALANCES 12.2.2

owner JA

TABLE: JA.JA_CN_JOURNAL_LINES_REQ 12.1.1

owner JA

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.1.1

APPS.JA_CN_POST_UTILITY_PKG SQL Statements 12.2.2

TABLE: JA.JA_CN_ACCOUNT_BALANCES_POST_GT 12.1.1

owner JA

TABLE: JA.JA_CN_JOURNAL_LINES_GT 12.1.1

owner JA

TABLE: JA.JA_CN_JOURNAL_LINES 12.1.1

owner JA

VIEW: APPS.JA_CN_ACCOUNT_BALANCES_V 12.2.2

TABLE: JA.JA_CN_ACCOUNT_BALANCES_GT 12.2.2

owner JA

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG SQL Statements 12.2.2

TABLE: JA.JA_CN_JOURNAL_LINES_GT 12.2.2

owner JA

PACKAGE BODY: APPS.JA_CN_POST_UTILITY_PKG 12.1.1

TABLE: JA.JA_CN_ACCOUNT_BALANCES_POST_GT 12.2.2

owner JA

TABLE: JA.JA_CN_JOURNAL_LINES 12.2.2

owner JA

PACKAGE BODY: APPS.JA_CN_AB_EXP_PKG 12.2.2

Results for “personnel_number”