[Home] [Help] [Dependency Information]
Object Name: | AME_ITEM_CLASSES_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
This view provides the details of item class with translated details in the current session language. This view is join between ame_item_classes and ame_item_classes_tl based on current session language.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CLASS_ID | NUMBER | (15) | Yes | Item class identifier |
NAME | VARCHAR2 | (100) | Yes | Item class name |
USER_ITEM_CLASS_NAME | VARCHAR2 | (300) | Item class display name | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
START_DATE | DATE | Yes | Date on which row is activated | |
END_DATE | DATE | Date on which row is inactivated | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | System-generated version of row. Increments by one with each update |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CLASS_ID
, NAME
, USER_ITEM_CLASS_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, START_DATE
, END_DATE
, OBJECT_VERSION_NUMBER
FROM APPS.AME_ITEM_CLASSES_VL;
|
|
|