[Home] [Help] [Dependency Information]
Object Name: | ZX_PRODUCT_OPTIONS_ALL# |
---|---|
Object Type: | VIEW |
Owner: | ZX |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Yes | |
APPLICATION_ID | NUMBER | Yes | ||
DEF_OPTION_HIER_1_CODE | VARCHAR2 | (30) | ||
DEF_OPTION_HIER_2_CODE | VARCHAR2 | (30) | ||
DEF_OPTION_HIER_3_CODE | VARCHAR2 | (30) | ||
DEF_OPTION_HIER_4_CODE | VARCHAR2 | (30) | ||
DEF_OPTION_HIER_5_CODE | VARCHAR2 | (30) | ||
DEF_OPTION_HIER_6_CODE | VARCHAR2 | (30) | ||
TAX_CLASSIFICATION_CODE | VARCHAR2 | (50) | ||
TAX_METHOD_CODE | VARCHAR2 | (30) | ||
INCLUSIVE_TAX_USED_FLAG | VARCHAR2 | (1) | ||
TAX_USE_CUSTOMER_EXEMPT_FLAG | VARCHAR2 | (1) | ||
TAX_USE_PRODUCT_EXEMPT_FLAG | VARCHAR2 | (1) | ||
TAX_USE_LOC_EXC_RATE_FLAG | VARCHAR2 | (1) | ||
TAX_ALLOW_COMPOUND_FLAG | VARCHAR2 | (1) | ||
TAX_ROUNDING_RULE | VARCHAR2 | (30) | ||
TAX_PRECISION | NUMBER | (1) | ||
TAX_MINIMUM_ACCOUNTABLE_UNIT | NUMBER | |||
USE_TAX_CLASSIFICATION_FLAG | VARCHAR2 | (1) | ||
ALLOW_TAX_ROUNDING_OVRD_FLAG | VARCHAR2 | (1) | ||
HOME_COUNTRY_DEFAULT_FLAG | VARCHAR2 | (1) | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
RECORD_TYPE_CODE | VARCHAR2 | (30) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
EVENT_CLASS_MAPPING_ID | NUMBER | (15) | ||
DEF_OPTION_HIER_7_CODE | VARCHAR2 | (30) | ||
PRODUCT_OPTIONS_ID | NUMBER | (15) | ||
SALES_TAX_GEOCODE | VARCHAR2 | (30) | ||
TAX_CURRENCY_CODE | VARCHAR2 | (15) |
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#;
|
|
|