[Home] [Help] [Dependency Information]
Object Name: | QPR_MEASURE_SOURCES |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table contains operational data store measure data source mapping details. Based on this mapping the data is sourced from the application instances and populated to QPR_MEASURE_DATA table, which inturn sources data for datamart creation.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_MEASURE_SOURCES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | MEAS_SRC_ID |
QPR_MEASURE_SOURCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INSTANCE_ID
MEASURE_TYPE_CODE MEASURE_PPA_CODE SRC_TBL_NAME INSTANCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEAS_SRC_ID | NUMBER | Yes | Unique Identifier for the measure data source mapping values. | |
INSTANCE_ID | NUMBER | Yes | Unique identifier of the application instance from which the data is sourced. | |
INSTANCE_TYPE | VARCHAR2 | (30) | Yes | Type to identify whether it refers to Oracle Applications 11i or R 12. |
MEASURE_PPA_CODE | VARCHAR2 | (30) | Yes | Unique code to identify the measure for which the mapping is defined. |
MEASURE_TYPE_CODE | VARCHAR2 | (30) | Indicates the functional group to which the measure belongs. | |
SEEDED_FLAG | VARCHAR2 | (1) | Indicates if the value is seeded data or not.Takes values 'Y'/'N'. | |
SRC_TBL_NAME | VARCHAR2 | (30) | Identifies the source table/view name from which the values are sourced. | |
SRC_COL_NAME | VARCHAR2 | (30) | Identifies the source column name from which the data is sourced. | |
TGT_TBL_NAME | VARCHAR2 | (30) | Identifies the target table to which the data is populated. | |
TGT_COL_NAME | VARCHAR2 | (30) | Identifies the target column name to which data is poplated. | |
USER_TGT_TBL_NAME | VARCHAR2 | (30) | Identifies the target table to which the data is populated. | |
USER_SRC_TBL_NAME | VARCHAR2 | (30) | Identifies the source table/view name from which the values are sourced. | |
USER_SRC_COL_NAME | VARCHAR2 | (30) | Identifies the source column name from which the data is sourced. | |
USER_TGT_COL_NAME | VARCHAR2 | (30) | Identifies the target column name to which data is poplated. | |
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 MEAS_SRC_ID
, INSTANCE_ID
, INSTANCE_TYPE
, MEASURE_PPA_CODE
, MEASURE_TYPE_CODE
, SEEDED_FLAG
, SRC_TBL_NAME
, SRC_COL_NAME
, TGT_TBL_NAME
, TGT_COL_NAME
, USER_TGT_TBL_NAME
, USER_SRC_TBL_NAME
, USER_SRC_COL_NAME
, USER_TGT_COL_NAME
, 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_MEASURE_SOURCES;
QPR.QPR_MEASURE_SOURCES does not reference any database object
QPR.QPR_MEASURE_SOURCES is referenced by following:
|
|
|