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: MSC.MSC_BIS_RES_INST_SUMMARY

Object Details

Object Name:	MSC_BIS_RES_INST_SUMMARY
Object Type:	TABLE
Owner:	MSC
Subobject Name:
Status:	VALID

This table stores resource instance availability, requirement, and utilization. This information is used in resource instance kpi

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_BIS_RES_INST_SUMMARY_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID SR_INSTANCE_ID DEPARTMENT_ID RESOURCE_ID RES_INSTANCE_ID SERIAL_NUMBER RESOURCE_INST_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Fk to msc_plans.
SR_INSTANCE_ID	NUMBER		Yes	Source Instance id
RESOURCE_ID	NUMBER		Yes	Resource Id
RES_INSTANCE_ID	NUMBER		Yes	Resource Instance Id
EQUIPMENT_ITEM_ID	NUMBER			Equipment Item associated with resource
SERIAL_NUMBER	VARCHAR2	(30)		Item serial number for resource instance
ORGANIZATION_ID	NUMBER		Yes	Organization_id
DEPARTMENT_ID	NUMBER		Yes	Department Id
RESOURCE_INST_DATE	DATE			Resource Instance Date for requirement or availability
REQUIRED_HOURS	NUMBER			Resource Instance required Hour on Resource instance date
AVAILABLE_HOURS	NUMBER			Resource Instance available Hour on Resource instance date
UTILIZATION	NUMBER			Resource instanc eutilization on resource instance date
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
UTIL_BY_WT_VOL	NUMBER			Utilization by weight or volume
BATCH_COUNT	NUMBER			Total Number of Resource instance batches
DETAIL_LEVEL	NUMBER			1 for weekly , otherwise enull
PERIOD_TYPE	NUMBER			-1 for Bis period, -2 for mfg period

Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      RESOURCE_ID
,      RES_INSTANCE_ID
,      EQUIPMENT_ITEM_ID
,      SERIAL_NUMBER
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      RESOURCE_INST_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_ID
,      PROGRAM_UPDATE_DATE
,      UTIL_BY_WT_VOL
,      BATCH_COUNT
,      DETAIL_LEVEL
,      PERIOD_TYPE
FROM MSC.MSC_BIS_RES_INST_SUMMARY;

Dependencies

[top of page]

MSC.MSC_BIS_RES_INST_SUMMARY does not reference any database object

MSC.MSC_BIS_RES_INST_SUMMARY is referenced by following:

APPS: MSC_BIS_RES_INST_SUMMARY