[Home] [Help] [Dependency Information]
Object Name: | JAI_AP_TAXES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | JA.JAI_AP_TAXES_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | Invoice ID | ||
PARENT_LINE_NUMBER | NUMBER | (15) | Parent Item Line of the Tax Line | |
TAX_LINE_NO | NUMBER | (15) | Tax Line Number | |
TAX_ID | NUMBER | (15) | Tax ID | |
TAX_TYPE | VARCHAR2 | (30) | Tax Type | |
CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
TAX_RATE | NUMBER | Tax Rate | ||
QTY_RATE | NUMBER | Quantity Rate | ||
UOM | VARCHAR2 | (15) | Unit of Measure | |
TAX_AMT | NUMBER | Tax Amount | ||
MODVAT_FLAG | VARCHAR2 | (1) | MODVAT Flag | |
PRECEDENCE_1 | NUMBER | Tax Precedence | ||
PRECEDENCE_2 | NUMBER | Tax Precedence | ||
PRECEDENCE_3 | NUMBER | Tax Precedence | ||
PRECEDENCE_4 | NUMBER | Tax Precedence | ||
PRECEDENCE_5 | NUMBER | Tax Precedence | ||
PRECEDENCE_6 | NUMBER | Tax Precedence | ||
PRECEDENCE_7 | NUMBER | Tax Precedence | ||
PRECEDENCE_8 | NUMBER | Tax Precedence | ||
PRECEDENCE_9 | NUMBER | Tax Precedence | ||
PRECEDENCE_10 | NUMBER | Tax Precedence |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, PARENT_LINE_NUMBER
, TAX_LINE_NO
, TAX_ID
, TAX_TYPE
, CURRENCY_CODE
, TAX_RATE
, QTY_RATE
, UOM
, TAX_AMT
, MODVAT_FLAG
, PRECEDENCE_1
, PRECEDENCE_2
, PRECEDENCE_3
, PRECEDENCE_4
, PRECEDENCE_5
, PRECEDENCE_6
, PRECEDENCE_7
, PRECEDENCE_8
, PRECEDENCE_9
, PRECEDENCE_10
FROM APPS.JAI_AP_TAXES_V;
APPS.JAI_AP_TAXES_V is not referenced by any database object
|
|
|