[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FND_PRODUCT_INSTALLATIONS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
ORACLE_ID |
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) |
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;
APPLSYS.FND_PRODUCT_INSTALLATIONS does not reference any database object
APPLSYS.FND_PRODUCT_INSTALLATIONS is referenced by following:
|
|
|