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]

VIEW: APPS.IGI_EER_MAP_V

Object Details

Object Name:	IGI_EER_MAP_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Key flexfield combination defining column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CHART_OF_ACCOUNTS_ID	NUMBER	(15)	Yes	Key flexfield structure defining column
DETAIL_POSTING_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Detail posting flag
DETAIL_BUDGETING_ALLOWED_FLAG	VARCHAR2	(1)	Yes	Detail budgeting flag
ACCOUNT_TYPE	VARCHAR2	(1)	Yes	Key flexfield combination type (Asset, Liability, etc)
ENABLED_FLAG	VARCHAR2	(1)	Yes	Key flexfield enabled flag
SUMMARY_FLAG	VARCHAR2	(1)	Yes	Summary account flag
LEVEL_1	VARCHAR2	(25)		Key flexfield segment
LEVEL_2	VARCHAR2	(25)		Key flexfield segment
LEVEL_3	VARCHAR2	(25)		Key flexfield segment
LEVEL_4	VARCHAR2	(25)		Key flexfield segment
LEVEL_5	VARCHAR2	(25)		Key flexfield segment
LEVEL_6	VARCHAR2	(25)		Key flexfield segment
BALANCING_SEGMENT	VARCHAR2	(0)		Balancing Segment
DESCRIPTION	VARCHAR2	(240)		Key flexfield description
TEMPLATE_ID	NUMBER	(15)		Summary template defining column
ALLOCATION_CREATE_FLAG	VARCHAR2	(1)		Not currently used
START_DATE_ACTIVE	DATE			Date before which key flexfield combination is invalid
END_DATE_ACTIVE	DATE			Date after which key flexfield combination is invalid

Query Text

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


SELECT CODE_COMBINATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CHART_OF_ACCOUNTS_ID
,      DETAIL_POSTING_ALLOWED_FLAG
,      DETAIL_BUDGETING_ALLOWED_FLAG
,      ACCOUNT_TYPE
,      ENABLED_FLAG
,      SUMMARY_FLAG
,      LEVEL_1
,      LEVEL_2
,      LEVEL_3
,      LEVEL_4
,      LEVEL_5
,      LEVEL_6
,      BALANCING_SEGMENT
,      DESCRIPTION
,      TEMPLATE_ID
,      ALLOCATION_CREATE_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
FROM APPS.IGI_EER_MAP_V;

Dependencies

[top of page]

APPS.IGI_EER_MAP_V references the following:

APPS: GL_CODE_COMBINATIONS

APPS.IGI_EER_MAP_V is not referenced by any database object