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_WIP_COMPONENTS

Object Details

Object Name:	MRP_WIP_COMPONENTS
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_WIP_COMPONENTS
Subobject Name:
Status:	VALID

MRP_WIP_COMPONENTS stores information on component requirements for
discrete jobs, repetitive schedules and nonstandard jobs.
.
For discrete jobs, JOB_REFERENCE_ITEM_ID will store the item for which
the job is defined, and each component on the job will have a row in
MRP_WIP_COMPONENTS. ALLOCATED_QUANTITY will hold the quantity of the
requirement. For repetitive schedules, MRP_WIP_COMPONENTS is used to
record the quantity of a component that has already been issued to a
schedule. A given component of a schedule will have at most one row
in MRP_WIP_COMPONENTS, and NET_QUANTITY will hold the total quantity
of that component that has been issued so far. For nonstandard jobs,
components can be considered either supply or demand, as determined by
SUPPLY_DEMAND_TYPE.
.
For components of a nonstandard job that are to be considered supply,
NET_QUANTITY will hold the quantity of that supply. For components
that are to be considered demand, ALLOCATED_QUANTITY holds the
quantity of that demand.
.
For header records of a nonstandard job, MRP_WIP_COMPONENTS will store
a row if that header record is to be netted by the planning process.
.
MRP_WIP_COMPONENTS is populated by the Snapshot and used by the
Planner. It is derived mainly from WIP_REQUIREMENT_OPERATIONS.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_WIP_COMPONENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR INVENTORY_ITEM_ID WIP_ENTITY_ID JOB_REFERENCE_ITEM_ID OPERATION_SEQ_NUM
MRP_WIP_COMPONENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WIP_ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
WIP_ENTITY_ID	NUMBER		Yes	WIP job or repetitive assembly identifier
OPERATION_SEQ_NUM	NUMBER			Manufacturing operation sequence number
JOB_REFERENCE_ITEM_ID	NUMBER		Yes	Job reference item identifier
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
QUANTITY_REQUIRED	NUMBER		Yes	Job quantity required
QUANTITY_ISSUED	NUMBER		Yes	Job quantity issued
ALLOCATED_QUANTITY	NUMBER			Job allocated quantity
NET_QUANTITY	NUMBER			Job net quantity
OPERATION_START_DATE	DATE		Yes	Operation start date
WIP_ENTITY_TYPE	NUMBER		Yes	WIP entity type code
SUPPLY_DEMAND_TYPE	NUMBER		Yes	Supply or demand flag
OPERATION_OFFSET_DAYS	NUMBER			Job issue operation offset days
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
PROJECT_ID	NUMBER	(15)		Project identifier
TASK_ID	NUMBER	(15)		Task identifier
PLANNING_GROUP	VARCHAR2	(30)		Planning group

Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      WIP_ENTITY_ID
,      OPERATION_SEQ_NUM
,      JOB_REFERENCE_ITEM_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      QUANTITY_REQUIRED
,      QUANTITY_ISSUED
,      ALLOCATED_QUANTITY
,      NET_QUANTITY
,      OPERATION_START_DATE
,      WIP_ENTITY_TYPE
,      SUPPLY_DEMAND_TYPE
,      OPERATION_OFFSET_DAYS
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP
FROM MRP.MRP_WIP_COMPONENTS;

Dependencies

[top of page]

MRP.MRP_WIP_COMPONENTS does not reference any database object

MRP.MRP_WIP_COMPONENTS is referenced by following:

APPS: MRP_WIP_COMPONENTS