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_EXEMPTIONS_V

Object Details

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

View Type

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

This table stores tax exemptions for either customers, sites or items.
Each tax exemption is for a particular tax code and a particular percentage of exemption.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ID1	NUMBER	(15)	Yes	Internal Exemption Identifier
ID2	CHAR	(1)		(Multi-part) Primary Key
APPROVAL_STATUS	VARCHAR2	(30)	Yes	Approval Status for this exemption
NAME	VARCHAR2	(30)	Yes	Exemptions can be for Customers at a location, or for Items at a location, but not Customers and Items at a location.
TAX_CODE	VARCHAR2	(50)	Yes	Tax Code to which this exemption applies
PERCENT_EXEMPT	NUMBER		Yes	100% means that this is a full exemption from tax
START_DATE_ACTIVE	DATE		Yes	First date that this exemption is effective
END_DATE_ACTIVE	DATE			Last date that this exemption is effective
B_STATUS	VARCHAR2	(30)	Yes	Approval Status for this exemption
STATUS	VARCHAR2	(1)		Status
DESCRIPTION	VARCHAR2	(30)		The reason for this exemption
ORG_ID	NUMBER	(15)		Operating Unit Identifier
INVENTORY_ITEM_ID	NUMBER	(15)		Inventory Item for which this exemption applies
CUSTOMER_ID	NUMBER	(15)		Ship to Customer for whom this exemption applies
SITE_USE_ID	NUMBER	(15)		Ship to Site Use for which this exemption applies
CUSTOMER_EXCEPTION_NUMBER	VARCHAR2	(80)		Exemption certificate number
IN_USE_FLAG	VARCHAR2	(1)	Yes	In Use Flag

Query Text

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


SELECT ID1
,      ID2
,      APPROVAL_STATUS
,      NAME
,      TAX_CODE
,      PERCENT_EXEMPT
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      B_STATUS
,      STATUS
,      DESCRIPTION
,      ORG_ID
,      INVENTORY_ITEM_ID
,      CUSTOMER_ID
,      SITE_USE_ID
,      CUSTOMER_EXCEPTION_NUMBER
,      IN_USE_FLAG
FROM APPS.OKX_TAX_EXEMPTIONS_V;

Dependencies

[top of page]

APPS.OKX_TAX_EXEMPTIONS_V references the following:

APPS: RA_TAX_EXEMPTIONS_ALL

APPS.OKX_TAX_EXEMPTIONS_V is not referenced by any database object