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.

VIEW: ZX.ZX_PRODUCT_OPTIONS_ALL#

Source

View Text - Preformatted


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

View Text - HTML Formatted

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