[Home] [Help] [Dependency Information]
Object Name: | QPR_TRANSF_RULES_B |
---|---|
Object Type: | TABLE |
Owner: | QPR |
Subobject Name: | |
Status: | VALID |
This table stores the details of Transformation Rules
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
QPR_TRANSF_RULES_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TRANSF_RULE_ID |
QPR_TRANSF_RULES_B_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TRANSF_HEADER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSF_RULE_ID | NUMBER | Yes | Unique identifier of the Transformation Rule | |
TRANSF_HEADER_ID | NUMBER | Yes | Foreign key to QPR_TRANSF_HEADERS_B | |
LEVEL_VALUE_FROM | VARCHAR2 | (240) | It contains the 'from value' of the dimension member to which the rule applies | |
LEVEL_VALUE_TO | VARCHAR2 | (240) | It contains the 'to value' of the dimension member to which the rule applies | |
LEVEL_DESC_FROM | VARCHAR2 | (240) | It contains the description of the dimension member taken as the 'from value' | |
LEVEL_DESC_TO | VARCHAR2 | (240) | It contains the description of the dimension member taken as the 'to value' | |
LEVEL_VALUE_LIKE_FLAG | VARCHAR2 | (1) | Flag to indicate whether we have to take the exact values or similar values for the dimension members. It takes values 'Y/N' | |
LEVEL_VALUE_NUMBER_FLAG | VARCHAR2 | (1) | Flag to specify whether the dimension member value is a number or a string.It takes values 'N/null' | |
ATTRIBUTE1_FROM | VARCHAR2 | (240) | It contains the 'from value' of the dimension member's attribute 1 | |
ATTRIBUTE1_TO | VARCHAR2 | (240) | It contains the 'to value' of the dimension member's attribute 1 | |
ATTRIBUTE1_NUMBER_FLAG | VARCHAR2 | (1) | Indicates whether attribute 1 has numeric or string value | |
ATTRIBUTE2_FROM | VARCHAR2 | (240) | It contains the 'from value' of the dimension member's attribute 2 | |
ATTRIBUTE2_TO | VARCHAR2 | (240) | It contains the 'to value' of the dimension member's attribute 2 | |
ATTRIBUTE2_NUMBER_FLAG | VARCHAR2 | (1) | Indicates whether attribute 2 has numeric or string value | |
ATTRIBUTE3_FROM | VARCHAR2 | (240) | It contains the 'from value' of the dimension member's attribute 3 | |
ATTRIBUTE3_TO | VARCHAR2 | (240) | It contains the 'to value' of the dimension member's attribute 3 | |
ATTRIBUTE3_NUMBER_FLAG | VARCHAR2 | (1) | Indicates whether attribute 3 has numeric or string value | |
ATTRIBUTE4_FROM | VARCHAR2 | (240) | It contains the 'from value' of the dimension member's attribute 4 | |
ATTRIBUTE4_TO | VARCHAR2 | (240) | It contains the 'to value' of the dimension member's attribute 4 | |
ATTRIBUTE4_NUMBER_FLAG | VARCHAR2 | (1) | Indicates whether attribute 4 has numeric or string value | |
ATTRIBUTE5_FROM | VARCHAR2 | (240) | It contains the 'from value' of the dimension member's attribute 5 | |
ATTRIBUTE5_TO | VARCHAR2 | (240) | It contains the 'to value' of the dimension member's attribute 5 | |
ATTRIBUTE5_NUMBER_FLAG | VARCHAR2 | (1) | Indicates whether attribute 5 has numeric or string value | |
LIMIT_DIM_CODE | VARCHAR2 | (240) | It specifies the dimension code for a 'MEASDIM' transformation in case the corresponding transformation header has LIMIT_DIM_FLAG = Y | |
LIMIT_DIM_LEVEL | VARCHAR2 | (30) | It specifies the level number for a 'MEASDIM' transformation in case the corresponding transformation header has LIMIT_DIM_FLAG = Y | |
LIMIT_DIM_LEVEL_VALUE | VARCHAR2 | (240) | It specifies the dimension member value for a 'MEASDIM' transformation in case the corresponding transformation header has LIMIT_DIM_FLAG = Y | |
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 TRANSF_RULE_ID
, TRANSF_HEADER_ID
, LEVEL_VALUE_FROM
, LEVEL_VALUE_TO
, LEVEL_DESC_FROM
, LEVEL_DESC_TO
, LEVEL_VALUE_LIKE_FLAG
, LEVEL_VALUE_NUMBER_FLAG
, ATTRIBUTE1_FROM
, ATTRIBUTE1_TO
, ATTRIBUTE1_NUMBER_FLAG
, ATTRIBUTE2_FROM
, ATTRIBUTE2_TO
, ATTRIBUTE2_NUMBER_FLAG
, ATTRIBUTE3_FROM
, ATTRIBUTE3_TO
, ATTRIBUTE3_NUMBER_FLAG
, ATTRIBUTE4_FROM
, ATTRIBUTE4_TO
, ATTRIBUTE4_NUMBER_FLAG
, ATTRIBUTE5_FROM
, ATTRIBUTE5_TO
, ATTRIBUTE5_NUMBER_FLAG
, LIMIT_DIM_CODE
, LIMIT_DIM_LEVEL
, LIMIT_DIM_LEVEL_VALUE
, 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_TRANSF_RULES_B;
QPR.QPR_TRANSF_RULES_B does not reference any database object
QPR.QPR_TRANSF_RULES_B is referenced by following:
|
|
|