[Home] [Help] [Dependency Information]
Object Name: | MTH_SRC_ITEM_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 |
---|---|---|---|---|
LEVEL_FK | VARCHAR2 | (120) | Reference to source level identifier | |
PARENT_FK | VARCHAR2 | (120) | Reference to source parent | |
HIERARCHY_NAME | VARCHAR2 | (120) | Hierarchy name, unique within a dimension | |
LEVEL_NUM | NUMBER | Level number in the hierarchy | ||
SYSTEM_FK | VARCHAR2 | (4000) | Reference to source system | |
SOURCE_ORG_CODE | VARCHAR2 | (3) | Organization Code | |
EBS_ITEM_ID | NUMBER | EBS Item identifier | ||
EBS_CATEGORY_ID | NUMBER | EBS Category identifier | ||
EBS_PARENT_CATEGORY_ID | NUMBER | EBS Parent Category identifier | ||
EBS_CATEGORY_SET_NAME | VARCHAR2 | (30) | Ebs Category Set Name | |
LAST_UPDATE_DATE | DATE | Last Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT LEVEL_FK
, PARENT_FK
, HIERARCHY_NAME
, LEVEL_NUM
, SYSTEM_FK
, SOURCE_ORG_CODE
, EBS_ITEM_ID
, EBS_CATEGORY_ID
, EBS_PARENT_CATEGORY_ID
, EBS_CATEGORY_SET_NAME
, LAST_UPDATE_DATE
FROM APPS.MTH_SRC_ITEM_HIERARCHY_V;
APPS.MTH_SRC_ITEM_HIERARCHY_V is not referenced by any database object
|
|
|