[Home] [Help] [Dependency Information]
Object Name: | EDW_BOM_RES_M |
---|---|
Object Type: | TABLE |
Owner: | ENI |
Subobject Name: | |
Status: | VALID |
This is the denormailized star table for the Manufacturing Resource Dimension. It contains the records for the lowest level of the Resource dimension and their parentage up to the top level, across all hierarchies.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 30 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_BOM_RES_M_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
RSRC_RESOURCE_PK
RSRC_RESOURCE_PK_KEY |
EDW_BOM_RES_M_U2 | NORMAL | UNIQUE | APPS_TS_SUMMARY | RSRC_RESOURCE_PK_KEY |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RSRC_RESOURCE_PK_KEY | NUMBER | Yes | System generated unique identifier for resource | |
RGRP_RESOURCE_GROUP_PK_KEY | NUMBER | System generated unique identifier for resource group | ||
DEPT_DEPARTMENT_PK_KEY | NUMBER | System generated unique identifier for department | ||
PDPT_PARENT_DEPARTMENT_PK_KEY | NUMBER | System generated unique identifier for parent department | ||
DCLS_DEPARTMENT_CLASS_PK_KEY | NUMBER | System generated unique identifier for department class | ||
PLNT_PLANT_PK_KEY | NUMBER | System generated unique identifier for plant | ||
RCAT_RESOURCE_CATEGORY_PK_KEY | NUMBER | System generated unique identifier for resource category | ||
RTYP_RESOURCE_TYPE_PK_KEY | NUMBER | System generated unique identifier for resource type | ||
ALL_ALL_PK_KEY | NUMBER | System generated unique identifier for the top level record | ||
RSRC_AVAIL_24_HRS_FLAG | VARCHAR2 | (20) | Resource is available 24 Hrs or by shift | |
RSRC_INSTANCE_CODE | VARCHAR2 | (40) | Source instance code | |
RSRC_NAME | VARCHAR2 | (320) | Resource name | |
RSRC_RESOURCE_CODE | VARCHAR2 | (40) | Resource Code | |
RSRC_RESOURCE_DP | VARCHAR2 | (240) | Unique resource name | |
RSRC_RESOURCE_PK | VARCHAR2 | (80) | Unique identifier for the resource | |
RSRC_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for the resource level | |
RSRC_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for the resource level | |
RSRC_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for the resource level | |
RSRC_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for the resource level | |
RSRC_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for the resource level | |
RGRP_INSTANCE_CODE | VARCHAR2 | (40) | Source instance code | |
RGRP_NAME | VARCHAR2 | (320) | Resource group name | |
RGRP_RESOURCE_GROUP | VARCHAR2 | (80) | Resource Group | |
RGRP_RESOURCE_GROUP_DP | VARCHAR2 | (240) | Not currently used | |
RGRP_RESOURCE_GROUP_PK | VARCHAR2 | (80) | Unique identifier for the resource group | |
RGRP_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for the resource group level | |
RGRP_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for the resource group level | |
RGRP_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for the resource group level | |
RGRP_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for the resource group level | |
RGRP_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for the resource group level | |
DEPT_DEPARTMENT_DP | VARCHAR2 | (240) | Unique department name | |
DEPT_DEPARTMENT_NAME | VARCHAR2 | (80) | Department name | |
DEPT_DEPARTMENT_PK | VARCHAR2 | (80) | Unique identifier for the department | |
DEPT_DESCRIPTION | VARCHAR2 | (240) | Department description | |
DEPT_INSTANCE_CODE | VARCHAR2 | (40) | Source instance code | |
DEPT_NAME | VARCHAR2 | (320) | Department Name | |
DEPT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for the department level | |
DEPT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for the department level | |
DEPT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for the department level | |
DEPT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for the department level | |
DEPT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for the department level | |
PDPT_DEPARTMENT_NAME | VARCHAR2 | (80) | Parent department name | |
PDPT_DESCRIPTION | VARCHAR2 | (240) | Parent department description | |
PDPT_INSTANCE_CODE | VARCHAR2 | (40) | Source instance Code | |
PDPT_NAME | VARCHAR2 | (320) | Parent department name | |
PDPT_PARENT_DEPARTMENT_DP | VARCHAR2 | (240) | Not currently used | |
PDPT_PARENT_DEPARTMENT_PK | VARCHAR2 | (80) | Unique identifier for parent department | |
PDPT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for parent department level | |
PDPT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for parent department level | |
PDPT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for parent department level | |
PDPT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for parent department level | |
PDPT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for parent department level | |
DCLS_DEPARTMENT_CLASS | VARCHAR2 | (80) | Department class | |
DCLS_DEPARTMENT_CLASS_DP | VARCHAR2 | (40) | Unique department class name | |
DCLS_DEPARTMENT_CLASS_PK | VARCHAR2 | (80) | Unique identifier for department class | |
DCLS_DESCRIPTION | VARCHAR2 | (240) | Department class description | |
DCLS_INSTANCE_CODE | VARCHAR2 | (40) | Source instance code | |
DCLS_NAME | VARCHAR2 | (320) | Department class name | |
DCLS_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for department class level | |
DCLS_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for department class level | |
DCLS_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for department class level | |
DCLS_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for department class level | |
DCLS_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for department class level | |
PLNT_DESCRIPTION | VARCHAR2 | (240) | Plant description | |
PLNT_INSTANCE_CODE | VARCHAR2 | (40) | Plant instance code | |
PLNT_NAME | VARCHAR2 | (320) | Plant name | |
PLNT_ORGANIZATION_CODE | VARCHAR2 | (40) | Organization code | |
PLNT_ORGANIZATION_NAME | VARCHAR2 | (500) | Organization name | |
PLNT_PLANT_DP | VARCHAR2 | (240) | Not currently used | |
PLNT_PLANT_PK | VARCHAR2 | (80) | Unique Identifier | |
PLNT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLNT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLNT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLNT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLNT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for plant level | |
RCAT_DESCRIPTION | VARCHAR2 | (240) | Resource category description | |
RCAT_INSTANCE_CODE | VARCHAR2 | (40) | Source instance Code | |
RCAT_NAME | VARCHAR2 | (320) | Not currently used | |
RCAT_RESOURCE_CATEGORY | VARCHAR2 | (80) | Resource category | |
RCAT_RESOURCE_CATEGORY_DP | VARCHAR2 | (240) | Unique Resource category identifier | |
RCAT_RESOURCE_CATEGORY_PK | VARCHAR2 | (80) | Unique identifier for resource category | |
RCAT_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for resource category level | |
RCAT_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for resource category level | |
RCAT_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for resource category level | |
RCAT_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for resource category level | |
RCAT_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for resource category level | |
RTYP_INSTANCE_CODE | VARCHAR2 | (40) | Source instance code | |
RTYP_NAME | VARCHAR2 | (320) | Resource type name | |
RTYP_RESOURCE_TYPE | VARCHAR2 | (80) | Resource Type | |
RTYP_RESOURCE_TYPE_DP | VARCHAR2 | (240) | Not currently used | |
RTYP_RESOURCE_TYPE_PK | VARCHAR2 | (80) | Unique identifier for resource type | |
RTYP_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for resource type level | |
RTYP_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for resource type level | |
RTYP_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for resource type level | |
RTYP_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for resource type level | |
RTYP_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for resource type level | |
ALL_ALL_PK | VARCHAR2 | (40) | Unique identifier for the record in the top level | |
ALL_NAME | VARCHAR2 | (320) | Name | |
PLN1_PLANT_PK_KEY | NUMBER | System generated unique identifier for plant | ||
PLN1_DESCRIPTION | VARCHAR2 | (240) | Plant Description | |
PLN1_INSTANCE_CODE | VARCHAR2 | (40) | Source instance code | |
PLN1_NAME | VARCHAR2 | (320) | Plant name | |
PLN1_ORGANIZATION_CODE | VARCHAR2 | (40) | Organization code | |
PLN1_ORGANIZATION_NAME | VARCHAR2 | (500) | Organization name | |
PLN1_PLANT_DP | VARCHAR2 | (240) | Not currently used | |
PLN1_PLANT_PK | VARCHAR2 | (80) | Unique identifier for plant level | |
PLN1_USER_ATTRIBUTE1 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLN1_USER_ATTRIBUTE2 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLN1_USER_ATTRIBUTE3 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLN1_USER_ATTRIBUTE4 | VARCHAR2 | (240) | User defined attribute for plant level | |
PLN1_USER_ATTRIBUTE5 | VARCHAR2 | (240) | User defined attribute for plant level | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT RSRC_RESOURCE_PK_KEY
, RGRP_RESOURCE_GROUP_PK_KEY
, DEPT_DEPARTMENT_PK_KEY
, PDPT_PARENT_DEPARTMENT_PK_KEY
, DCLS_DEPARTMENT_CLASS_PK_KEY
, PLNT_PLANT_PK_KEY
, RCAT_RESOURCE_CATEGORY_PK_KEY
, RTYP_RESOURCE_TYPE_PK_KEY
, ALL_ALL_PK_KEY
, RSRC_AVAIL_24_HRS_FLAG
, RSRC_INSTANCE_CODE
, RSRC_NAME
, RSRC_RESOURCE_CODE
, RSRC_RESOURCE_DP
, RSRC_RESOURCE_PK
, RSRC_USER_ATTRIBUTE1
, RSRC_USER_ATTRIBUTE2
, RSRC_USER_ATTRIBUTE3
, RSRC_USER_ATTRIBUTE4
, RSRC_USER_ATTRIBUTE5
, RGRP_INSTANCE_CODE
, RGRP_NAME
, RGRP_RESOURCE_GROUP
, RGRP_RESOURCE_GROUP_DP
, RGRP_RESOURCE_GROUP_PK
, RGRP_USER_ATTRIBUTE1
, RGRP_USER_ATTRIBUTE2
, RGRP_USER_ATTRIBUTE3
, RGRP_USER_ATTRIBUTE4
, RGRP_USER_ATTRIBUTE5
, DEPT_DEPARTMENT_DP
, DEPT_DEPARTMENT_NAME
, DEPT_DEPARTMENT_PK
, DEPT_DESCRIPTION
, DEPT_INSTANCE_CODE
, DEPT_NAME
, DEPT_USER_ATTRIBUTE1
, DEPT_USER_ATTRIBUTE2
, DEPT_USER_ATTRIBUTE3
, DEPT_USER_ATTRIBUTE4
, DEPT_USER_ATTRIBUTE5
, PDPT_DEPARTMENT_NAME
, PDPT_DESCRIPTION
, PDPT_INSTANCE_CODE
, PDPT_NAME
, PDPT_PARENT_DEPARTMENT_DP
, PDPT_PARENT_DEPARTMENT_PK
, PDPT_USER_ATTRIBUTE1
, PDPT_USER_ATTRIBUTE2
, PDPT_USER_ATTRIBUTE3
, PDPT_USER_ATTRIBUTE4
, PDPT_USER_ATTRIBUTE5
, DCLS_DEPARTMENT_CLASS
, DCLS_DEPARTMENT_CLASS_DP
, DCLS_DEPARTMENT_CLASS_PK
, DCLS_DESCRIPTION
, DCLS_INSTANCE_CODE
, DCLS_NAME
, DCLS_USER_ATTRIBUTE1
, DCLS_USER_ATTRIBUTE2
, DCLS_USER_ATTRIBUTE3
, DCLS_USER_ATTRIBUTE4
, DCLS_USER_ATTRIBUTE5
, PLNT_DESCRIPTION
, PLNT_INSTANCE_CODE
, PLNT_NAME
, PLNT_ORGANIZATION_CODE
, PLNT_ORGANIZATION_NAME
, PLNT_PLANT_DP
, PLNT_PLANT_PK
, PLNT_USER_ATTRIBUTE1
, PLNT_USER_ATTRIBUTE2
, PLNT_USER_ATTRIBUTE3
, PLNT_USER_ATTRIBUTE4
, PLNT_USER_ATTRIBUTE5
, RCAT_DESCRIPTION
, RCAT_INSTANCE_CODE
, RCAT_NAME
, RCAT_RESOURCE_CATEGORY
, RCAT_RESOURCE_CATEGORY_DP
, RCAT_RESOURCE_CATEGORY_PK
, RCAT_USER_ATTRIBUTE1
, RCAT_USER_ATTRIBUTE2
, RCAT_USER_ATTRIBUTE3
, RCAT_USER_ATTRIBUTE4
, RCAT_USER_ATTRIBUTE5
, RTYP_INSTANCE_CODE
, RTYP_NAME
, RTYP_RESOURCE_TYPE
, RTYP_RESOURCE_TYPE_DP
, RTYP_RESOURCE_TYPE_PK
, RTYP_USER_ATTRIBUTE1
, RTYP_USER_ATTRIBUTE2
, RTYP_USER_ATTRIBUTE3
, RTYP_USER_ATTRIBUTE4
, RTYP_USER_ATTRIBUTE5
, ALL_ALL_PK
, ALL_NAME
, PLN1_PLANT_PK_KEY
, PLN1_DESCRIPTION
, PLN1_INSTANCE_CODE
, PLN1_NAME
, PLN1_ORGANIZATION_CODE
, PLN1_ORGANIZATION_NAME
, PLN1_PLANT_DP
, PLN1_PLANT_PK
, PLN1_USER_ATTRIBUTE1
, PLN1_USER_ATTRIBUTE2
, PLN1_USER_ATTRIBUTE3
, PLN1_USER_ATTRIBUTE4
, PLN1_USER_ATTRIBUTE5
, CREATION_DATE
, LAST_UPDATE_DATE
FROM ENI.EDW_BOM_RES_M;
ENI.EDW_BOM_RES_M does not reference any database object
ENI.EDW_BOM_RES_M is referenced by following:
|
|
|