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: APPS.ENI_RES_4_MV

Object Details

Object Name:	ENI_RES_4_MV
Object Type:	TABLE
Owner:	APPS
FND Design Data:	ENI.ENI_RES_4_MV
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
MST_ROWID	ROWID	(10)		Rowid of the current row in the GMP.CR_RSRC_MST_B table
DTL_ROWID	ROWID	(10)		Rowid of the current row in the GMP.CR_RSRC_DTL table
RESOURCE_ID	NUMBER	(10)	Yes	Manufacturing Resource Identifier
RESOURCE_CODE	VARCHAR2	(16)	Yes	Code for the resource
ORGANIZATION_ID	NUMBER			Organization Identifier
UNIT_OF_MEASURE	VARCHAR2	(3)		Unit Of Measure
DEPARTMENT_ID	VARCHAR2	(8)		The Identifier of the Resource Class to which the Resource belongs
DEPARTMENT_CODE	VARCHAR2	(10)		The Identifier of the Resource Class to which the Resource belongs
RESOURCE_GROUP	VARCHAR2	(16)	Yes	The Resource Group to which the Resource belongs
DISABLE_DATE	DATE			Disable Date for the Resource

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT MST_ROWID
,      DTL_ROWID
,      RESOURCE_ID
,      RESOURCE_CODE
,      ORGANIZATION_ID
,      UNIT_OF_MEASURE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_GROUP
,      DISABLE_DATE
FROM APPS.ENI_RES_4_MV;

Dependencies

[top of page]

APPS.ENI_RES_4_MV does not reference any database object

APPS.ENI_RES_4_MV is referenced by following:

APPS: ENI_RES_4_MV; ENI_RES_5_MV