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_NET_RES_INST_AVAIL_V

Object Details

Object Name:	MSC_NET_RES_INST_AVAIL_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	Comments
ROW_ID	ROWID	(10)	Row Identifier
PLAN_ID	NUMBER		Plan Identifier
SHIFT_DATE	DATE		Shift Date
SHIFT_NUM	NUMBER		Shift Number
FROM_TIME	VARCHAR2	(8)	From Time
TO_TIME	VARCHAR2	(8)	To Time
ORGANIZATION_ID	NUMBER		Organization Identifier
DEPARTMENT_ID	NUMBER		Department Identifier
RESOURCE_ID	NUMBER		Resource Identifier
RES_INSTANCE_ID	NUMBER		Resource Instance Identifier
UPDATED	NUMBER		Updated
STATUS	NUMBER		Status
APPLIED	NUMBER		Applied
SR_INSTANCE_ID	NUMBER		SR Instance Identifier
LAST_UPDATE_DATE	DATE		Last Update Date
LAST_UPDATED_BY	NUMBER		Last Updated By
CREATION_DATE	DATE		Creation Date
CREATED_BY	NUMBER		Created By
LAST_UPDATE_LOGIN	NUMBER		Last Updated Login
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number
SIMULATION_SET	VARCHAR2	(10)	Simulation Set
START_TIME	NUMBER		Start Time
END_TIME	NUMBER		End Time
CAPACITY_UNITS	NUMBER		Capacity Units

Query Text

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


SELECT ROW_ID
,      PLAN_ID
,      SHIFT_DATE
,      SHIFT_NUM
,      FROM_TIME
,      TO_TIME
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      RES_INSTANCE_ID
,      UPDATED
,      STATUS
,      APPLIED
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SERIAL_NUMBER
,      SIMULATION_SET
,      START_TIME
,      END_TIME
,      CAPACITY_UNITS
FROM APPS.MSC_NET_RES_INST_AVAIL_V;

Dependencies

[top of page]

APPS.MSC_NET_RES_INST_AVAIL_V references the following:

APPS: MSC_DEPARTMENT_RESOURCES; MSC_DEPT_RES_INSTANCES; MSC_NET_RESOURCE_AVAIL; MSC_NET_RES_INST_AVAIL

APPS.MSC_NET_RES_INST_AVAIL_V is not referenced by any database object