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.GCS_CATEGORIES_VL

Object Details

Object Name:	GCS_CATEGORIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GCS.GCS_CATEGORIES_VL
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

GCS_CATEGORIES_VL is the view for selecting data from multilingual entity GCS_CATEGORIES

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CATEGORY_CODE	VARCHAR2	(80)	Yes	Category defining column
GL_CATEGORY_CODE	VARCHAR2	(30)		General Ledger Category Code
CATEGORY_NUMBER	NUMBER	(15)	Yes	Category Sequence Number
NET_TO_RE_FLAG	VARCHAR2	(1)	Yes	Net to Retained Earnings
TARGET_ENTITY_CODE	VARCHAR2	(30)	Yes	Target Entity for Category
CATEGORY_TYPE_CODE	VARCHAR2	(30)	Yes	Category Type
ASSOCIATED_OBJECT_ID	NUMBER		Yes	Foreign key to Object Dimension defining column
ORG_OUTPUT_CODE	VARCHAR2	(30)		Organization Output Option ('CHILD_BASE_ORG', 'BASE_ORG')
SUPPORT_MULTI_PARENTS_FLAG	VARCHAR2	(1)	Yes	Support multi parents
ENABLED_FLAG	VARCHAR2	(1)	Yes	Category enabled
SPECIFIC_INTERCOMPANY_ID	NUMBER			Specific intercompany
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Standard Who Column
CATEGORY_NAME	VARCHAR2	(80)	Yes	Category Name
DESCRIPTION	VARCHAR2	(240)		Description

Query Text

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


SELECT CATEGORY_CODE
,      GL_CATEGORY_CODE
,      CATEGORY_NUMBER
,      NET_TO_RE_FLAG
,      TARGET_ENTITY_CODE
,      CATEGORY_TYPE_CODE
,      ASSOCIATED_OBJECT_ID
,      ORG_OUTPUT_CODE
,      SUPPORT_MULTI_PARENTS_FLAG
,      ENABLED_FLAG
,      SPECIFIC_INTERCOMPANY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      CATEGORY_NAME
,      DESCRIPTION
FROM APPS.GCS_CATEGORIES_VL;

Dependencies

[top of page]

APPS.GCS_CATEGORIES_VL references the following:

APPS: GCS_CATEGORIES_B; GCS_CATEGORIES_TL

APPS.GCS_CATEGORIES_VL is not referenced by any database object