DBA Data[Home] [Help] [Dependency Information]

TABLE: APPLSYS.FND_DATA_GROUPS

Object Details
Object Name: FND_DATA_GROUPS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.FND_DATA_GROUPS
Subobject Name:
Status: VALID


FND_DATA_GROUPS stores information about different data groups.
Each row includes a data group identifier, a data group name,
and a flag that indicates if the data group is created during
install or upgrade. You need one row for each data
group that you define using Oracle Application Object Library.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 5
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FND_DATA_GROUPS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDATA_GROUP_ID
FND_DATA_GROUPS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnDATA_GROUP_NAME
Columns
Name Datatype Length Mandatory Comments
DATA_GROUP_ID NUMBER (15) Yes Data group identifier
DATA_GROUP_NAME VARCHAR2 (30) Yes Data group name
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
DEFAULT_GROUP_FLAG VARCHAR2 (1) Yes Flag to indicate whether this is an Oracle Application defined data group
DESCRIPTION VARCHAR2 (240)
Description
Query Text

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


SELECT DATA_GROUP_ID
,      DATA_GROUP_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DEFAULT_GROUP_FLAG
,      DESCRIPTION
FROM APPLSYS.FND_DATA_GROUPS;

Dependencies

[top of page]

APPLSYS.FND_DATA_GROUPS does not reference any database object

APPLSYS.FND_DATA_GROUPS is referenced by following:

SchemaAPPS
SynonymFND_DATA_GROUPS