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_PRODUCT_OPTIONS_ALL

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_PRODUCT_OPTIONS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PRODUCT_OPTIONS_ID
ZX_PRODUCT_OPTIONS_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ORG_ID APPLICATION_ID EVENT_CLASS_MAPPING_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)	Yes	Internal organization identifier
APPLICATION_ID	NUMBER		Yes	Application identifier
DEF_OPTION_HIER_1_CODE	VARCHAR2	(30)		Lookup code to indicate the first precedence for defauting tax classification code
DEF_OPTION_HIER_2_CODE	VARCHAR2	(30)		Code to indicate the second precedence for defauting tax classification code
DEF_OPTION_HIER_3_CODE	VARCHAR2	(30)		Code to indicate the third precedence for defauting tax classification code
DEF_OPTION_HIER_4_CODE	VARCHAR2	(30)		Code to indicate the fourth precedence for defauting tax classification code
DEF_OPTION_HIER_5_CODE	VARCHAR2	(30)		Code to indicate the fifth precedence for defauting tax classification code
DEF_OPTION_HIER_6_CODE	VARCHAR2	(30)		Code to indicate the sixth precedence for defauting tax classification code
TAX_CLASSIFICATION_CODE	VARCHAR2	(50)		Tax classification code to be defualted if it is not obtained from any of the defaulting hierarchy precedences
TAX_METHOD_CODE	VARCHAR2	(30)		Type of tax method used to determine taxes. Possible values are LTE and EBTAX.
INCLUSIVE_TAX_USED_FLAG	VARCHAR2	(1)		Y or N indicates if inclusive taxes are used for Latin Tax Engine
TAX_USE_CUSTOMER_EXEMPT_FLAG	VARCHAR2	(1)		Y or N indicates if customer exemptions are included when calculating taxes for transactions of this application and operating unit
TAX_USE_PRODUCT_EXEMPT_FLAG	VARCHAR2	(1)		Y or N indicates if item exemptions are included when calculating taxes for transactions of this application and operating unit
TAX_USE_LOC_EXC_RATE_FLAG	VARCHAR2	(1)		Y or N indicates if the tax rate that was defined for specific products based on the customers ship-to address is used for transactions of this application and operating unit
TAX_ALLOW_COMPOUND_FLAG	VARCHAR2	(1)		Y or N indicates if compound taxes are calculated by Latin Tax Engine
TAX_ROUNDING_RULE	VARCHAR2	(30)		Tax rounding rule used by Latin Tax Engine
TAX_PRECISION	NUMBER	(1)		Precision used by Latin Tax Engine
TAX_MINIMUM_ACCOUNTABLE_UNIT	NUMBER			Minimum accountable unit used by Latin Tax Engine
USE_TAX_CLASSIFICATION_FLAG	VARCHAR2	(1)		Y or N indicates if the tax classification code is in use for this application and operating unit
ALLOW_TAX_ROUNDING_OVRD_FLAG	VARCHAR2	(1)		Y or N indicates whether tax rounding override is allowed for Latin Tax Engine
HOME_COUNTRY_DEFAULT_FLAG	VARCHAR2	(1)		Y or N indicates whether country code is to be defaulted when the country of location for this operating unit is same as bill to or ship to location
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
RECORD_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate whether the record is migrated, seeded or defined by the user
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
EVENT_CLASS_MAPPING_ID	NUMBER	(15)		Event class mapping identifier
DEF_OPTION_HIER_7_CODE	VARCHAR2	(30)		Code to indicate the seventh precedence for defauting tax classification code
PRODUCT_OPTIONS_ID	NUMBER	(15)		Unique identifier
SALES_TAX_GEOCODE	VARCHAR2	(30)		State and local tax jurisdiction geocode for United States provided by Taxware for point of order acceptance location
TAX_CURRENCY_CODE	VARCHAR2	(15)

Query Text

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


SELECT ORG_ID
,      APPLICATION_ID
,      DEF_OPTION_HIER_1_CODE
,      DEF_OPTION_HIER_2_CODE
,      DEF_OPTION_HIER_3_CODE
,      DEF_OPTION_HIER_4_CODE
,      DEF_OPTION_HIER_5_CODE
,      DEF_OPTION_HIER_6_CODE
,      TAX_CLASSIFICATION_CODE
,      TAX_METHOD_CODE
,      INCLUSIVE_TAX_USED_FLAG
,      TAX_USE_CUSTOMER_EXEMPT_FLAG
,      TAX_USE_PRODUCT_EXEMPT_FLAG
,      TAX_USE_LOC_EXC_RATE_FLAG
,      TAX_ALLOW_COMPOUND_FLAG
,      TAX_ROUNDING_RULE
,      TAX_PRECISION
,      TAX_MINIMUM_ACCOUNTABLE_UNIT
,      USE_TAX_CLASSIFICATION_FLAG
,      ALLOW_TAX_ROUNDING_OVRD_FLAG
,      HOME_COUNTRY_DEFAULT_FLAG
,      OBJECT_VERSION_NUMBER
,      RECORD_TYPE_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EVENT_CLASS_MAPPING_ID
,      DEF_OPTION_HIER_7_CODE
,      PRODUCT_OPTIONS_ID
,      SALES_TAX_GEOCODE
,      TAX_CURRENCY_CODE
FROM ZX.ZX_PRODUCT_OPTIONS_ALL;

Dependencies

[top of page]

ZX.ZX_PRODUCT_OPTIONS_ALL does not reference any database object

ZX.ZX_PRODUCT_OPTIONS_ALL is referenced by following:

ZX: ZX_PRODUCT_OPTIONS_ALL#