[Home] [Help] [Dependency Information]
Object Name: | MRP_PLANNED_RESOURCE_REQS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_PLANNED_RESOURCE_REQS |
Subobject Name: | |
Status: | VALID |
MRP_PLANNED_RESOURCE_REQS stores information on the resource usage of
assemblies. Each row includes the department, resource, and the units
of resource required for a specific operation. In addition to the
operation sequence number, each row also includes the resource offset
percent which tells Oracle Capacity where in the lead time of the
assembly the resource is required. RUNTIME_QUANTITY stores the
quantity of resource required for the operation specified.
.
Planning only looks at operations which can be scheduled. That is,
entries with a basis type of "item" or "lot".
.
This table is populated by the Snapshot and used by the CRP Planner.
This table is derived primarily from BOM_OPERATION_SEQUENCES.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_PLANNED_RESOURCE_REQS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USING_ASSEMBLY_ITEM_ID |
MRP_PLANNED_RESOURCE_REQS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
COMPILE_DESIGNATOR DEPARTMENT_ID RESOURCE_ID USING_ASSEMBLY_ITEM_ID OPERATION_SEQ_NUM RESOURCE_SEQ_NUM ALTERNATE_ROUTING_DESIGNATOR SOURCE_ITEM_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 | |
LINE_ID | NUMBER | Line identifier | ||
USING_ASSEMBLY_ITEM_ID | NUMBER | Yes | Using assembly item 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 | ||
ALTERNATE_ROUTING_DESIGNATOR | VARCHAR2 | (10) | Alternate routing designator | |
RUNTIME_QUANTITY | NUMBER | Yes | Runtime resource quantity required | |
RESOURCE_OFFSET_PERCENT | NUMBER | Component resource offset percent | ||
SETBACK_DAYS | NUMBER | Days setback from the assembly due date when the resource is required. | ||
BASIS | NUMBER | Yes | Operation basis | |
RESOURCE_UNITS | NUMBER | Operation 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 | ||
SOURCE_ITEM_ID | NUMBER | Source Item Identifier | ||
ASSEMBLY_USAGE | NUMBER | Component usage of the source item for the assembly | ||
EFFECTIVITY_DATE | DATE | Effective date of the routing | ||
DISABLE_DATE | DATE | Disable Date of the Routing |
Cut, paste (and edit) the following text to query this object:
SELECT DEPARTMENT_ID
, ORGANIZATION_ID
, COMPILE_DESIGNATOR
, RESOURCE_ID
, LINE_ID
, USING_ASSEMBLY_ITEM_ID
, OPERATION_SEQ_NUM
, RESOURCE_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ALTERNATE_ROUTING_DESIGNATOR
, RUNTIME_QUANTITY
, RESOURCE_OFFSET_PERCENT
, SETBACK_DAYS
, BASIS
, RESOURCE_UNITS
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SOURCE_ITEM_ID
, ASSEMBLY_USAGE
, EFFECTIVITY_DATE
, DISABLE_DATE
FROM MRP.MRP_PLANNED_RESOURCE_REQS;
MRP.MRP_PLANNED_RESOURCE_REQS does not reference any database object
MRP.MRP_PLANNED_RESOURCE_REQS is referenced by following:
|
|
|