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: INV.MTL_SO_RMA_RECEIPTS

Object Details

Object Name:	MTL_SO_RMA_RECEIPTS
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_SO_RMA_RECEIPTS
Subobject Name:
Status:	VALID

THIS TABLE IS OBSOLETE WITH THE NEW ORDER MANAGEMENT SYSTEM. IT IS USED ONLY FOR
DATA MIGRATION FROM THIS TABLE TO THE NEW ORDER MANAGEMENT SYSTEM.
.
.
.
MTL_SO_RMA_RECEIPTS has a row for each RMA transaction in Inventory.
Each row is stamped with a RMA_RECEIPT_ID. Two columns
(RECEIVED_QUANTITY and ACCEPTED_QUANTITY) will give the user the
quantity movement information. Every receipt into inspection will have
a positive quantity in RECEIVED_QUANTITY. A direct delivery into
stores will have a positive quantity in RECEIVED_QUANTITY and
ACCEPTED_QUANTITY. The movement of material from inspection to stores
will have a positive quantity in ACCEPTED_QUANTITY. A return
from inspection will have a negative value in RECEIVED_QUANTITY and a
direct return from stores will have negative value in both
RECEIVED_QUANTITY and ACCEPTED_QUANTITY. Oracle Order Entry/Shipping
has a program which periodically picks up data from this table and
updates their RMA tables.
.
.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_SO_RMA_RECEIPTS_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	RMA_RECEIPT_ID
MTL_SO_RMA_RECEIPTS_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_INTERFACE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RMA_RECEIPT_ID	NUMBER		Yes	RMA receipt 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
REQUEST_ID	NUMBER			Standard Who column
PROGRAM_APPLICATION_ID	NUMBER			Standard Who column
PROGRAM_ID	NUMBER			Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
RMA_INTERFACE_ID	NUMBER		Yes	RMA interface identifer
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
RECEIVED_QUANTITY	NUMBER		Yes	Total quantity received -- into inventory or inspection
ACCEPTED_QUANTITY	NUMBER		Yes	Total quantity received into inventory
LOT_NUMBER	VARCHAR2	(80)		Lot number for RMA item
UNIT_CODE	VARCHAR2	(3)	Yes	Item unit of measure
RECEIPT_DATE	DATE		Yes	Receipt date
RETURN_SUBINVENTORY_NAME	VARCHAR2	(10)		Name of return subinventory
INSPECTION_COMMENTS	VARCHAR2	(240)		Inspection comments
CLOSED_FLAG	VARCHAR2	(1)		Flag indicating whether the RMA is closed

Query Text

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


SELECT RMA_RECEIPT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RMA_INTERFACE_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RECEIVED_QUANTITY
,      ACCEPTED_QUANTITY
,      LOT_NUMBER
,      UNIT_CODE
,      RECEIPT_DATE
,      RETURN_SUBINVENTORY_NAME
,      INSPECTION_COMMENTS
,      CLOSED_FLAG
FROM INV.MTL_SO_RMA_RECEIPTS;

Dependencies

[top of page]

INV.MTL_SO_RMA_RECEIPTS does not reference any database object

INV.MTL_SO_RMA_RECEIPTS is referenced by following:

INV: MTL_SO_RMA_RECEIPTS#