eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: JL.JL_CL_GL_ACCT_HIER_TMP

Object Details

Object Name:	JL_CL_GL_ACCT_HIER_TMP
Object Type:	TABLE
Owner:	JL
FND Design Data:	JL.JL_CL_GL_ACCT_HIER_TMP
Subobject Name:
Status:	VALID

JL_CL_GL_ACCT_HIER_TMP stores the account hierarchy for generating the Chilean General Ledger 8 Columns Trial Balance report. Every value associated with the value set for the account segment of the Accounting Key Flexfield for a specific set of books is copied into this table and the hierarchy level is updated. The balance amounts for a given period are populated for all the accounts.
BALANCE_DR stores balance as ADDITIONS_DR - ADDITIONS_CR, if ADDITIONS_DR >ADDITIONS_CR, else it stores zero. BALANCE_CR stores balance as ADDITIONS_CR - ADDITIONS_DR, if ADDITIONS_CR >ADDITIONS_DR, else it stores zero. INVENTORY_ASSET stores BALANCE_DR if account is Balance Sheet account, and INVENTORY_LIABILITY stores BALANCE_CR if account is Balance Sheet account. PNL_LOSS stores BALANCE_DR if account is Profit and Loss account, and PNL_GAIN stores BALANCE_CR if account is Profit and Loss account.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JL_CL_GL_ACCT_HIER_TMP_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	PARENT_VALUE CHILD_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
PARENT_VALUE	VARCHAR2	(60)	Yes	Flexfield segment value
CHILD_VALUE	VARCHAR2	(60)		Flexfield segment value
ACCOUNT_TYPE	VARCHAR2	(1)	Yes	Type of qualifier of the account: A-Asset, L-liability, O-Owner Equity, R-Revenue, and E-Expense
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Summary account flag that indicates if it's parent('Y') or child('N')
HIERARCHY_LEVEL	NUMBER	(15)		The rollup level of the account
FLEX_VALUE_SET_ID	NUMBER	(15)	Yes	Flexfield value set identifier
ADDITIONS_DR	NUMBER			Period year to date debit amount
ADDITIONS_CR	NUMBER			Period year to date credit amount
BALANCE_DR	NUMBER			Balance debit
BALANCE_CR	NUMBER			Balance credit
INVENTORY_ASSET	NUMBER			Balance debit for Inventory Asset
INVENTORY_LIABILITY	NUMBER			Balance credit for Inventory Liability
PNL_LOSS	NUMBER			Balance debit for Profit and Loss account
PNL_GAIN	NUMBER			Balance credit for Profit and Loss account
REPORTABLE_FLAG	VARCHAR2	(1)		Used for internal processing

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARENT_VALUE
,      CHILD_VALUE
,      ACCOUNT_TYPE
,      SUMMARY_FLAG
,      HIERARCHY_LEVEL
,      FLEX_VALUE_SET_ID
,      ADDITIONS_DR
,      ADDITIONS_CR
,      BALANCE_DR
,      BALANCE_CR
,      INVENTORY_ASSET
,      INVENTORY_LIABILITY
,      PNL_LOSS
,      PNL_GAIN
,      REPORTABLE_FLAG
FROM JL.JL_CL_GL_ACCT_HIER_TMP;

Dependencies

[top of page]

JL.JL_CL_GL_ACCT_HIER_TMP does not reference any database object

JL.JL_CL_GL_ACCT_HIER_TMP is referenced by following:

APPS: JL_CL_GL_ACCT_HIER_TMP