DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_OM_OE_RMA_LINES

Object Details
Object Name: JAI_OM_OE_RMA_LINES
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_OM_OE_RMA_LINES
Subobject Name:
Status: VALID


This table holds the line details of the return orders.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_OM_OE_RMA_LINES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRMA_LINE_ID
JAI_OM_OE_RMA_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRMA_NUMBER
JAI_OM_OE_RMA_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRMA_HEADER_ID
ColumnRMA_LINE_ID
Columns
Name Datatype Length Mandatory Comments
RMA_LINE_ID NUMBER (15) Yes This column holds the line identifier of the return order line.
RMA_LINE_NUMBER NUMBER (15) Yes This column holds the line number for the return order.
RMA_HEADER_ID NUMBER (15) Yes This column holds the header identifier of the return order.
RMA_NUMBER NUMBER (15) Yes This column holds the return order number of the return order.
PICKING_LINE_ID NUMBER (15)
No longer used
UOM VARCHAR2 (3)
This column holds the unit of measurement of the inventory item.
SELLING_PRICE NUMBER

This column holds the selling price of the item.
QUANTITY NUMBER
Yes This column holds the quantity.
TAX_CATEGORY_ID NUMBER (15)
This column holds the tax category identifier.
TAX_AMOUNT NUMBER

This column holds the tax amount for the return line.
INVENTORY_ITEM_ID NUMBER

This column holds the Inventory Item of this return line.
RECEIVED_FLAG VARCHAR2 (1)
This column is a flag that indicates if the returned material has been received.
ASSESSABLE_VALUE NUMBER

This column holds the assessable value of the inventory item of the return line.
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER (15)
Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
EXCISE_DUTY_RATE NUMBER

This column holds the excise duty rate per unit.
RATE_PER_UNIT NUMBER

This column holds the trading excise per unit.
DELIVERY_DETAIL_ID NUMBER

This column holds the delivery detail identifier of the shipment line against which this return order line is booked.
ALLOW_EXCISE_CREDIT_FLAG VARCHAR2 (1)
Identifies whether excise credit is allowed or not
ALLOW_SALES_CREDIT_FLAG VARCHAR2 (1)
Identifies whether sales credit is allowed or not
OBJECT_VERSION_NUMBER NUMBER

Object version number
SERVICE_TYPE_CODE VARCHAR2 (30)
Indicates the service type for the return order line
Query Text

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


SELECT RMA_LINE_ID
,      RMA_LINE_NUMBER
,      RMA_HEADER_ID
,      RMA_NUMBER
,      PICKING_LINE_ID
,      UOM
,      SELLING_PRICE
,      QUANTITY
,      TAX_CATEGORY_ID
,      TAX_AMOUNT
,      INVENTORY_ITEM_ID
,      RECEIVED_FLAG
,      ASSESSABLE_VALUE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EXCISE_DUTY_RATE
,      RATE_PER_UNIT
,      DELIVERY_DETAIL_ID
,      ALLOW_EXCISE_CREDIT_FLAG
,      ALLOW_SALES_CREDIT_FLAG
,      OBJECT_VERSION_NUMBER
,      SERVICE_TYPE_CODE
FROM JA.JAI_OM_OE_RMA_LINES;

Dependencies

[top of page]

JA.JAI_OM_OE_RMA_LINES does not reference any database object

JA.JAI_OM_OE_RMA_LINES is referenced by following:

SchemaAPPS
SynonymJAI_OM_OE_RMA_LINES