eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MRP.MRP_PLANNED_RESOURCE_REQS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

MRP.MRP_PLANNED_RESOURCE_REQS does not reference any database object

MRP.MRP_PLANNED_RESOURCE_REQS is referenced by following:

APPS: MRP_PLANNED_RESOURCE_REQS