DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.JAI_AP_TAXES_V

Object Details
Object Name: JAI_AP_TAXES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewJA.JAI_AP_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
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
Query Text

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;

Dependencies

[top of page]

APPS.JAI_AP_TAXES_V references the following:

SchemaAPPS
ViewJAI_AP_MATCH_INV_TAX_V
ViewJAI_AP_STANDALONE_TAXES_V

APPS.JAI_AP_TAXES_V is not referenced by any database object