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_DATA_UPLOAD_DISCARD

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

This is an intermediate table used by data upload program to hold the content not used by e-business tax from third party content provider temporarily.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ATTRIBUTE1	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)	Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)	Descriptive flexfield segment
CHANGE_FLAG	VARCHAR2	(1)	Not currently used
CITY_JURISDICTION_CODE	VARCHAR2	(23)	City jurisdiction code
COUNTRY_CODE	VARCHAR2	(3)	Code of the Country to which the Geography belongs
COUNTRY_STATE_ABBREVIATION	VARCHAR2	(2)	Abbreviation for country or state based onw hether this record is for a country or state
COUNTY_JURISDICTION_CODE	VARCHAR2	(3)	County jurisdiction code
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATION_VERSION	NUMBER	(5)	Column to record the file version of the third party content provider in which this record was first introduced
EFFECTIVE_FROM	DATE		Effective from date
EFFECTIVE_TO	DATE		Effective to date
ERROR_MESSAGE	VARCHAR2	(240)	Error message
GEO_DATA_PROVIDER	VARCHAR2	(60)	Name of the data source provider
GEOGRAPHY_ID	NUMBER	(15)	Unique geography identifier for master geography
GEOGRAPHY_NAME	VARCHAR2	(30)	Primary Name of the geography
JURISDICTION_SERIAL_NUMBER	NUMBER	(1)	0 or 1 to indicate outside and inside city limits for this geography if it represents a city
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
LAST_UPDATION_VERSION	NUMBER	(5)	Column to record the file version of the third party content provider in which this record was last updated
LEASE_TAX_AUTHORITY_LEVEL	VARCHAR2	(6)	Column to store the tax authority level that identifies whether the given lease tax rate is for STATE, COUNTY or CITY
LEASE_TAX_RATE	NUMBER		Tax rate for lease tax
LEASE_TAX_RATE_ACTIVE_FLAG	VARCHAR2	(1)	Y or N indicates whether lease tax rate is active
MULTIPLE_PARENT_FLAG	VARCHAR2	(1)	Y or N indicates whether this geography has more than one parent
PRIMARY_FLAG	VARCHAR2	(1)
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
RECORD_TYPE	NUMBER	(2)	For internal use only
RENTAL_TAX_AUTHORITY_LEVEL	VARCHAR2	(6)	Column to store the tax authority level that identifies whether the given rental tax rate is for STATE, COUNTY or CITY
RENTAL_TAX_RATE	NUMBER		Tax rate for rental tax
RENTAL_TAX_RATE_ACTIVE_FLAG	VARCHAR2	(1)	Y or N indicates whether rental tax rate is active
REQUEST_ID	NUMBER	(15)	Request identifier of last concurrent program to update this record
SALES_TAX_AUTHORITY_LEVEL	VARCHAR2	(6)	Column to store the tax authority level that identifies whether the given sales tax rate is for STATE, COUNTY or CITY
SALES_TAX_RATE	NUMBER		Tax rate for sales tax
SALES_TAX_RATE_ACTIVE_FLAG	VARCHAR2	(1)	Y or N indicates whether sales tax rate is active
STATE_JURISDICTION_CODE	VARCHAR2	(2)	State jurisdiction code
STATUS	VARCHAR2	(60)	Column to indicate whether this record is to be inserted or updated
USE_TAX_AUTHORITY_LEVEL	VARCHAR2	(6)	Column to store the tax authority level that identifies whether the given use tax rate is for STATE, COUNTY or CITY
USE_TAX_RATE	NUMBER		Tax rate for use tax
USE_TAX_RATE_ACTIVE_FLAG	VARCHAR2	(1)	Y or N indicates whether use tax rate is active
ZIP_BEGIN	VARCHAR2	(5)	Column for recording the lowest value in the zip code range
ZIP_END	VARCHAR2	(5)	Column for recording the highest value in the zip code range
ZONE_GEOGRAPHY_ID	NUMBER	(15)	Unique geography identifier for tax geography

Query Text

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


SELECT ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      CHANGE_FLAG
,      CITY_JURISDICTION_CODE
,      COUNTRY_CODE
,      COUNTRY_STATE_ABBREVIATION
,      COUNTY_JURISDICTION_CODE
,      CREATED_BY
,      CREATION_DATE
,      CREATION_VERSION
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ERROR_MESSAGE
,      GEO_DATA_PROVIDER
,      GEOGRAPHY_ID
,      GEOGRAPHY_NAME
,      JURISDICTION_SERIAL_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATION_VERSION
,      LEASE_TAX_AUTHORITY_LEVEL
,      LEASE_TAX_RATE
,      LEASE_TAX_RATE_ACTIVE_FLAG
,      MULTIPLE_PARENT_FLAG
,      PRIMARY_FLAG
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      RECORD_TYPE
,      RENTAL_TAX_AUTHORITY_LEVEL
,      RENTAL_TAX_RATE
,      RENTAL_TAX_RATE_ACTIVE_FLAG
,      REQUEST_ID
,      SALES_TAX_AUTHORITY_LEVEL
,      SALES_TAX_RATE
,      SALES_TAX_RATE_ACTIVE_FLAG
,      STATE_JURISDICTION_CODE
,      STATUS
,      USE_TAX_AUTHORITY_LEVEL
,      USE_TAX_RATE
,      USE_TAX_RATE_ACTIVE_FLAG
,      ZIP_BEGIN
,      ZIP_END
,      ZONE_GEOGRAPHY_ID
FROM ZX.ZX_DATA_UPLOAD_DISCARD;

Dependencies

[top of page]

ZX.ZX_DATA_UPLOAD_DISCARD does not reference any database object

ZX.ZX_DATA_UPLOAD_DISCARD is referenced by following:

APPS: ZX_DATA_UPLOAD_DISCARD