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: XLA.XLA_HISTORIC_CONTROL

Object Details

Object Name:	XLA_HISTORIC_CONTROL
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_HISTORIC_CONTROL
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length
PRIMARY_LEDGER	NUMBER
SECONDARY_ALC_LEDGER	NUMBER
APPLICATION_ID	NUMBER
UPGRADE_ID	NUMBER
RELATIONSHIP_ID	NUMBER
SCRIPT_NAME	VARCHAR2	(100)
START_DATE	DATE
END_DATE	DATE
BATCH_SIZE	NUMBER
NUM_WORKERS	NUMBER
STATUS	VARCHAR2	(100)
LEDGER_CATEGORY_CODE	VARCHAR2	(30)
LAST_UPDATE_DATE	DATE
PRIMARY_CURRENCY_CODE	VARCHAR2	(15)
SEC_ALC_CURRENCY_CODE	VARCHAR2	(15)
SEC_ALC_MAU	NUMBER
SEC_ALC_PRECISION	NUMBER
CONVERSION_OPTION	VARCHAR2	(10)
CURRENCY_CONVERSION_TYPE	VARCHAR2	(100)
CURRENCY_CONVERSION_DATE	DATE
PRIMARY_SLAM	VARCHAR2	(100)
PRIMARY_COA	NUMBER
PRIMARY_SLAM_TYPE	VARCHAR2	(10)
PRIMARY_AAD	VARCHAR2	(100)
PRIMARY_AAD_OWNER	VARCHAR2	(10)
SECONDARY_SLAM	VARCHAR2	(100)
SECONDARY_COA	NUMBER
SECONDARY_SLAM_TYPE	VARCHAR2	(10)
SECONDARY_AAD	VARCHAR2	(100)
SECONDARY_AAD_OWNER	VARCHAR2	(10)
MAPPING_RELATIONSHIP_ID	NUMBER
COA_MAPPING_NAME	VARCHAR2	(50)
PRIMARY_CAL_SET_NAME	VARCHAR2	(100)
PRIMARY_CAL_PER_TYPE	VARCHAR2	(100)
PRIMARY_SEC_ALC_SET_NAME	VARCHAR2	(100)
PRIMARY_SEC_ALC_PER_TYPE	VARCHAR2	(100)
DYNAMIC_INSERTS	VARCHAR2	(10)
SEC_ALC_MIN_ACCTNG_BATCH_ID	NUMBER
PARENT_REQUEST_ID	NUMBER

Query Text

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


SELECT PRIMARY_LEDGER
,      SECONDARY_ALC_LEDGER
,      APPLICATION_ID
,      UPGRADE_ID
,      RELATIONSHIP_ID
,      SCRIPT_NAME
,      START_DATE
,      END_DATE
,      BATCH_SIZE
,      NUM_WORKERS
,      STATUS
,      LEDGER_CATEGORY_CODE
,      LAST_UPDATE_DATE
,      PRIMARY_CURRENCY_CODE
,      SEC_ALC_CURRENCY_CODE
,      SEC_ALC_MAU
,      SEC_ALC_PRECISION
,      CONVERSION_OPTION
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_DATE
,      PRIMARY_SLAM
,      PRIMARY_COA
,      PRIMARY_SLAM_TYPE
,      PRIMARY_AAD
,      PRIMARY_AAD_OWNER
,      SECONDARY_SLAM
,      SECONDARY_COA
,      SECONDARY_SLAM_TYPE
,      SECONDARY_AAD
,      SECONDARY_AAD_OWNER
,      MAPPING_RELATIONSHIP_ID
,      COA_MAPPING_NAME
,      PRIMARY_CAL_SET_NAME
,      PRIMARY_CAL_PER_TYPE
,      PRIMARY_SEC_ALC_SET_NAME
,      PRIMARY_SEC_ALC_PER_TYPE
,      DYNAMIC_INSERTS
,      SEC_ALC_MIN_ACCTNG_BATCH_ID
,      PARENT_REQUEST_ID
FROM XLA.XLA_HISTORIC_CONTROL;

Dependencies

[top of page]

XLA.XLA_HISTORIC_CONTROL does not reference any database object

XLA.XLA_HISTORIC_CONTROL is referenced by following:

XLA: XLA_HISTORIC_CONTROL#