[Home] [Help] [Dependency Information]
Object Name: | MTH_ALL_ENTITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SITE_ID | NUMBER | Reference to plant or site | ||
ENTITY_PK_KEY | NUMBER | Entity Pk Key | ||
ENTITY_NAME | VARCHAR2 | (100) | Entity name | |
ENTITY_TYPE | VARCHAR2 | (30) | Entity type | |
PRODUCTION_ENTITY | VARCHAR2 | (1) | Y for Production and N for Non-Production | |
ENTITY_PK | VARCHAR2 | (120) | Entity identifier | |
CREATION_DATE | DATE | Creation Date | ||
LAST_UPDATE_DATE | DATE | Last Update Date | ||
STATUS | VARCHAR2 | (30) | Indicate the status whether it is active or not. |
Cut, paste (and edit) the following text to query this object:
SELECT SITE_ID
, ENTITY_PK_KEY
, ENTITY_NAME
, ENTITY_TYPE
, PRODUCTION_ENTITY
, ENTITY_PK
, CREATION_DATE
, LAST_UPDATE_DATE
, STATUS
FROM APPS.MTH_ALL_ENTITIES_V;
|
|
|