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

VIEW: APPS.MSC_RESOURCE_BATCHES_V

Object Details
Object Name: MSC_RESOURCE_BATCHES_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)
DEPARTMENT_CODE VARCHAR2 (10)
RESOURCE_CODE VARCHAR2 (16)
BATCH_NUMBER NUMBER
Yes
START_DATE DATE
Yes
END_DATE DATE
Yes
RESOURCE_HOURS NUMBER

MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

BATCH_CAPACITY_USED NUMBER

CAPACITY_UTILIZATION NUMBER

BATCHABLE_UOM VARCHAR2 (4000)
ORGANIZATION_CODE VARCHAR2 (4000)
PLAN_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
DEPARTMENT_ID NUMBER
Yes
RESOURCE_ID NUMBER
Yes
DEPARTMENT_DESCRIPTION VARCHAR2 (240)
DEPARTMENT_CLASS VARCHAR2 (10)
RESOURCE_TYPE NUMBER

RESOURCE_GROUP_NAME VARCHAR2 (30)
SOURCE_TABLE CHAR (24)
Query Text

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


SELECT ROW_ID
,      DEPARTMENT_CODE
,      RESOURCE_CODE
,      BATCH_NUMBER
,      START_DATE
,      END_DATE
,      RESOURCE_HOURS
,      MIN_CAPACITY
,      MAX_CAPACITY
,      BATCH_CAPACITY_USED
,      CAPACITY_UTILIZATION
,      BATCHABLE_UOM
,      ORGANIZATION_CODE
,      PLAN_ID
,      SR_INSTANCE_ID
,      ORGANIZATION_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      DEPARTMENT_DESCRIPTION
,      DEPARTMENT_CLASS
,      RESOURCE_TYPE
,      RESOURCE_GROUP_NAME
,      SOURCE_TABLE
FROM APPS.MSC_RESOURCE_BATCHES_V;

Dependencies

[top of page]

APPS.MSC_RESOURCE_BATCHES_V references the following:

SchemaAPPS
SynonymMSC_DEPARTMENT_RESOURCES
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_RESOURCE_BATCHES

APPS.MSC_RESOURCE_BATCHES_V is not referenced by any database object