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_INSTALLATIONS

Object Details

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

FND_PRODUCT_INSTALLATIONS stores information about Oracle Applications products at your site. Each row includes a value identifying the application (APPLICATION_ID), a value identifying the database account (ORACLE_ID), the product's version number (PRODUCT_VERSION), the product's status at your site (STATUS, where I means installed, L means custom, N means not installed, and S means installed as shared product), and the product's industry (INDUSTRY, where C means for commercial or for-profit use, G means for educational or not-for-profit use, B means Project Billing, and P means Project Costing). Each row also includes the names of the tablespace in which the application tables, indexes, and temporary objects reside (TABLESPACE, INDEX_TABLESPACE, and TEMPORARY_TABLESPACE), and the sizing factor for the product (SIZING_FACTOR). Oracle Applications uses this information to display product version numbers when you choose \ Help Version, when installing and upgrading your database, and for other purposes.
.
INSTALL_GROUP_NUM is 0 for SOA products and 1 for MOA products.
.
MOA (Multiple Oracle account) products are products that needed multiple Oracle accounts to support multiple sets of books.
.
SOA (Single Oracle account) products are those that need only 1 Oracle account, either because they are able to handle multiple sets of books with one Oracle account, or they have nothing to do with sets of books.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_PRODUCT_INSTALLATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPLICATION_ID ORACLE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPLICATION_ID	NUMBER	(15)	Yes	Application identifier
ORACLE_ID	NUMBER	(15)	Yes	ORACLE account in which the application is installed
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_VERSION	VARCHAR2	(30)		Version number for the application
STATUS	VARCHAR2	(1)		The status of the application
INDUSTRY	VARCHAR2	(1)		The industry of the application
TABLESPACE	VARCHAR2	(30)		Name of tablespace for the application's tables
INDEX_TABLESPACE	VARCHAR2	(30)		Name of tablespace for the application's indexes
TEMPORARY_TABLESPACE	VARCHAR2	(30)		Name of tablespace for temporary objects
SIZING_FACTOR	NUMBER			The sizing factor for the application
INSTALL_GROUP_NUM	NUMBER	(15)		0 for SOA products; 1 for MOA products
DB_STATUS	VARCHAR2	(1)		Y => Product's database objects are installed in the database
PATCH_LEVEL	VARCHAR2	(30)		Current Mini-pack level of the product (eg. 11i.AD.B, etc)

Query Text

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


SELECT APPLICATION_ID
,      ORACLE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PRODUCT_VERSION
,      STATUS
,      INDUSTRY
,      TABLESPACE
,      INDEX_TABLESPACE
,      TEMPORARY_TABLESPACE
,      SIZING_FACTOR
,      INSTALL_GROUP_NUM
,      DB_STATUS
,      PATCH_LEVEL
FROM APPLSYS.FND_PRODUCT_INSTALLATIONS;

Dependencies

[top of page]

APPLSYS.FND_PRODUCT_INSTALLATIONS does not reference any database object

APPLSYS.FND_PRODUCT_INSTALLATIONS is referenced by following:

APPS: FND_PRODUCT_INSTALLATIONS; FND_PROD_LIC_TGR
SYSTEM: FND_PRODUCT_INSTALLATIONS