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]

VIEW: APPS.MSC_RES_AND_INST_V

Object Details

Object Name:	MSC_RES_AND_INST_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length
PLAN_ID	NUMBER
SR_INSTANCE_ID	NUMBER
ORGANIZATION_ID	NUMBER
DEPARTMENT_ID	NUMBER
RESOURCE_ID	NUMBER
OWNING_DEPARTMENT_ID	NUMBER
ORG_CODE	VARCHAR2	(4000)
DEPT_CLASS	VARCHAR2	(10)
OWNING_DEPT_CODE	VARCHAR2	(4000)
DEPT_CODE	VARCHAR2	(10)
DEPT_DESC	VARCHAR2	(240)
RES_GROUP_NAME	VARCHAR2	(30)
RES_CODE	VARCHAR2	(16)
RES_DESC	VARCHAR2	(240)
RESOURCE_TYPE	NUMBER
RESOURCE_TYPE_TEXT	VARCHAR2	(4000)
RES_INSTANCE_ID	NUMBER
RES_INSTANCE_CODE	VARCHAR2	(4000)
EQUIPMENT_ITEM_NAME	VARCHAR2	(4000)
SERIAL_NUMBER	VARCHAR2	(30)
RES_SHORTAGE_TYPE	NUMBER
RES_EXCESS_TYPE	NUMBER
OVERUTILIZED_PERCENT	NUMBER
UNDERUTILIZED_PERCENT	NUMBER
UTILIZATION	NUMBER
EFFICIENCY	NUMBER
AGGREGATE_RESOURCE_FLAG	NUMBER
AVAILABLE_24_HOURS_FLAG	NUMBER
BATCHABLE_FLAG	NUMBER
UNIT_OF_MEASURE	VARCHAR2	(3)
BOTTLENECK_FLAG	NUMBER
CHARGEABLE_FLAG	NUMBER
CAPACITY_TOLERANCE	NUMBER
RES_OVERLOAD_EXCP	NUMBER
RES_CONST_EXCP	NUMBER
RES_EXC_SETUPS_EXCP	NUMBER
RES_UTILIZATION_EXCP	NUMBER

Query Text

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


SELECT PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      OWNING_DEPARTMENT_ID
,      ORG_CODE
,      DEPT_CLASS
,      OWNING_DEPT_CODE
,      DEPT_CODE
,      DEPT_DESC
,      RES_GROUP_NAME
,      RES_CODE
,      RES_DESC
,      RESOURCE_TYPE
,      RESOURCE_TYPE_TEXT
,      RES_INSTANCE_ID
,      RES_INSTANCE_CODE
,      EQUIPMENT_ITEM_NAME
,      SERIAL_NUMBER
,      RES_SHORTAGE_TYPE
,      RES_EXCESS_TYPE
,      OVERUTILIZED_PERCENT
,      UNDERUTILIZED_PERCENT
,      UTILIZATION
,      EFFICIENCY
,      AGGREGATE_RESOURCE_FLAG
,      AVAILABLE_24_HOURS_FLAG
,      BATCHABLE_FLAG
,      UNIT_OF_MEASURE
,      BOTTLENECK_FLAG
,      CHARGEABLE_FLAG
,      CAPACITY_TOLERANCE
,      RES_OVERLOAD_EXCP
,      RES_CONST_EXCP
,      RES_EXC_SETUPS_EXCP
,      RES_UTILIZATION_EXCP
FROM APPS.MSC_RES_AND_INST_V;

Dependencies

[top of page]

APPS.MSC_RES_AND_INST_V references the following:

APPS: MSC_DEPARTMENT_RESOURCES; MSC_DEPT_RES_INSTANCES; MSC_GANTT_UTILS - show dependent code; MSC_GET_NAME - show dependent code

APPS.MSC_RES_AND_INST_V is not referenced by any database object