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: MRP.MRP_BIS_RES_SUMMARY

Object Details

Object Name:	MRP_BIS_RES_SUMMARY
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_BIS_RES_SUMMARY
Subobject Name:
Status:	VALID

Summary table used for calculating the resource utilization in the BIS Plan Performance report.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_BIS_RES_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	COMPILE_DESIGNATOR ORGANIZATION_ID

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER		Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(20)	Compile designator
DEPARTMENT_ID	NUMBER		Department identifier
RESOURCE_ID	NUMBER		Resource identifier
LINE_ID	NUMBER		Line identifier
RESOURCE_DATE	DATE		Resource date
REQUIRED_HOURS	NUMBER		Required hours
AVAILABLE_HOURS	NUMBER		Available hours
UTILIZATION	NUMBER		Utilization
LAST_UPDATE_DATE	DATE		Standard who column
LAST_UPDATED_BY	NUMBER		Standard who column
CREATION_DATE	DATE		Standard who column
CREATED_BY	NUMBER		Standard who column
LAST_UPDATE_LOGIN	NUMBER		Standard who column
REQUEST_ID	NUMBER		Extended who column
PROGRAM_APPLICATION_ID	NUMBER		Extended who column
PROGRAM_UPDATE_DATE	DATE		Extended who column
DEPARTMENT_CLASS	VARCHAR2	(10)	Department class
RESOURCE_GROUP	VARCHAR2	(30)	Resource Group Name

Query Text

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


SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      DEPARTMENT_ID
,      RESOURCE_ID
,      LINE_ID
,      RESOURCE_DATE
,      REQUIRED_HOURS
,      AVAILABLE_HOURS
,      UTILIZATION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      DEPARTMENT_CLASS
,      RESOURCE_GROUP
FROM MRP.MRP_BIS_RES_SUMMARY;

Dependencies

[top of page]

MRP.MRP_BIS_RES_SUMMARY does not reference any database object

MRP.MRP_BIS_RES_SUMMARY is referenced by following:

APPS: MRP_BIS_RES_SUMMARY