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_AP_TDS_THHOLD_TAXES

Object Details

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

This table stores the details of taxes that are applicable for a particular slab rate by operating unit.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JAI_AP_TDS_THHOLD_TAXES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	THRESHOLD_TAX_ID
JAI_AP_TDS_THHOLD_TAXES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	THRESHOLD_TYPE_ID OPERATING_UNIT_ID THRESHOLD_SLAB_ID THRESHOLD_HDR_ID TAX_ID TAX_CATEGORY_ID
JAI_AP_TDS_THHOLD_TAXES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	THRESHOLD_HDR_ID THRESHOLD_TYPE_ID THRESHOLD_SLAB_ID

Columns

Name	Datatype	Length	Mandatory	Comments
THRESHOLD_TAX_ID	NUMBER	(15)	Yes	Threshold tax identifier
THRESHOLD_SLAB_ID	NUMBER	(15)	Yes	Threshold Slab Idenifier
THRESHOLD_TYPE_ID	NUMBER	(15)	Yes	Threshold Type Idenitifier
THRESHOLD_HDR_ID	NUMBER	(15)	Yes	Threshold header identifier
OPERATING_UNIT_ID	NUMBER	(15)	Yes	Operating unit Indentifier
TAX_ID	NUMBER	(15)		Tax identifier
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
OBJECT_VERSION_NUMBER	NUMBER	(9)		Object Version Number.
TAX_CATEGORY_ID	NUMBER	(15)		Indicates Tax Category Identifier

Query Text

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


SELECT THRESHOLD_TAX_ID
,      THRESHOLD_SLAB_ID
,      THRESHOLD_TYPE_ID
,      THRESHOLD_HDR_ID
,      OPERATING_UNIT_ID
,      TAX_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      TAX_CATEGORY_ID
FROM JA.JAI_AP_TDS_THHOLD_TAXES;

Dependencies

[top of page]

JA.JAI_AP_TDS_THHOLD_TAXES does not reference any database object

JA.JAI_AP_TDS_THHOLD_TAXES is referenced by following:

JA: JAI_AP_TDS_THHOLD_TAXES#