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.ECE_INO_LINE_TAX_V

Object Details

Object Name:	ECE_INO_LINE_TAX_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EC.ECE_INO_LINE_TAX_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view extracts line tax information
for the outbound Invoice (810/INVOIC) transaction.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER	(15)	Yes	Transaction ID
LINE_NUMBER	NUMBER		Yes	Line Number
CUSTOMER_TRX_LINE_ID	NUMBER	(15)	Yes	Customer Transaction Line ID
TAX_LINE_NUMBER	NUMBER		Yes	Tax Line Number
LINE_TYPE	VARCHAR2	(20)	Yes	Line Type
TAX_AMOUNT	NUMBER		Yes	Tax Amount
TAX_RATE	NUMBER			Tax Rate
TAX_PRECEDENCE	NUMBER			Tax Precedence
TAX_CODE	VARCHAR2	(30)		Tax Code (Internal)
LINK_TO_CUST_TRX_LINE_ID	NUMBER	(15)		Tax Link To Customer Transaction ID
TAX_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Tax Flexfield Context
TAX_ATTRIBUTE1	VARCHAR2	(150)		Tax Flexfield 1
TAX_ATTRIBUTE2	VARCHAR2	(150)		Tax Flexfield 2
TAX_ATTRIBUTE3	VARCHAR2	(150)		Tax Flexfield 3
TAX_ATTRIBUTE4	VARCHAR2	(150)		Tax Flexfield 4
TAX_ATTRIBUTE5	VARCHAR2	(150)		Tax Flexfield 5
TAX_ATTRIBUTE6	VARCHAR2	(150)		Tax Flexfield 6
TAX_ATTRIBUTE7	VARCHAR2	(150)		Tax Flexfield 7
TAX_ATTRIBUTE8	VARCHAR2	(150)		Tax Flexfield 8
TAX_ATTRIBUTE9	VARCHAR2	(150)		Tax Flexfield 9
TAX_ATTRIBUTE10	VARCHAR2	(150)		Tax Flexfield 10
TAX_ATTRIBUTE11	VARCHAR2	(150)		Tax Flexfield 11
TAX_ATTRIBUTE12	VARCHAR2	(150)		Tax Flexfield 12
TAX_ATTRIBUTE13	VARCHAR2	(150)		Tax Flexfield 13
TAX_ATTRIBUTE14	VARCHAR2	(150)		Tax Flexfield 14
TAX_ATTRIBUTE15	VARCHAR2	(150)		Tax Flexfield 15
TAX_EXEMPT_FLAG	VARCHAR2	(1)		Tax Exempt Flag
TAX_EXEMPT_NUMBER	VARCHAR2	(80)		Tax Exempt Number
TAX_EXEMPT_REASON_CODE	VARCHAR2	(30)		Tax Exempt Reason Code
TAX_TYPE	VARCHAR2	(30)		Tax Type
DESCRIPTION	VARCHAR2	(240)		Description
LOCATION	VARCHAR2	(0)		Location
TAX_CLASSIFICATION	VARCHAR2	(0)		Tax Classification
VAT_TRANSACTION_TYPE	VARCHAR2	(30)		VAT Transaction Type
VAT_TAX_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		VAT Tax Flexfield Context
VAT_TAX_ATTRIBUTE1	VARCHAR2	(150)		VAT Tax Flexfield 1
VAT_TAX_ATTRIBUTE2	VARCHAR2	(150)		VAT Tax Flexfield 2
VAT_TAX_ATTRIBUTE3	VARCHAR2	(150)		VAT Tax Flexfield 3
VAT_TAX_ATTRIBUTE4	VARCHAR2	(150)		VAT Tax Flexfield 4
VAT_TAX_ATTRIBUTE5	VARCHAR2	(150)		VAT Tax Flexfield 5
VAT_TAX_ATTRIBUTE6	VARCHAR2	(150)		VAT Tax Flexfield 6
VAT_TAX_ATTRIBUTE7	VARCHAR2	(150)		VAT Tax Flexfield 7
VAT_TAX_ATTRIBUTE8	VARCHAR2	(150)		VAT Tax Flexfield 8
VAT_TAX_ATTRIBUTE9	VARCHAR2	(150)		VAT Tax Flexfield 9
VAT_TAX_ATTRIBUTE10	VARCHAR2	(150)		VAT Tax Flexfield 10
VAT_TAX_ATTRIBUTE11	VARCHAR2	(150)		VAT Tax Flexfield 11
VAT_TAX_ATTRIBUTE12	VARCHAR2	(150)		VAT Tax Flexfield 12
VAT_TAX_ATTRIBUTE13	VARCHAR2	(150)		VAT Tax Flexfield 13
VAT_TAX_ATTRIBUTE14	VARCHAR2	(150)		VAT Tax Flexfield 14
VAT_TAX_ATTRIBUTE15	VARCHAR2	(150)		VAT Tax Flexfield 15

Query Text

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


SELECT TRANSACTION_ID
,      LINE_NUMBER
,      CUSTOMER_TRX_LINE_ID
,      TAX_LINE_NUMBER
,      LINE_TYPE
,      TAX_AMOUNT
,      TAX_RATE
,      TAX_PRECEDENCE
,      TAX_CODE
,      LINK_TO_CUST_TRX_LINE_ID
,      TAX_ATTRIBUTE_CATEGORY
,      TAX_ATTRIBUTE1
,      TAX_ATTRIBUTE2
,      TAX_ATTRIBUTE3
,      TAX_ATTRIBUTE4
,      TAX_ATTRIBUTE5
,      TAX_ATTRIBUTE6
,      TAX_ATTRIBUTE7
,      TAX_ATTRIBUTE8
,      TAX_ATTRIBUTE9
,      TAX_ATTRIBUTE10
,      TAX_ATTRIBUTE11
,      TAX_ATTRIBUTE12
,      TAX_ATTRIBUTE13
,      TAX_ATTRIBUTE14
,      TAX_ATTRIBUTE15
,      TAX_EXEMPT_FLAG
,      TAX_EXEMPT_NUMBER
,      TAX_EXEMPT_REASON_CODE
,      TAX_TYPE
,      DESCRIPTION
,      LOCATION
,      TAX_CLASSIFICATION
,      VAT_TRANSACTION_TYPE
,      VAT_TAX_ATTRIBUTE_CATEGORY
,      VAT_TAX_ATTRIBUTE1
,      VAT_TAX_ATTRIBUTE2
,      VAT_TAX_ATTRIBUTE3
,      VAT_TAX_ATTRIBUTE4
,      VAT_TAX_ATTRIBUTE5
,      VAT_TAX_ATTRIBUTE6
,      VAT_TAX_ATTRIBUTE7
,      VAT_TAX_ATTRIBUTE8
,      VAT_TAX_ATTRIBUTE9
,      VAT_TAX_ATTRIBUTE10
,      VAT_TAX_ATTRIBUTE11
,      VAT_TAX_ATTRIBUTE12
,      VAT_TAX_ATTRIBUTE13
,      VAT_TAX_ATTRIBUTE14
,      VAT_TAX_ATTRIBUTE15
FROM APPS.ECE_INO_LINE_TAX_V;

Dependencies

[top of page]

APPS.ECE_INO_LINE_TAX_V references the following:

APPS: RA_CUSTOMER_TRX; RA_CUSTOMER_TRX_LINES; ZX_RATES_B; ZX_RATES_TL; ZX_TAXES_B

APPS.ECE_INO_LINE_TAX_V is not referenced by any database object