DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_RESOURCE_INSTANCES_V

Object Details
Object Name: MSC_RESOURCE_INSTANCES_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 Id
DEPT_RESOURCE_INST_ID NUMBER
Yes Dept Resource Inst Id
PLAN_ID NUMBER
Yes Plan Id
SR_INSTANCE_ID NUMBER
Yes Sr Instance Id
RES_INSTANCE_ID NUMBER
Yes Res Instance Id
RESOURCE_ID NUMBER
Yes Resource Id
DEPARTMENT_ID NUMBER
Yes Department Id
ORGANIZATION_ID NUMBER
Yes Organization Id
SERIAL_NUMBER VARCHAR2 (30)
Serial Number
EQUIPMENT_ITEM_ID NUMBER

Equipment Item Id
EQUIPMENT_NAME VARCHAR2 (4000)
Equipment Name
EFFECTIVE_START_DATE DATE

Effective Start Date
EFFECTIVE_END_DATE DATE

Effective End Date
LAST_KNOWN_SETUP NUMBER

Last Known Setup
SETUP_CODE VARCHAR2 (100)
Setup Code
DESCRIPTION VARCHAR2 (4000)
Description
Query Text

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


SELECT ROW_ID
,      DEPT_RESOURCE_INST_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      RES_INSTANCE_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      ORGANIZATION_ID
,      SERIAL_NUMBER
,      EQUIPMENT_ITEM_ID
,      EQUIPMENT_NAME
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      LAST_KNOWN_SETUP
,      SETUP_CODE
,      DESCRIPTION
FROM APPS.MSC_RESOURCE_INSTANCES_V;

Dependencies

[top of page]

APPS.MSC_RESOURCE_INSTANCES_V references the following:

SchemaAPPS
SynonymMSC_DEPARTMENT_RESOURCES
SynonymMSC_DEPT_RES_INSTANCES
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_RESOURCE_SETUPS

APPS.MSC_RESOURCE_INSTANCES_V is not referenced by any database object