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]

TABLE: ZX.ZX_EXEMPTIONS

Object Details

Object Name:	ZX_EXEMPTIONS
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_EXEMPTIONS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_EXEMPTIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAX_EXEMPTION_ID
ZX_EXEMPTIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_REGIME_CODE TAX CONTENT_OWNER_ID
ZX_EXEMPTIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARTY_TAX_PROFILE_ID EXEMPT_REASON_CODE EXEMPTION_STATUS_CODE CONTENT_OWNER_ID TAX_REGIME_CODE TAX TAX_JURISDICTION_ID PRODUCT_ID INVENTORY_ORG_ID EFFECTIVE_FROM TAX_STATUS_CODE TAX_RATE_CODE EXEMPT_CERTIFICATE_NUMBER CUST_ACCOUNT_ID SITE_USE_ID DUPLICATE_EXEMPTION

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_EXEMPTION_ID	NUMBER	(15)	Yes	Unique identifier
EXEMPTION_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code that indicates the type of this exemption. Possible values are DISCOUNT and SPECIAL_RATE.
EXEMPTION_STATUS_CODE	VARCHAR2	(30)	Yes	Lookup code that indicates approval status for this exemption
TAX_REGIME_CODE	VARCHAR2	(30)	Yes	Tax regime code for this exemption
TAX_STATUS_CODE	VARCHAR2	(30)		Tax status code for this exemption
TAX	VARCHAR2	(30)		Tax for this exemption
TAX_RATE_CODE	VARCHAR2	(50)		Tax rate code for this exemption
EXEMPT_CERTIFICATE_NUMBER	VARCHAR2	(80)		Exemption certificate number
EXEMPT_REASON_CODE	VARCHAR2	(30)		Lookup code that indicates the reason for this exemption
ISSUING_TAX_AUTHORITY_ID	NUMBER	(15)		Party tax profile identifier for the tax authority that has issued the exemption certificate for this exemption
EFFECTIVE_FROM	DATE			Effective from date
EFFECTIVE_TO	DATE			Effective to date
CONTENT_OWNER_ID	NUMBER	(15)	Yes	Party tax profile identifier for configuration owner of this exemption
PRODUCT_ID	NUMBER			Inventory Item for this exemption
INVENTORY_ORG_ID	NUMBER			Inventory organization identifier for the item
RATE_MODIFIER	NUMBER			Percentage of the original tax rate that is exempt
TAX_JURISDICTION_ID	NUMBER	(15)		Tax jurisdiction for this exemption
DET_FACTOR_TEMPL_CODE	VARCHAR2	(30)		Determining factor template code for this exemption
RECORD_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate whether the record is migrated, seeded or defined by the user
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of last concurrent program to update this record
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure defining column
APPLY_TO_LOWER_LEVELS_FLAG	VARCHAR2	(1)		Y or N Indicates if this exemption is applicable to taxes at lower levels
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
PARTY_TAX_PROFILE_ID	NUMBER	(15)	Yes	Party tax profile identifier of the party for which this exemption applies
CUST_ACCOUNT_ID	NUMBER	(15)		Internal identifier of the customer account. This column is used only for migrated records
SITE_USE_ID	NUMBER	(15)		Internal identifier of the customer site use. This column is used only for migrated records
DUPLICATE_EXEMPTION	NUMBER			Duplicate record number for this exemption when there are duplicate item exceptions and exemptions migrated

Query Text

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


SELECT TAX_EXEMPTION_ID
,      EXEMPTION_TYPE_CODE
,      EXEMPTION_STATUS_CODE
,      TAX_REGIME_CODE
,      TAX_STATUS_CODE
,      TAX
,      TAX_RATE_CODE
,      EXEMPT_CERTIFICATE_NUMBER
,      EXEMPT_REASON_CODE
,      ISSUING_TAX_AUTHORITY_ID
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      CONTENT_OWNER_ID
,      PRODUCT_ID
,      INVENTORY_ORG_ID
,      RATE_MODIFIER
,      TAX_JURISDICTION_ID
,      DET_FACTOR_TEMPL_CODE
,      RECORD_TYPE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_LOGIN_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      APPLY_TO_LOWER_LEVELS_FLAG
,      OBJECT_VERSION_NUMBER
,      PARTY_TAX_PROFILE_ID
,      CUST_ACCOUNT_ID
,      SITE_USE_ID
,      DUPLICATE_EXEMPTION
FROM ZX.ZX_EXEMPTIONS;

Dependencies

[top of page]

ZX.ZX_EXEMPTIONS does not reference any database object

ZX.ZX_EXEMPTIONS is referenced by following:

APPS: ZX_EXEMPTIONS; ZX_EXEMPTIONS_TMP; ZX_MCO_EXEMPTIONS; ZX_SCO_EXEMPTIONS