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

TABLE: MSC.MSC_RESOURCE_REQUIREMENTS

Object Details
Object Name: MSC_RESOURCE_REQUIREMENTS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_RESOURCE_REQUIREMENTS
Subobject Name:
Status: VALID


This table stores the resource requirments generated by existing supplies.


Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_RESOURCE_REQUIREMENTS_U1 NORMAL UNIQUE Tablespace ColumnPLAN_ID
ColumnTRANSACTION_ID
ColumnSR_INSTANCE_ID
MSC_RESOURCE_REQUIREMENTS_N1 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnAPPLIED
ColumnSTATUS
ColumnUPDATED
MSC_RESOURCE_REQUIREMENTS_N2 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnDEPARTMENT_ID
ColumnRESOURCE_ID
ColumnSUPPLY_ID
ColumnOPERATION_SEQ_NUM
MSC_RESOURCE_REQUIREMENTS_N3 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSUPPLY_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnWIP_ENTITY_ID
MSC_RESOURCE_REQUIREMENTS_N4 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnWIP_ENTITY_ID
ColumnOPERATION_SEQ_NUM
MSC_RESOURCE_REQUIREMENTS_N5 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnSUPPLY_ID
ColumnFIRM_FLAG
ColumnPARENT_ID
MSC_RESOURCE_REQUIREMENTS_N6 NORMAL NONUNIQUE Tablespace ColumnPLAN_ID
ColumnSR_INSTANCE_ID
ColumnORGANIZATION_ID
ColumnASSEMBLY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Resource requirement identifier
PLAN_ID NUMBER
Yes Plan identifier
SUPPLY_ID NUMBER
Yes Supplier identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
SR_INSTANCE_ID NUMBER
Yes Source instance identifier for the source org
ROUTING_SEQUENCE_ID NUMBER

Routing identifier used
OPERATION_SEQUENCE_ID NUMBER

Operation sequence identifier which generating the requirement
RESOURCE_SEQ_NUM NUMBER
Yes Identifier of the planned resource requirement
RESOURCE_ID NUMBER
Yes Resource identifier
DEPARTMENT_ID NUMBER

Department identifier
ALTERNATE_NUM NUMBER

Alternate number of the corresponding operation resource
START_DATE DATE
Yes Start date of the resource requirement
END_DATE DATE

End date of the resource requirement
BKT_START_DATE NUMBER

Bucketed start date
RESOURCE_HOURS NUMBER
Yes Resource hours required
SET_UP NUMBER

Setup time
BKT_END_DATE NUMBER

Bucketed end date
TEAR_DOWN NUMBER

Tear down time
AGGREGATE_RESOURCE_ID NUMBER

Reference to aggregate resource, if resource aggregated (denormalized column)
SCHEDULE_FLAG NUMBER

Schedule flag
PARENT_ID NUMBER

Referent to parent transaction identifier
STD_OP_CODE VARCHAR2 (4)
Standard op code
WIP_ENTITY_ID NUMBER

Wip entity identifier for DJ resource requirements
ASSIGNED_UNITS NUMBER
Yes Assigned units
BASIS_TYPE NUMBER

Basis type
OPERATION_SEQ_NUM NUMBER

Operation seq Number
LOAD_RATE NUMBER

Load rate
DAILY_RESOURCE_HOURS NUMBER

Daily resource hours needed for repetitive schedules
STATUS NUMBER

Attribute used for online replanning
APPLIED NUMBER

Attribute used for online replanning
UPDATED NUMBER

Flag to determine whether add workday modification was applied
SUBST_RES_FLAG NUMBER

Flag indicating whether resource is substitute resource
REFRESH_NUMBER NUMBER

Refresh number populated by the collection program
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
REQUEST_ID NUMBER

Standard Who column
PROGRAM_APPLICATION_ID NUMBER

Standard Who column
PROGRAM_ID NUMBER

Standard Who column
PROGRAM_UPDATE_DATE DATE

Standard Who column
SOURCE_ITEM_ID NUMBER (38)
Source inventory item unique identifier
ASSEMBLY_ITEM_ID NUMBER (38)
Assembly item unique identifier
SUPPLY_TYPE NUMBER (38)
Sypply type code
FIRM_START_DATE DATE

Firm start date
FIRM_END_DATE DATE

Firm end date
FIRM_FLAG NUMBER

Firm flag
CUMMULATIVE_QUANTITY NUMBER

Resource requirement identifier
YIELD NUMBER

Yield
REVERSE_CUMULATIVE_YIELD NUMBER

Reverse cumulative yield
BATCH_NUMBER NUMBER

Batch Number
MINIMUM_TRANSFER_QUANTITY NUMBER

Department identifier
REMAINING_CAPACITY NUMBER

Remaining Capacity
OVERLOADED_CAPACITY NUMBER

overloaded capacity
EARLIEST_START_DATE DATE

For Improved Exceptions
EARLIEST_COMPLETION_DATE DATE

For Improved Exceptions
SCHEDULED_DEMAND_ID NUMBER

For Improved Exceptions
ULPSD DATE

Unconstrained Latest Possible Start Date/Time
ULPCD DATE

Unconstrained Latest Possible Completion Date/Time
UEPSD DATE

Unconstrained Earliest Possible Start Date/Time
UEPCD DATE

Unconstrained Earliest Possible Completion Date/Time
EACD DATE

Earliest Allowable Completion Date/Time
PARENT_SEQ_NUM NUMBER

Schedule sequence number of the parent resource sequence. Used for Sequence Dependent Setups
SETUP_ID NUMBER

Setup Identifier
QUANTITY_IN_QUEUE NUMBER

Number of units in Queue of the operation
QUANTITY_RUNNING NUMBER

Number of units in To Run of the operation
QUANTITY_WAITING_TO_MOVE NUMBER

Number of units waiting To Move in the operation
QUANTITY_COMPLETED NUMBER

Number of units completed by the operation
USAGE_RATE NUMBER

Rate per assembly or amount per job/schedule
HOURS_EXPENDED NUMBER

Hours expended on a resource of a Job
RECORD_SOURCE NUMBER

For requirements generated by ATP
ACTIVITY_GROUP_ID NUMBER

Activity group identifier.
PRINCIPAL_FLAG NUMBER

Principal flag
ORIG_RESOURCE_SEQ_NUM NUMBER

Orig Resource Seq Num
GROUP_SEQUENCE_ID NUMBER

Identifies the firmed fixed sequence
GROUP_SEQUENCE_NUMBER NUMBER

Sequence in firmed sequence
MAXIMUM_ASSIGNED_UNITS NUMBER

Maximum assigned units
MINIMUM_CAPACITY NUMBER

This will be in the same capcity as department resource capacity uom
MAXIMUM_CAPACITY NUMBER

Maximum Batch Capacity
BREAKABLE_ACTIVITY_FLAG NUMBER

1 If activity is breakable2 if activity is not breakable
CAPACITY_CONSUMED_RATIO NUMBER

Ratio of capacity used and resource capacity
FROM_SETUP_ID NUMBER

For sds acitivity: transition from_setup_id
STEP_QUANTITY NUMBER

Quantity associated with an operation. Populated for opm jobs
STEP_QUANTITY_UOM VARCHAR2 (3)
UOM of the step quantity
UNADJUSTED_RESOURCE_HOURS NUMBER

resource hours unadjusted for utilization and efficiency
TOUCH_TIME NUMBER

unadjusted resource hours inflated for efficiency
JIT_END_DATE DATE

UNBUCKETED_START_DATE DATE

Unbucketed Start Date
UNBUCKETED_END_DATE DATE

Unbucketed End Date
ACTUAL_START_DATE DATE

An actual operation start date.
TOTAL_RESOURCE_HOURS NUMBER

Total (inflated) Resource hours required for an activity of a job
ACTIVITY_NAME VARCHAR2 (20)
OPERATION_NAME VARCHAR2 (20)
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
,      JIT_END_DATE
,      UNBUCKETED_START_DATE
,      UNBUCKETED_END_DATE
,      ACTUAL_START_DATE
,      TOTAL_RESOURCE_HOURS
,      ACTIVITY_NAME
,      OPERATION_NAME
FROM MSC.MSC_RESOURCE_REQUIREMENTS;

Dependencies

[top of page]

MSC.MSC_RESOURCE_REQUIREMENTS does not reference any database object

MSC.MSC_RESOURCE_REQUIREMENTS is referenced by following:

SchemaAPPS
SynonymMSC_RESOURCE_REQUIREMENTS