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_GL_JI_GROUPS_V

Object Details

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

View Type

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

GCS_GL_JI_GROUPS_V retrieves a list of source and group id combinations from GL_INTERFACE and GL_INTERFACE_CONTROL. This information is used to get the information necessary for running Interface Data Transformer against GL_INTERFACE data.

[View Source]

Columns

Name	Datatype	Length	Comments
GROUP_ID	NUMBER	(15)	Specifies the group to which the line in the interface table belongs.
INTERFACE_TABLE_NAME	VARCHAR2	(30)	The interface table in which the data is stored.
USER_JE_SOURCE_NAME	VARCHAR2	(25)	The source of the line to be imported.
SET_OF_BOOKS_ID	NUMBER	(15)	The set of books to which this line should be imported.
REQUEST_ID	NUMBER	(15)	The request identifier, if journal import has already been requested for this line.

Query Text

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


SELECT GROUP_ID
,      INTERFACE_TABLE_NAME
,      USER_JE_SOURCE_NAME
,      SET_OF_BOOKS_ID
,      REQUEST_ID
FROM APPS.GCS_GL_JI_GROUPS_V;

Dependencies

[top of page]

APPS.GCS_GL_JI_GROUPS_V references the following:

APPS: GL_INTERFACE; GL_INTERFACE_CONTROL; GL_JE_SOURCES

APPS.GCS_GL_JI_GROUPS_V is not referenced by any database object