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_END_ASSEMBLIES

Object Details

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

MRP_END_ASSEMBLIES stores information used by Oracle Master
Scheduling/MRP reports and inquires regarding end assembly pegging.
For each item where end assembly pegging is set to yes in the item
master, MRP_END_ASSEMBLIES will hold a row for each end assembly that
has that item in its bill.
.
MRP_END_ASSEMBLIES is populated by the Calculate End Assembly Pegging
concurrent program, and is used by the View Item Planning Information
form and the Planning Detail Report to display end assembly pegging.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_END_ASSEMBLIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORGANIZATION_ID COMPILE_DESIGNATOR INVENTORY_ITEM_ID USING_ASSEMBLY_ID END_ASSEMBLY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
USING_ASSEMBLY_ID	NUMBER		Yes	Using assembly identifier
END_ASSEMBLY_ID	NUMBER		Yes	End assembly 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
END_USAGE	NUMBER		Yes	Quantity required to make one end assembly
SET_BACK_TIME	NUMBER		Yes	Set back time
USAGE	NUMBER		Yes	Quantity required to make one using assembly
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

Query Text

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


SELECT ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      INVENTORY_ITEM_ID
,      USING_ASSEMBLY_ID
,      END_ASSEMBLY_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      END_USAGE
,      SET_BACK_TIME
,      USAGE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MRP.MRP_END_ASSEMBLIES;

Dependencies

[top of page]

MRP.MRP_END_ASSEMBLIES does not reference any database object

MRP.MRP_END_ASSEMBLIES is referenced by following:

MRP: MRP_END_ASSEMBLIES#