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: JA.JAI_PO_TAXES

Object Details

Object Name:	JAI_PO_TAXES
Object Type:	TABLE
Owner:	JA
FND Design Data:	JA.JAI_PO_TAXES
Subobject Name:
Status:	VALID

Stores the information of localization tax lines at a PO line location level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_PO_TAXES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	LINE_FOCUS_ID TAX_ID
JAI_PO_TAXES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LINE_LOCATION_ID PO_HEADER_ID PO_LINE_ID
JAI_PO_TAXES_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID PO_HEADER_ID
JAI_PO_TAXES_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID
JAI_PO_TAXES_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_LINE_ID LINE_LOCATION_ID TAX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_LOCATION_ID	NUMBER	(15)		PO line location identifier.
TAX_LINE_NO	NUMBER	(15)	Yes	The order of tax for the PO line location.
PO_LINE_ID	NUMBER	(15)		PO line identifier.
PO_HEADER_ID	NUMBER	(15)	Yes	PO header identifier.
PRECEDENCE_1	NUMBER			Precedence 1 for the tax.
PRECEDENCE_2	NUMBER			Precedence 2 for the tax.
PRECEDENCE_3	NUMBER			Precedence 3 for the tax.
PRECEDENCE_4	NUMBER			Precedence 4 for the tax.
PRECEDENCE_5	NUMBER			Precedence 5 for the tax.
TAX_ID	NUMBER	(15)	Yes	Tax identifier.
CURRENCY	VARCHAR2	(15)		Currency of the tax.
TAX_RATE	NUMBER			Percentage Rate of the tax.
QTY_RATE	NUMBER			Quantity rate of the tax.
UOM	VARCHAR2	(3)		Unit of measurement.
TAX_AMOUNT	NUMBER			Tax amount.
TAX_TYPE	VARCHAR2	(30)		Tax type, same as defined in tax definition.
VENDOR_ID	NUMBER	(15)		Supplier identifier.
MODVAT_FLAG	VARCHAR2	(1)		Possible values, Y or N or Null. Null is treated at par with N. The value indicates if the tax is recoverable.
TAX_TARGET_AMOUNT	NUMBER			Tax target amount.
LINE_FOCUS_ID	NUMBER	(15)	Yes	Current line identifier
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
TAX_CATEGORY_ID	NUMBER	(15)		Populated for defaulted tax lines only. It indicates the tax category identifier that was used from the setup for defaulting.
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 LINE_LOCATION_ID
,      TAX_LINE_NO
,      PO_LINE_ID
,      PO_HEADER_ID
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      TAX_ID
,      CURRENCY
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      TAX_TYPE
,      VENDOR_ID
,      MODVAT_FLAG
,      TAX_TARGET_AMOUNT
,      LINE_FOCUS_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TAX_CATEGORY_ID
,      OBJECT_VERSION_NUMBER
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
FROM JA.JAI_PO_TAXES;

Dependencies

[top of page]

JA.JAI_PO_TAXES does not reference any database object

JA.JAI_PO_TAXES is referenced by following:

APPS: JAI_JPO_LLT_BRIUD_T1; JAI_PO_TAXES