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

VIEW: MSC.MSC_STORE_RESOURCE_REQS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes
PLAN_ID NUMBER
Yes
SUPPLY_ID NUMBER
Yes
ORGANIZATION_ID NUMBER
Yes
SR_INSTANCE_ID NUMBER
Yes
ROUTING_SEQUENCE_ID NUMBER

OPERATION_SEQUENCE_ID NUMBER

RESOURCE_SEQ_NUM NUMBER
Yes
RESOURCE_ID NUMBER
Yes
DEPARTMENT_ID NUMBER

ALTERNATE_NUM NUMBER

START_DATE DATE
Yes
END_DATE DATE

BKT_START_DATE NUMBER

RESOURCE_HOURS NUMBER
Yes
SET_UP NUMBER

BKT_END_DATE NUMBER

TEAR_DOWN NUMBER

AGGREGATE_RESOURCE_ID NUMBER

SCHEDULE_FLAG NUMBER

PARENT_ID NUMBER

STD_OP_CODE VARCHAR2 (4)
WIP_ENTITY_ID NUMBER

ASSIGNED_UNITS NUMBER
Yes
BASIS_TYPE NUMBER

OPERATION_SEQ_NUM NUMBER

LOAD_RATE NUMBER

DAILY_RESOURCE_HOURS NUMBER

STATUS NUMBER

APPLIED NUMBER

UPDATED NUMBER

SUBST_RES_FLAG NUMBER

REFRESH_NUMBER NUMBER

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

REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

SOURCE_ITEM_ID NUMBER (38)
ASSEMBLY_ITEM_ID NUMBER (38)
SUPPLY_TYPE NUMBER (38)
FIRM_START_DATE DATE

FIRM_END_DATE DATE

FIRM_FLAG NUMBER

CUMMULATIVE_QUANTITY NUMBER

YIELD NUMBER

REVERSE_CUMULATIVE_YIELD NUMBER

BATCH_NUMBER NUMBER

MINIMUM_TRANSFER_QUANTITY NUMBER

REMAINING_CAPACITY NUMBER

OVERLOADED_CAPACITY NUMBER

EARLIEST_START_DATE DATE

EARLIEST_COMPLETION_DATE DATE

SCHEDULED_DEMAND_ID NUMBER

ULPSD DATE

ULPCD DATE

UEPSD DATE

UEPCD DATE

EACD DATE

PARENT_SEQ_NUM NUMBER

SETUP_ID NUMBER

QUANTITY_IN_QUEUE NUMBER

QUANTITY_RUNNING NUMBER

QUANTITY_WAITING_TO_MOVE NUMBER

QUANTITY_COMPLETED NUMBER

USAGE_RATE NUMBER

HOURS_EXPENDED NUMBER

RECORD_SOURCE NUMBER

ACTIVITY_GROUP_ID NUMBER

PRINCIPAL_FLAG NUMBER

ORIG_RESOURCE_SEQ_NUM NUMBER

GROUP_SEQUENCE_ID NUMBER

GROUP_SEQUENCE_NUMBER NUMBER

MAXIMUM_ASSIGNED_UNITS NUMBER

MINIMUM_CAPACITY NUMBER

MAXIMUM_CAPACITY NUMBER

BREAKABLE_ACTIVITY_FLAG NUMBER

CAPACITY_CONSUMED_RATIO NUMBER

FROM_SETUP_ID NUMBER

STEP_QUANTITY NUMBER

STEP_QUANTITY_UOM VARCHAR2 (3)
UNADJUSTED_RESOURCE_HOURS NUMBER

TOUCH_TIME NUMBER

UNBUCKETED_START_DATE DATE

UNBUCKETED_END_DATE DATE

ACTUAL_START_DATE DATE

TOTAL_RESOURCE_HOURS NUMBER

JIT_END_DATE DATE

Query Text

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


SELECT TRANSACTION_ID
,      PLAN_ID
,      SUPPLY_ID
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      ROUTING_SEQUENCE_ID
,      OPERATION_SEQUENCE_ID
,      RESOURCE_SEQ_NUM
,      RESOURCE_ID
,      DEPARTMENT_ID
,      ALTERNATE_NUM
,      START_DATE
,      END_DATE
,      BKT_START_DATE
,      RESOURCE_HOURS
,      SET_UP
,      BKT_END_DATE
,      TEAR_DOWN
,      AGGREGATE_RESOURCE_ID
,      SCHEDULE_FLAG
,      PARENT_ID
,      STD_OP_CODE
,      WIP_ENTITY_ID
,      ASSIGNED_UNITS
,      BASIS_TYPE
,      OPERATION_SEQ_NUM
,      LOAD_RATE
,      DAILY_RESOURCE_HOURS
,      STATUS
,      APPLIED
,      UPDATED
,      SUBST_RES_FLAG
,      REFRESH_NUMBER
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SOURCE_ITEM_ID
,      ASSEMBLY_ITEM_ID
,      SUPPLY_TYPE
,      FIRM_START_DATE
,      FIRM_END_DATE
,      FIRM_FLAG
,      CUMMULATIVE_QUANTITY
,      YIELD
,      REVERSE_CUMULATIVE_YIELD
,      BATCH_NUMBER
,      MINIMUM_TRANSFER_QUANTITY
,      REMAINING_CAPACITY
,      OVERLOADED_CAPACITY
,      EARLIEST_START_DATE
,      EARLIEST_COMPLETION_DATE
,      SCHEDULED_DEMAND_ID
,      ULPSD
,      ULPCD
,      UEPSD
,      UEPCD
,      EACD
,      PARENT_SEQ_NUM
,      SETUP_ID
,      QUANTITY_IN_QUEUE
,      QUANTITY_RUNNING
,      QUANTITY_WAITING_TO_MOVE
,      QUANTITY_COMPLETED
,      USAGE_RATE
,      HOURS_EXPENDED
,      RECORD_SOURCE
,      ACTIVITY_GROUP_ID
,      PRINCIPAL_FLAG
,      ORIG_RESOURCE_SEQ_NUM
,      GROUP_SEQUENCE_ID
,      GROUP_SEQUENCE_NUMBER
,      MAXIMUM_ASSIGNED_UNITS
,      MINIMUM_CAPACITY
,      MAXIMUM_CAPACITY
,      BREAKABLE_ACTIVITY_FLAG
,      CAPACITY_CONSUMED_RATIO
,      FROM_SETUP_ID
,      STEP_QUANTITY
,      STEP_QUANTITY_UOM
,      UNADJUSTED_RESOURCE_HOURS
,      TOUCH_TIME
,      UNBUCKETED_START_DATE
,      UNBUCKETED_END_DATE
,      ACTUAL_START_DATE
,      TOTAL_RESOURCE_HOURS
,      JIT_END_DATE
FROM MSC.MSC_STORE_RESOURCE_REQS#;

Dependencies

[top of page]

MSC.MSC_STORE_RESOURCE_REQS# references the following:

SchemaMSC
TableMSC_STORE_RESOURCE_REQS
MSC.MSC_STORE_RESOURCE_REQS# is referenced by following:

SchemaAPPS
SynonymMSC_STORE_RESOURCE_REQS