FND_PRODUCT_GROUPS

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

Name Datatype Length Mandatory Comments
PRODUCT_GROUP_ID NUMBER (15) Yes Product group identifier
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
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)

Usage:



 procedure quick_list(c_search in varchar2 := ' ')
  is
  cursor cur_version is
    select release_name
    from fnd_product_groups
    order by release_name;