DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.QPR_TRANSF_RULES_VL

Object Details
Object Name: QPR_TRANSF_RULES_VL
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View of QPR_TRANSF_RULES_B and QPR_TRANSF_RULES_TL. Displays the transalated columns on transformation rules in the local language


[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSF_RULE_ID NUMBER
Yes Unique identifier of a Transformation Rule
NAME VARCHAR2 (240) Yes Name for transformation rule.
DESCRIPTION VARCHAR2 (2000)
Description for 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
Query Text

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


SELECT TRANSF_RULE_ID
,      NAME
,      DESCRIPTION
,      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
FROM APPS.QPR_TRANSF_RULES_VL;

Dependencies

[top of page]

APPS.QPR_TRANSF_RULES_VL references the following:

SchemaAPPS
SynonymQPR_TRANSF_RULES_B
SynonymQPR_TRANSF_RULES_TL

APPS.QPR_TRANSF_RULES_VL is not referenced by any database object