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

VIEW: APPS.MTL_ITEM_REV_HIGHDATE_V

Object Details
Object Name: MTL_ITEM_REV_HIGHDATE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewINV.MTL_ITEM_REV_HIGHDATE_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
REVISION_ID NUMBER
Yes
REVISION VARCHAR2 (3) Yes
EFFECTIVITY_DATE DATE
Yes
HIGH_DATE DATE


IMPLEMENTATION_DATE DATE


CHANGE_NOTICE VARCHAR2 (10)

Query Text

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


SELECT ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION_ID
,      REVISION
,      EFFECTIVITY_DATE
,      HIGH_DATE
,      IMPLEMENTATION_DATE
,      CHANGE_NOTICE
FROM APPS.MTL_ITEM_REV_HIGHDATE_V;

Dependencies

[top of page]

APPS.MTL_ITEM_REV_HIGHDATE_V references the following:

SchemaAPPS
SynonymMTL_ITEM_REVISIONS_B
APPS.MTL_ITEM_REV_HIGHDATE_V is referenced by following:

SchemaAPPS
Package BodyBOM_REVISIONS - show dependent code
Package BodyINV_EBI_ITEM_HELPER - show dependent code