[Home] [Help] [Dependency Information]
Object Name: | MRP_WIP_RESOURCES |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_WIP_RESOURCES |
Subobject Name: | |
Status: | VALID |
MRP_WIP_RESOURCES stores information on the resource usage of discrete
jobs. Each row includes the department, resource, operation sequence
number, sequence number of the resource within the operation, and the
hours of the resource required and expended for a specific operation.
In addition, each row also includes the start date of the operation.
.
FIRST_UNIT_START_DATE is the operation start date, or the job start
date, if the operation start date is unavailable. This column is used
by the CRP planner to decide when the resource is required.
SCHEDULE_COMPLETION_DATE is the operation completion date, or the job
completion date, if the operation completion date is unavailable.
.
This table is populated by the Snapshot, and used by the CRP Planner
in computing discrete job resource requirements.
.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_WIP_RESOURCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
COMPILE_DESIGNATOR DEPARTMENT_ID RESOURCE_ID WIP_ENTITY_ID OPERATION_SEQ_NUM RESOURCE_SEQ_NUM |
MRP_WIP_RESOURCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | WIP_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEPARTMENT_ID | NUMBER | Yes | Department identifier | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
COMPILE_DESIGNATOR | VARCHAR2 | (10) | Yes | MPS, MRP or DRP plan identifier |
RESOURCE_ID | NUMBER | Yes | Resource identifier | |
WIP_ENTITY_ID | NUMBER | Yes | WIP job or repetitive assembly identifier | |
OPERATION_SEQ_NUM | NUMBER | Yes | Manufacturing operation sequence number | |
RESOURCE_SEQ_NUM | NUMBER | Yes | Resource sequence number | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
FIRST_UNIT_START_DATE | DATE | Operation start or resource requirement date | ||
OPERATION_HOURS_REQUIRED | NUMBER | Yes | Job operation hours required | |
HOURS_EXPENDED | NUMBER | Yes | Job hours expended | |
BASIS_TYPE | NUMBER | Yes | Operation basis type | |
RESOURCE_UNITS | NUMBER | Resource units | ||
REQUEST_ID | NUMBER | Concurrent Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
PROGRAM_ID | NUMBER | Concurrent Who column | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier | |
WIP_JOB_TYPE | NUMBER | Job Type | ||
RESOURCE_END_DATE | DATE | Resource end date |
Cut, paste (and edit) the following text to query this object:
SELECT DEPARTMENT_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, RESOURCE_ID
, WIP_ENTITY_ID
, OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, FIRST_UNIT_START_DATE
, OPERATION_HOURS_REQUIRED
, HOURS_EXPENDED
, BASIS_TYPE
, RESOURCE_UNITS
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, WIP_JOB_TYPE
, RESOURCE_END_DATE
FROM MRP.MRP_WIP_RESOURCES;
MRP.MRP_WIP_RESOURCES does not reference any database object
MRP.MRP_WIP_RESOURCES is referenced by following:
|
|
|