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]

VIEW: APPS.JAI_AP_STANDALONE_TAXES_V

Object Details

Object Name:	JAI_AP_STANDALONE_TAXES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_AP_STANDALONE_TAXES_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DOC_TAX_ID	NUMBER			Document tax identifier
TAX_LINE_NO	NUMBER	(15)	Yes	Indicates the tax line number
TAX_ID	NUMBER	(15)	Yes	Indicates the tax line number
TAX_TYPE	VARCHAR2	(30)	Yes	Indicates the tax type
CURRENCY_CODE	VARCHAR2	(15)	Yes	Indicates the currency of the tax
TAX_RATE	NUMBER			Indicates the tax rate of the tax
QTY_RATE	NUMBER			Indicates the rate per unit of the tax
UOM	VARCHAR2	(15)		Indicates the unit of measurement of the tax
TAX_AMT	NUMBER			Indicates the tax amount
FUNC_TAX_AMT	NUMBER			Indicates the tax amount in ledger currency
MODVAT_FLAG	VARCHAR2	(1)		Indicates whether the tax is recoverable
TAX_CATEGORY_ID	NUMBER	(15)		Indicates the tax category identifier
SOURCE_DOC_TYPE	VARCHAR2	(40)		Indicates the type of document for which the tax is attached
SOURCE_DOC_ID	NUMBER	(15)		Indicates the document identifier
SOURCE_DOC_LINE_ID	NUMBER			Indicates the document line identifier
SOURCE_TABLE_NAME	VARCHAR2	(40)		Indicates the table name
TAX_MODIFIED_BY	VARCHAR2	(10)		Indicates whether the tax was modified in the front end
ADHOC_FLAG	VARCHAR2	(1)		Indicates whether there is adhoc amount entered for the tax
PRECEDENCE_1	NUMBER	(15)		Indicates precedence 1
PRECEDENCE_2	NUMBER	(15)		Indicates precedence 2
PRECEDENCE_3	NUMBER	(15)		Indicates precedence 3
PRECEDENCE_4	NUMBER	(15)		Indicates precedence 4
PRECEDENCE_5	NUMBER	(15)		Indicates precedence 5
PRECEDENCE_6	NUMBER	(15)		Indicates precedence 6
PRECEDENCE_7	NUMBER	(15)		Indicates precedence 7
PRECEDENCE_8	NUMBER	(15)		Indicates precedence 8
PRECEDENCE_9	NUMBER	(15)		Indicates precedence 9
PRECEDENCE_10	NUMBER	(15)		Indicates precedence 10
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SOURCE_DOC_PARENT_LINE_NO	NUMBER	(15)		Indicates the item line number of the AP invoice line for which this tax is created

Query Text

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


SELECT DOC_TAX_ID
,      TAX_LINE_NO
,      TAX_ID
,      TAX_TYPE
,      CURRENCY_CODE
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMT
,      FUNC_TAX_AMT
,      MODVAT_FLAG
,      TAX_CATEGORY_ID
,      SOURCE_DOC_TYPE
,      SOURCE_DOC_ID
,      SOURCE_DOC_LINE_ID
,      SOURCE_TABLE_NAME
,      TAX_MODIFIED_BY
,      ADHOC_FLAG
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_DOC_PARENT_LINE_NO
FROM APPS.JAI_AP_STANDALONE_TAXES_V;

Dependencies

[top of page]

APPS.JAI_AP_STANDALONE_TAXES_V references the following:

APPS: JAI_CMN_DOCUMENT_TAXES

APPS.JAI_AP_STANDALONE_TAXES_V is referenced by following:

APPS: JAI_AP_TAXES_V