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

VIEW: APPS.AME_ITEM_CLASSES_VL

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

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.AME_ITEM_CLASSES_VL references the following:

SchemaAPPS
SynonymAME_ITEM_CLASSES
SynonymAME_ITEM_CLASSES_TL
APPS.AME_ITEM_CLASSES_VL is referenced by following:

SchemaAPPS
Package BodyAME_TEST_UTILITY_PKG - show dependent code
Package BodyASO_PA_APR_INT - show dependent code