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

VIEW: MSC.MSC_ST_DEPARTMENT_RESOURCES#

Object Details
Object Name: MSC_ST_DEPARTMENT_RESOURCES#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ORGANIZATION_ID NUMBER

RESOURCE_ID NUMBER

RESOURCE_CODE VARCHAR2 (40)
DEPARTMENT_ID NUMBER

DEPARTMENT_CODE VARCHAR2 (10)
DEPARTMENT_CLASS VARCHAR2 (10)
LINE_FLAG VARCHAR2 (1)
OWNING_DEPARTMENT_ID NUMBER

CAPACITY_UNITS NUMBER

MAX_RATE NUMBER

MIN_RATE NUMBER

AGGREGATED_RESOURCE_ID NUMBER

AGGREGATED_RESOURCE_FLAG NUMBER

RESOURCE_GROUP_NAME VARCHAR2 (30)
RESOURCE_GROUP_CODE VARCHAR2 (10)
RESOURCE_BALANCE_FLAG NUMBER

BOTTLENECK_FLAG NUMBER

START_TIME NUMBER

STOP_TIME NUMBER

DEPARTMENT_DESCRIPTION VARCHAR2 (240)
RESOURCE_DESCRIPTION VARCHAR2 (240)
OVER_UTILIZED_PERCENT NUMBER

UNDER_UTILIZED_PERCENT NUMBER

RESOURCE_SHORTAGE_TYPE NUMBER

RESOURCE_EXCESS_TYPE NUMBER

USER_TIME_FENCE NUMBER

UTILIZATION NUMBER

EFFICIENCY NUMBER

RESOURCE_INCLUDE_FLAG NUMBER

CRITICAL_RESOURCE_FLAG NUMBER

RESOURCE_TYPE NUMBER

DISABLE_DATE DATE

LINE_DISABLE_DATE DATE

AVAILABLE_24_HOURS_FLAG NUMBER

CTP_FLAG NUMBER

DELETED_FLAG NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SR_INSTANCE_ID NUMBER

REFRESH_ID NUMBER

DEPT_OVERHEAD_COST NUMBER

RESOURCE_COST NUMBER

RESOURCE_OVER_UTIL_COST NUMBER

PLANNING_EXCEPTION_SET VARCHAR2 (10)
BATCHABLE_FLAG NUMBER

BATCHING_WINDOW NUMBER

MIN_CAPACITY NUMBER

MAX_CAPACITY NUMBER

UNIT_OF_MEASURE VARCHAR2 (3)
UOM_CLASS_TYPE NUMBER

COMPANY_ID NUMBER

COMPANY_NAME VARCHAR2 (255)
OWNING_DEPARTMENT_CODE VARCHAR2 (10)
ORGANIZATION_CODE VARCHAR2 (7)
SR_INSTANCE_CODE VARCHAR2 (3)
MESSAGE_ID NUMBER

PROCESS_FLAG NUMBER

ERROR_TEXT VARCHAR2 (2000)
ST_TRANSACTION_ID NUMBER

BATCH_ID NUMBER

DATA_SOURCE_TYPE VARCHAR2 (15)
ATP_RULE_ID NUMBER

SOURCE_ORGANIZATION_ID NUMBER

SOURCE_DEPARTMENT_ID NUMBER

SOURCE_RESOURCE_ID NUMBER

SOURCE_OWNING_DEPARTMENT_ID NUMBER

CAPACITY_TOLERANCE NUMBER

CHARGEABLE_FLAG NUMBER

IDLE_TIME_TOLERANCE NUMBER

BATCHING_PENALTY NUMBER

LAST_KNOWN_SETUP NUMBER

SCHEDULE_TO_INSTANCE NUMBER

SDS_SCHEDULING_WINDOW NUMBER

SETUP_TIME_PERCENT NUMBER

UTILIZATION_CHANGE_PERCENT NUMBER

SETUP_TIME_TYPE NUMBER

UTILIZATION_CHANGE_TYPE NUMBER

Query Text

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


SELECT ORGANIZATION_ID
,      RESOURCE_ID
,      RESOURCE_CODE
,      DEPARTMENT_ID
,      DEPARTMENT_CODE
,      DEPARTMENT_CLASS
,      LINE_FLAG
,      OWNING_DEPARTMENT_ID
,      CAPACITY_UNITS
,      MAX_RATE
,      MIN_RATE
,      AGGREGATED_RESOURCE_ID
,      AGGREGATED_RESOURCE_FLAG
,      RESOURCE_GROUP_NAME
,      RESOURCE_GROUP_CODE
,      RESOURCE_BALANCE_FLAG
,      BOTTLENECK_FLAG
,      START_TIME
,      STOP_TIME
,      DEPARTMENT_DESCRIPTION
,      RESOURCE_DESCRIPTION
,      OVER_UTILIZED_PERCENT
,      UNDER_UTILIZED_PERCENT
,      RESOURCE_SHORTAGE_TYPE
,      RESOURCE_EXCESS_TYPE
,      USER_TIME_FENCE
,      UTILIZATION
,      EFFICIENCY
,      RESOURCE_INCLUDE_FLAG
,      CRITICAL_RESOURCE_FLAG
,      RESOURCE_TYPE
,      DISABLE_DATE
,      LINE_DISABLE_DATE
,      AVAILABLE_24_HOURS_FLAG
,      CTP_FLAG
,      DELETED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SR_INSTANCE_ID
,      REFRESH_ID
,      DEPT_OVERHEAD_COST
,      RESOURCE_COST
,      RESOURCE_OVER_UTIL_COST
,      PLANNING_EXCEPTION_SET
,      BATCHABLE_FLAG
,      BATCHING_WINDOW
,      MIN_CAPACITY
,      MAX_CAPACITY
,      UNIT_OF_MEASURE
,      UOM_CLASS_TYPE
,      COMPANY_ID
,      COMPANY_NAME
,      OWNING_DEPARTMENT_CODE
,      ORGANIZATION_CODE
,      SR_INSTANCE_CODE
,      MESSAGE_ID
,      PROCESS_FLAG
,      ERROR_TEXT
,      ST_TRANSACTION_ID
,      BATCH_ID
,      DATA_SOURCE_TYPE
,      ATP_RULE_ID
,      SOURCE_ORGANIZATION_ID
,      SOURCE_DEPARTMENT_ID
,      SOURCE_RESOURCE_ID
,      SOURCE_OWNING_DEPARTMENT_ID
,      CAPACITY_TOLERANCE
,      CHARGEABLE_FLAG
,      IDLE_TIME_TOLERANCE
,      BATCHING_PENALTY
,      LAST_KNOWN_SETUP
,      SCHEDULE_TO_INSTANCE
,      SDS_SCHEDULING_WINDOW
,      SETUP_TIME_PERCENT
,      UTILIZATION_CHANGE_PERCENT
,      SETUP_TIME_TYPE
,      UTILIZATION_CHANGE_TYPE
FROM MSC.MSC_ST_DEPARTMENT_RESOURCES#;

Dependencies

[top of page]

MSC.MSC_ST_DEPARTMENT_RESOURCES# references the following:

SchemaMSC
TableMSC_ST_DEPARTMENT_RESOURCES
MSC.MSC_ST_DEPARTMENT_RESOURCES# is referenced by following:

SchemaAPPS
SynonymMSC_ST_DEPARTMENT_RESOURCES