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

TABLE: JA.JAI_OM_OE_RMA_TAXES

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


This table holds the tax details associated with a return order.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JAI_OM_OE_RMA_TAXES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRMA_LINE_ID
ColumnTAX_ID
Columns
Name Datatype Length Mandatory Comments
RMA_LINE_ID NUMBER (15) Yes This column holds the line identifier of the return order line.
TAX_LINE_NO NUMBER (15) Yes This column holds the line number of the tax line.
PRECEDENCE_1 NUMBER

This column holds Tax precedence 1 of the current tax.
PRECEDENCE_2 NUMBER

This column holds Tax precedence 2 of the current tax.
PRECEDENCE_3 NUMBER

This column holds Tax precedence 3 of the current tax.
PRECEDENCE_4 NUMBER

This column holds Tax precedence 4 of the current tax.
PRECEDENCE_5 NUMBER

This column holds Tax precedence 5 of the current tax.
TAX_ID NUMBER (15) Yes This column holds the tax identifier of the tax line.
TAX_RATE NUMBER

This column holds the tax rate of the tax line.
QTY_RATE NUMBER

This column holds the quantity rate per unit
UOM VARCHAR2 (3)
This column holds the unit of measurement.
TAX_AMOUNT NUMBER

This column holds the tax amount of the tax line.
BASE_TAX_AMOUNT NUMBER

This column holds the tax amount based on which the tax amount is calculated.
FUNC_TAX_AMOUNT NUMBER

This column holds the tax amount in functional currency for the tax 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
DELIVERY_DETAIL_ID NUMBER

This column holds the Delivery detail identifier of the shipment line against which the return tax line is created.
OBJECT_VERSION_NUMBER NUMBER

Object version number
PRECEDENCE_6 NUMBER

Sixth precedence on which this tax is dependent.
PRECEDENCE_7 NUMBER

Seventh precedence on which this tax is dependent.
PRECEDENCE_8 NUMBER

Eighth precedence on which this tax is dependent.
PRECEDENCE_9 NUMBER

Nineth precedence on which this tax is dependent.
PRECEDENCE_10 NUMBER

Tenth precedence on which this tax is dependent.
Query Text

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


SELECT RMA_LINE_ID
,      TAX_LINE_NO
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      TAX_ID
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      BASE_TAX_AMOUNT
,      FUNC_TAX_AMOUNT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DELIVERY_DETAIL_ID
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
FROM JA.JAI_OM_OE_RMA_TAXES;

Dependencies

[top of page]

JA.JAI_OM_OE_RMA_TAXES does not reference any database object

JA.JAI_OM_OE_RMA_TAXES is referenced by following:

SchemaJA
ViewJAI_OM_OE_RMA_TAXES#