[Home] [Help] [Dependency Information]
Object Name: | MTH_SRC_EQUIP_HIERARCHY_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 |
---|---|---|---|---|
HIERARCHY_NAME | VARCHAR2 | (24) | Hierarchy name, unique within a dimension | |
LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
LEVEL_FK | VARCHAR2 | (81) | Reference to the source level | |
PARENT_FK | VARCHAR2 | (120) | Reference to the source parent level | |
SYSTEM_FK | VARCHAR2 | (4000) | Reference to source system | |
EFFECTIVE_DATE | DATE | Effective date for the relationship | ||
LAST_UPDATE_DATE | DATE | Last Update Date | ||
SOURCE_ORG_CODE | VARCHAR2 | (15) | Organization code in source system | |
PARENT_SOURCE_ORG_CODE | VARCHAR2 | (15) | Parent Organization code in source system |
Cut, paste (and edit) the following text to query this object:
SELECT HIERARCHY_NAME
, LEVEL_NUM
, LEVEL_FK
, PARENT_FK
, SYSTEM_FK
, EFFECTIVE_DATE
, LAST_UPDATE_DATE
, SOURCE_ORG_CODE
, PARENT_SOURCE_ORG_CODE
FROM APPS.MTH_SRC_EQUIP_HIERARCHY_V;
APPS.MTH_SRC_EQUIP_HIERARCHY_V is not referenced by any database object
|
|
|