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 Mandatory 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:

SchemaAPPS
SynonymMSC_DEPARTMENT_RESOURCES
SynonymMSC_DEPT_RES_INSTANCES
SynonymMSC_NET_RESOURCE_AVAIL
SynonymMSC_NET_RES_INST_AVAIL

APPS.MSC_NET_RES_INST_AVAIL_V is not referenced by any database object