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

VIEW: MSC.MSC_OPERATION_RESOURCE_SEQS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
PLAN_ID NUMBER
Yes
ROUTING_SEQUENCE_ID NUMBER
Yes
OPERATION_SEQUENCE_ID NUMBER
Yes
RESOURCE_SEQ_NUM NUMBER
Yes
SCHEDULE_FLAG NUMBER
Yes
RESOURCE_OFFSET_PERCENT NUMBER

DEPARTMENT_ID NUMBER

SR_INSTANCE_ID NUMBER
Yes
REFRESH_NUMBER NUMBER

LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

CUMMULATIVE_PCT NUMBER

ACTIVITY_GROUP_ID NUMBER

ORGANIZATION_ID NUMBER

NEW_PLAN_ID NUMBER

NEW_PLAN_LIST VARCHAR2 (256)
APPLIED NUMBER

SIMULATION_SET_ID NUMBER

Query Text

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


SELECT PLAN_ID
,      ROUTING_SEQUENCE_ID
,      OPERATION_SEQUENCE_ID
,      RESOURCE_SEQ_NUM
,      SCHEDULE_FLAG
,      RESOURCE_OFFSET_PERCENT
,      DEPARTMENT_ID
,      SR_INSTANCE_ID
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CUMMULATIVE_PCT
,      ACTIVITY_GROUP_ID
,      ORGANIZATION_ID
,      NEW_PLAN_ID
,      NEW_PLAN_LIST
,      APPLIED
,      SIMULATION_SET_ID
FROM MSC.MSC_OPERATION_RESOURCE_SEQS#;

Dependencies

[top of page]

MSC.MSC_OPERATION_RESOURCE_SEQS# references the following:

SchemaMSC
TableMSC_OPERATION_RESOURCE_SEQS
MSC.MSC_OPERATION_RESOURCE_SEQS# is referenced by following:

SchemaAPPS
SynonymMSC_OPERATION_RESOURCE_SEQS