eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: ENI.EDW_BOM_RES_M

Object Details

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.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	30
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

ENI.EDW_BOM_RES_M does not reference any database object

ENI.EDW_BOM_RES_M is referenced by following:

APPS: EDW_BOM_RES_M