[Home] [Help] [Dependency Information]
Object Name: | QPR_INSTANCES |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table stores different application instances from which data is sourced. This is to enable the planning and transaction processing applications to be installed in different database instances. The dimension and measure data is striped by the instance id to identify the source instance.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_INSTANCES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | INSTANCE_ID |
QPR_INSTANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | INSTANCE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_ID | NUMBER | Yes | Unique identifier for a source database instance. | |
INSTANCE_CODE | VARCHAR2 | (30) | Yes | Unique code to identify the source database instance. |
INSTANCE_TYPE | VARCHAR2 | (30) | Yes | Type to identify whether it refers to Oracle Applications 11i or R 12. |
DBLINK | VARCHAR2 | (128) | Application database link value. | |
ENABLED_FLAG | VARCHAR2 | (1) | Indicates if the instance is enabled or not. Takes values 'Y'/'N'. | |
CREATION_DATE | DATE | Yes | Standard Who Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
PROGRAM_ID | NUMBER | Identifies the concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Identifies the Oracle Applicaitons Consurrent Program Login ID | ||
PROGRAM_APPLICATION_ID | NUMBER | Identifies the Oracle Application that spawned the consurrent program | ||
REQUEST_ID | NUMBER | Identifies the concurrent request instance that spawned the concurrent program |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_ID
, INSTANCE_CODE
, INSTANCE_TYPE
, DBLINK
, ENABLED_FLAG
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID
, REQUEST_ID
FROM QPR.QPR_INSTANCES;
QPR.QPR_INSTANCES does not reference any database object
QPR.QPR_INSTANCES is referenced by following:
|
|
|