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: APPLSYS.FND_PRODUCT_GROUPS

Object Details

Object Name:	FND_PRODUCT_GROUPS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	AD.FND_PRODUCT_GROUPS
Subobject Name:
Status:	VALID

FND_PRODUCT_GROUPS stores information about what release, language and type of product group (for example, Standard or Demonstration) you have installed at your site. FND_PRODUCT_GROUPS also stores supplementary information about the product group type in the ARGUMENT1 column. FND_PRODUCT_GROUPS is used mainly by AutoInstall. Oracle Application Object Library uses this information to provide you with release information when you do \ Help Version. You should never modify this table. The CODESET column is no longer used and may contain the value 'Not Used'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PRODUCT_GROUP_ID	NUMBER	(15)	Yes	Product group identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PRODUCT_GROUP_NAME	VARCHAR2	(60)	Yes	Product group name
RELEASE_NAME	VARCHAR2	(50)	Yes	Release name
PRODUCT_GROUP_TYPE	VARCHAR2	(30)	Yes	Product group type (for example, Standard)
ARGUMENT1	VARCHAR2	(30)		Supplementary information for product group type
MULTI_ORG_FLAG	VARCHAR2	(1)		Y => the Oracle Applications installation is a multi-org installation
MULTI_LINGUAL_FLAG	VARCHAR2	(1)		Y => the Oracle Applications installation is a multi-lingual installation
MULTI_CURRENCY_FLAG	VARCHAR2	(1)		Is Multi-Currency installed in this database
APPLICATIONS_SYSTEM_NAME	VARCHAR2	(30)	Yes	Name of the "Applications System"
IS_NEW_TS_MODE	VARCHAR2	(1)		Y => The Oracle Applications installation has embraced the new tablespace model (the one based on I/O characteristics)
ARU_RELEASE_NAME	VARCHAR2	(50)		Aru Release Name

Query Text

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


SELECT PRODUCT_GROUP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PRODUCT_GROUP_NAME
,      RELEASE_NAME
,      PRODUCT_GROUP_TYPE
,      ARGUMENT1
,      MULTI_ORG_FLAG
,      MULTI_LINGUAL_FLAG
,      MULTI_CURRENCY_FLAG
,      APPLICATIONS_SYSTEM_NAME
,      IS_NEW_TS_MODE
,      ARU_RELEASE_NAME
FROM APPLSYS.FND_PRODUCT_GROUPS;

Dependencies

[top of page]

APPLSYS.FND_PRODUCT_GROUPS does not reference any database object

APPLSYS.FND_PRODUCT_GROUPS is referenced by following:

APPLSYS: FND_PRODUCT_GROUPS#