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_INTERFACE

Object Details

Object Name:	MTL_SO_RMA_INTERFACE
Object Type:	TABLE
Owner:	INV
FND Design Data:	INV.MTL_SO_RMA_INTERFACE
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_INTERFACE is the interface table between Oracle Order Entry/Shipping and Oracle Inventory. When a customer decides to return
some purchased
items back to the supplier, a Return Material Authorization (RMA) is
created in Order Entry. The RMA data is transferred from Order Entry
to the interface table by a program which is run periodically. The
data in this table is utilized by Oracle Inventory.
.
.
.
Three quantity related columns namely QUANTITY, RECEIVED_QUANTITY,
DELIVERED_QUANTITY will at any time give you the total RMA quantity,
total quantity received, and total units delivered into stores
respectively. The INSPECTION_REQUIRED_FLAG determines whether the
returned material requires to go through inspection. SALES_ORDER_ID is
derived at the time of first receipt in Inventory.
.
.
.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTL_SO_RMA_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_LINE_ID
MTL_SO_RMA_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	RMA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RMA_INTERFACE_ID	NUMBER		Yes	RMA interface 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_ID	NUMBER		Yes	RMA identifier
RMA_LINE_ID	NUMBER		Yes	RMA line identifier
RMA_NUMBER	NUMBER		Yes	RMA number
RMA_LINE_NUMBER	NUMBER		Yes	Number for RMA lines
COMPONENT_SEQUENCE_ID	NUMBER		Yes	Component unique identifier
RMA_TYPE	VARCHAR2	(30)	Yes	RMA type
SOURCE_CODE	VARCHAR2	(30)	Yes	Source code
SALES_ORDER_ID	NUMBER			Sales order identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
RETURN_TYPE_CODE	VARCHAR2	(30)		Code identifying type of return
QUANTITY	NUMBER		Yes	RMA line quantity
RECEIVED_QUANTITY	NUMBER		Yes	Total quantity received -- into inventory or inspection
DELIVERED_QUANTITY	NUMBER		Yes	Total quantity received into inventory
DISTRIBUTION_ACCOUNT_ID	NUMBER			Distribution account identifier
UNIT_CODE	VARCHAR2	(3)	Yes	Item unit of measure
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)		Inspection required flag
EXPECTED_RECEIPT_DATE	DATE			Expected receipt date
EXPECTED_SUBINVENTORY_NAME	VARCHAR2	(10)		Subinventory to receive into
LOT_NUMBER	VARCHAR2	(80)		Lot number for RMA item
INSPECTION_INSTRUCTIONS	VARCHAR2	(240)		Inspection instructions
IN_USE_FLAG	VARCHAR2	(1)		RMA line in-use flag
SERIAL_NUMBER_FLAG	VARCHAR2	(1)		Serial number flag
CLOSED_FLAG	VARCHAR2	(1)		Flag indicating whether the RMA is closed
REQUIRED_FOR_REVENUE_FLAG	VARCHAR2	(1)		Required for revenue flag.

Query Text

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


SELECT RMA_INTERFACE_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_ID
,      RMA_LINE_ID
,      RMA_NUMBER
,      RMA_LINE_NUMBER
,      COMPONENT_SEQUENCE_ID
,      RMA_TYPE
,      SOURCE_CODE
,      SALES_ORDER_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RETURN_TYPE_CODE
,      QUANTITY
,      RECEIVED_QUANTITY
,      DELIVERED_QUANTITY
,      DISTRIBUTION_ACCOUNT_ID
,      UNIT_CODE
,      INSPECTION_REQUIRED_FLAG
,      EXPECTED_RECEIPT_DATE
,      EXPECTED_SUBINVENTORY_NAME
,      LOT_NUMBER
,      INSPECTION_INSTRUCTIONS
,      IN_USE_FLAG
,      SERIAL_NUMBER_FLAG
,      CLOSED_FLAG
,      REQUIRED_FOR_REVENUE_FLAG
FROM INV.MTL_SO_RMA_INTERFACE;

Dependencies

[top of page]

INV.MTL_SO_RMA_INTERFACE does not reference any database object

INV.MTL_SO_RMA_INTERFACE is referenced by following:

APPS: MTL_SO_RMA_INTERFACE