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

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
DOCUMENT_TYPE_ID	NUMBER	(15)	Yes
TRANSACTION_ID	NUMBER		Yes
TRANSACTION_LINE_ID	NUMBER		Yes
TRANSACTION_LEVEL_TYPE	VARCHAR2	(30)	Yes
COUNTRY_CODE	VARCHAR2	(30)
TAX	VARCHAR2	(30)
SITUS	VARCHAR2	(30)
TAX_JURISDICTION	VARCHAR2	(30)
TAX_CURRENCY_CODE	VARCHAR2	(15)
TAX_AMOUNT	NUMBER
TAX_CURR_TAX_AMOUNT	NUMBER
TAX_RATE_PERCENTAGE	NUMBER
TAXABLE_AMOUNT	NUMBER
EXEMPT_RATE_MODIFIER	NUMBER
EXEMPT_REASON	VARCHAR2	(240)
TAX_ONLY_LINE_FLAG	VARCHAR2	(1)
INCLUSIVE_TAX_LINE_FLAG	VARCHAR2	(1)
USE_TAX_FLAG	VARCHAR2	(1)
USER_OVERRIDE_FLAG	VARCHAR2	(1)
LAST_MANUAL_ENTRY	VARCHAR2	(30)
MANUALLY_ENTERED_FLAG	VARCHAR2	(1)
FIRST_PARTY_TAX_REG_NUMBER	VARCHAR2	(50)

Query Text

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


SELECT DOCUMENT_TYPE_ID
,      TRANSACTION_ID
,      TRANSACTION_LINE_ID
,      TRANSACTION_LEVEL_TYPE
,      COUNTRY_CODE
,      TAX
,      SITUS
,      TAX_JURISDICTION
,      TAX_CURRENCY_CODE
,      TAX_AMOUNT
,      TAX_CURR_TAX_AMOUNT
,      TAX_RATE_PERCENTAGE
,      TAXABLE_AMOUNT
,      EXEMPT_RATE_MODIFIER
,      EXEMPT_REASON
,      TAX_ONLY_LINE_FLAG
,      INCLUSIVE_TAX_LINE_FLAG
,      USE_TAX_FLAG
,      USER_OVERRIDE_FLAG
,      LAST_MANUAL_ENTRY
,      MANUALLY_ENTERED_FLAG
,      FIRST_PARTY_TAX_REG_NUMBER
FROM APPS.ZX_IMPORT_TAX_LINES_INPUT_V;

Dependencies

[top of page]

APPS.ZX_IMPORT_TAX_LINES_INPUT_V references the following:

APPS: ZX_DETAIL_TAX_LINES_GT; ZX_TRX_PRE_PROC_OPTIONS_GT

APPS.ZX_IMPORT_TAX_LINES_INPUT_V is not referenced by any database object