[Home] [Help] [Dependency Information]
Object Name: | HZ_TRANSFORMATIONS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
HZ_TRANSFORMATIONS_VL is a view on top of the HZ_TRANSFORMATIONS_B and HZ_TRANSFORMATIONS_TL tables, for transformations in Data Quality Management. Transformations alter attribute values in the DQM staged schema so that the values are more similar and useful for the purpose of matching records.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSFORMATION_ID | NUMBER | (15) | Yes | Unique, sequence-generated transformation identifier |
TRANSFORMATION_NAME | VARCHAR2 | (255) | Yes | User-defined transformation name |
DESCRIPTION | VARCHAR2 | (2000) | Optional transformation description | |
PROCEDURE_NAME | VARCHAR2 | (255) | Yes | Procedure to be called to apply transformation |
OBJECT_VERSION_NUMBER | NUMBER | Version number of record | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column. User who created this row. Foreign key to FND_USER.USER_ID. |
CREATION_DATE | DATE | Yes | Standard Who column. Date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column. User who last updated this row. Foreign key to FND_USER.USER_ID. |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column. Operating system login of user who last updated this row. Foreign key to FND_LOGINS.LOGIN_ID. | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column. Date when user last updated this row. |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSFORMATION_ID
, TRANSFORMATION_NAME
, DESCRIPTION
, PROCEDURE_NAME
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
FROM APPS.HZ_TRANSFORMATIONS_VL;
APPS.HZ_TRANSFORMATIONS_VL is not referenced by any database object
|
|
|