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_ERO_RELEASE

Object Details

Object Name:	MRP_ERO_RELEASE
Object Type:	TABLE
Owner:	MRP
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Comments
TRANSACTION_ID	NUMBER	msc_supplies transaction_id of planned external repair order
REPAIR_SUPPLIER_ID	NUMBER	Repair supplier id
REPAIR_SUPPLIER_ORG_ID	NUMBER	Repair supplier org id
REPAIR_PROGRAM	NUMBER	Repair program corresponding to item in Planned external repair order
BATCH_ID	NUMBER	Batch id for release; generated by src side sequence;
DESTINATION_ORG_ID	NUMBER	Destination organization side
SOURCE_ORG_ID	NUMBER	Source_org_id
INVENTORY_ITEM_ID	NUMBER	Inventory_item_id
PROMISE_DATE	DATE	ERO Promise Date
QUANTITY	NUMBER	Quantity of repair order
DEFECTIVE_ITEM_ID	NUMBER	Defective_item_id
DEFECTIVE_ITEM_QTY	NUMBER	Defective_item_qty

Query Text

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


SELECT TRANSACTION_ID
,      REPAIR_SUPPLIER_ID
,      REPAIR_SUPPLIER_ORG_ID
,      REPAIR_PROGRAM
,      BATCH_ID
,      DESTINATION_ORG_ID
,      SOURCE_ORG_ID
,      INVENTORY_ITEM_ID
,      PROMISE_DATE
,      QUANTITY
,      DEFECTIVE_ITEM_ID
,      DEFECTIVE_ITEM_QTY
FROM MRP.MRP_ERO_RELEASE;

Dependencies

[top of page]

MRP.MRP_ERO_RELEASE does not reference any database object

MRP.MRP_ERO_RELEASE is referenced by following:

MRP: MRP_ERO_RELEASE#