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: GL.GL_IMP_COA_SEG_VAL_INTERFACE

Object Details

Object Name:	GL_IMP_COA_SEG_VAL_INTERFACE
Object Type:	TABLE
Owner:	GL
FND Design Data:	SQLGL.GL_IMP_COA_SEG_VAL_INTERFACE
Subobject Name:
Status:	VALID

Interface table to capture data for the import of Chart of Accounts Segment Values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GL_IMP_COA_SEG_VAL_INT_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VALUE_SET_NAME FLEX_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NUMBER	VARCHAR2	(40)	Yes	Identifier to identify the set of records to be processed
SEG_VAL_INT_ID	NUMBER	(15)	Yes	Sequence generated unique identifier for the Chart of Accounts Segment Values.
VALUE_SET_NAME	VARCHAR2	(150)	Yes	Value set name to which segment value need to be added or updated
FLEX_VALUE	VARCHAR2	(150)	Yes	Segment value.
FLEX_DESC	VARCHAR2	(240)		Segment value description
PARENT_FLEX_VALUE	VARCHAR2	(60)		Parent flexfield value, if the value is being added to a dependent value set.
SUMMARY_FLAG	VARCHAR2	(1)		Parent value flag
ROLL_UP_GROUP	VARCHAR2	(30)		Rollup group Name, if the value is a parent value.
HIERARCHY_LEVEL	VARCHAR2	(30)		Hierarchy level
ALLOW_BUDGETING	VARCHAR2	(1)		Allow budgeting segment value qualifier
ALLOW_POSTING	VARCHAR2	(1)		Allow posting segment value qualifier
ACCOUNT_TYPE	VARCHAR2	(1)		Account Type segment value qualifier
RECONCILE	VARCHAR2	(1)		Reconcile segment value qualifier
THIRD_PARTY_CONTROL_ACCOUNT	VARCHAR2	(1)		Third Party Control Account segment value qualifier
ENABLED_FLAG	VARCHAR2	(1)		Enabled Flag
EFFECTIVE_FROM	DATE			Effective start date for the segment value
EFFECTIVE_TO	DATE			Effective end date for the segment value
STATUS	VARCHAR2	(1)		Processing status for interface line. Initially populate with value 'N'

Query Text

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


SELECT BATCH_NUMBER
,      SEG_VAL_INT_ID
,      VALUE_SET_NAME
,      FLEX_VALUE
,      FLEX_DESC
,      PARENT_FLEX_VALUE
,      SUMMARY_FLAG
,      ROLL_UP_GROUP
,      HIERARCHY_LEVEL
,      ALLOW_BUDGETING
,      ALLOW_POSTING
,      ACCOUNT_TYPE
,      RECONCILE
,      THIRD_PARTY_CONTROL_ACCOUNT
,      ENABLED_FLAG
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      STATUS
FROM GL.GL_IMP_COA_SEG_VAL_INTERFACE;

Dependencies

[top of page]

GL.GL_IMP_COA_SEG_VAL_INTERFACE does not reference any database object

GL.GL_IMP_COA_SEG_VAL_INTERFACE is referenced by following:

GL: GL_IMP_COA_SEG_VAL_INTERFACE#