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_MATCH_INV_TAX_V

Object Details

Object Name:	JAI_AP_MATCH_INV_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_AP_MATCH_INV_TAX_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	Comments
MATCH_TYPE	VARCHAR2	(15)	Indicates whether the invoice is PO Matched of Receipt Matched
INVOICE_ID	NUMBER		Indicates the invoice identifier
PARENT_INVOICE_LINE_NUMBER	NUMBER	(15)	Indicates the line number of the invoice line for the current miscellaneous line
TRANSACTION_ID	NUMBER		Indicates the transaction Identifier of the receipt
TAX_LINE_NO	NUMBER	(15)	Indicates the tax line number
TAX_ID	NUMBER	(15)	Indicates the tax identifier
TAX_TYPE	VARCHAR2	(30)	Indicates the tax type
PRECEDENCE_1	NUMBER		Indicates precedence 1
PRECEDENCE_2	NUMBER		Indicates precedence 2
PRECEDENCE_3	NUMBER		Indicates precedence 3
PRECEDENCE_4	NUMBER		Indicates precedence 4
PRECEDENCE_5	NUMBER		Indicates precedence 5
PRECEDENCE_6	NUMBER		Indicates precedence 6
PRECEDENCE_7	NUMBER		Indicates precedence 7
PRECEDENCE_8	NUMBER		Indicates precedence 8
PRECEDENCE_9	NUMBER		Indicates precedence 9
PRECEDENCE_10	NUMBER		Indicates precedence 10
CURRENCY	VARCHAR2	(15)	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_AMOUNT	NUMBER		Indicates the tax amount
VENDOR_ID	NUMBER	(15)	Indicates the vendor identifier for the tax in case of a third party tax
VENDOR_SITE_ID	NUMBER		Indicates the vendor site identifier for the tax in case of a third party tax
MODVAT_FLAG	VARCHAR2	(1)	Indicates whether the tax is recoverable

Query Text

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


SELECT MATCH_TYPE
,      INVOICE_ID
,      PARENT_INVOICE_LINE_NUMBER
,      TRANSACTION_ID
,      TAX_LINE_NO
,      TAX_ID
,      TAX_TYPE
,      PRECEDENCE_1
,      PRECEDENCE_2
,      PRECEDENCE_3
,      PRECEDENCE_4
,      PRECEDENCE_5
,      PRECEDENCE_6
,      PRECEDENCE_7
,      PRECEDENCE_8
,      PRECEDENCE_9
,      PRECEDENCE_10
,      CURRENCY
,      TAX_RATE
,      QTY_RATE
,      UOM
,      TAX_AMOUNT
,      VENDOR_ID
,      VENDOR_SITE_ID
,      MODVAT_FLAG
FROM APPS.JAI_AP_MATCH_INV_TAX_V;

Dependencies

[top of page]

APPS.JAI_AP_MATCH_INV_TAX_V references the following:

APPS: JAI_AP_MATCH_INV_TAXES; JAI_PO_TAXES; JAI_RCV_LINE_TAXES; RCV_TRANSACTIONS

APPS.JAI_AP_MATCH_INV_TAX_V is referenced by following:

APPS: JAI_AP_TAXES_V