[Home] [Help] [Dependency Information]
Object Name: | ITA_SETUP_HIERARCHY_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view serves as Lookups and renders the codes and meanings of the hierarchy levels (organization types) encountered throughout our pages.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row identifier | |
HIERARCHY_LEVEL_CODE | VARCHAR2 | (30) | Yes | Code |
HIERARCHY_LEVEL_NAME | VARCHAR2 | (240) | Code meaning | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column | |
SECURITY_GROUP_ID | NUMBER | Standard Applications column | ||
OBJECT_VERSION_NUMBER | NUMBER | Standard Applications column |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, HIERARCHY_LEVEL_CODE
, HIERARCHY_LEVEL_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
FROM APPS.ITA_SETUP_HIERARCHY_VL;
|
|
|