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

Object Details

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

View Type

MultiLingual view (a language resolved view of the data.)

Displays tax codes and rates.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID1	NUMBER	(15)	Yes	Unique identifier
ID2	CHAR	(1)		(Multi-part) Primary Key
NAME	VARCHAR2	(50)	Yes	The tax code associated with a rate user specified in the Tax Codes and Rates window
TAX_RATE	NUMBER			The tax rate associated with the tax code the user specified in the Tax Codes and Rates window
TAX_TYPE	VARCHAR2	(30)	Yes	This is a lookup column that uses the lookup_type TAX_TYPE.
START_DATE_ACTIVE	DATE		Yes	First date that the tax code is active
END_DATE_ACTIVE	DATE			Last date that the tax code is active
DESCRIPTION	VARCHAR2	(60)		Description of tax code (legal requirement in Italy)
ORG_ID	NUMBER	(15)		Operating Unit Identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	The unique identifier of the set of book
PRINTED_TAX_NAME	VARCHAR2	(60)		The name of this tax code as it appears on the printed invoice
VALIDATE_FLAG	VARCHAR2	(1)		Indicates whether the tax code is of type Ad Hoc
B_STATUS	VARCHAR2	(1)		Y or N indicates whether the tax code is enabled. This field is used in conjunction with START_DATE and END_DATE and allows the tax code to be enabled/disabled even for the start date specified in the START_DATE field.
STATUS	VARCHAR2	(1)		Status
AMOUNT_INCLUDES_TAX_FLAG	VARCHAR2	(1)		When this flag is set to 'Y', the tax code is inclusive by default. Otherwise, it is exclusive.
AMOUNT_INCLUDES_TAX_OVERRIDE	VARCHAR2	(1)		When this flag is set to 'Y', the value of AMOUNT_INCLUDES_TAX_FLAG can be overridden at time of usage. Otherwise, the AMOUNT_INCLUDES_TAX_FLAG at the tax code level must be used.

Query Text

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


SELECT ID1
,      ID2
,      NAME
,      TAX_RATE
,      TAX_TYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      DESCRIPTION
,      ORG_ID
,      SET_OF_BOOKS_ID
,      PRINTED_TAX_NAME
,      VALIDATE_FLAG
,      B_STATUS
,      STATUS
,      AMOUNT_INCLUDES_TAX_FLAG
,      AMOUNT_INCLUDES_TAX_OVERRIDE
FROM APPS.OKX_TAX_CODES_V;

Dependencies

[top of page]

APPS.OKX_TAX_CODES_V references the following:

APPS: AR_VAT_TAX_ALL_B; AR_VAT_TAX_ALL_TL

APPS.OKX_TAX_CODES_V is referenced by following:

APPS: OKL_TPL_PVT - show dependent code