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

VIEW: APPS.MSC_RESOURCE_PARAMETERS_V

Object Details
Object Name: MSC_RESOURCE_PARAMETERS_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
ORGANIZATION_ID NUMBER
Yes Organization ID
ORGANIZATION_CODE VARCHAR2 (7)
Organization Code
SR_INSTANCE_ID NUMBER
Yes Sr Instance ID
DEPARTMENT_ID NUMBER
Yes Department ID
DEPARTMENT_CODE VARCHAR2 (10)
Department Code
RESOURCE_ID NUMBER
Yes Resource ID
RESOURCE_CODE VARCHAR2 (16)
Resource Code
RESOURCE_DESCRIPTION VARCHAR2 (240)
Resource Description
RESOURCE_TYPE_ID NUMBER
Yes Resource Type ID
RESOURCE_TYPE VARCHAR2 (4000)
Resource Type
BATCHABLE NUMBER

Batchable
AVAILABLE_SPOTS NUMBER

Availbale Spots
CRO NUMBER

CRO
MIN_CYCLE_TIME NUMBER

Min Cycle Time
MIN_CYCLE_TIME_UNIT_ID NUMBER

Min Cycle Time Unit ID
MIN_CYCLE_TIME_UNIT VARCHAR2 (4000)
Min Cycle Time Unit
MIN_CHANGE_BET_CYCLES NUMBER

Min Change Bet Cycles
OFFLOAD_PERCENTAGE NUMBER

Offload Percentage
OFFLOAD_WINDOW NUMBER

Offload Window
OFFLOAD_WINDOW_UNIT_ID NUMBER

Offload Window Unit ID
OFFLOAD_WINDOW_UNIT VARCHAR2 (4000)
Offload Window Unit
INV_RELEASE_INTERVAL NUMBER

Inv Release Interval
INV_REL_INTERVAL_UNIT_ID NUMBER

Inv Rel Interval Unit ID
INV_REL_INTERVAL_UNIT VARCHAR2 (4000)
Inv Rel Interval Unit
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER

Standard Who Column
CREATION_DATE DATE

Standard Who Column
CREATED_BY NUMBER

Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
MINIMIZE_IDLE_TIME NUMBER

SCHEDULE_OBJECTIVE NUMBER

CHGOVER_PREBUILD_MAX NUMBER

CHGOVER_PREBUILD_MAX_UOM NUMBER

Query Text

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


SELECT ROW_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      SR_INSTANCE_ID
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      RESOURCE_ID
,      RESOURCE_CODE
,      RESOURCE_DESCRIPTION
,      RESOURCE_TYPE_ID
,      RESOURCE_TYPE
,      BATCHABLE
,      AVAILABLE_SPOTS
,      CRO
,      MIN_CYCLE_TIME
,      MIN_CYCLE_TIME_UNIT_ID
,      MIN_CYCLE_TIME_UNIT
,      MIN_CHANGE_BET_CYCLES
,      OFFLOAD_PERCENTAGE
,      OFFLOAD_WINDOW
,      OFFLOAD_WINDOW_UNIT_ID
,      OFFLOAD_WINDOW_UNIT
,      INV_RELEASE_INTERVAL
,      INV_REL_INTERVAL_UNIT_ID
,      INV_REL_INTERVAL_UNIT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MINIMIZE_IDLE_TIME
,      SCHEDULE_OBJECTIVE
,      CHGOVER_PREBUILD_MAX
,      CHGOVER_PREBUILD_MAX_UOM
FROM APPS.MSC_RESOURCE_PARAMETERS_V;

Dependencies

[top of page]

APPS.MSC_RESOURCE_PARAMETERS_V references the following:

SchemaAPPS
SynonymMSC_DEPARTMENT_RESOURCES
PL/SQL PackageMSC_GET_NAME - show dependent code
SynonymMSC_RESOURCE_PARAMETERS
SynonymMSC_TRADING_PARTNERS

APPS.MSC_RESOURCE_PARAMETERS_V is not referenced by any database object