VIEW: ZX.ZX_PROCESS_RESULTS#

Source

View Text - Preformatted

select CONDITION_GROUP_CODE CONDITION_GROUP_CODE, PRIORITY PRIORITY, RESULT_TYPE_CODE RESULT_TYPE_CODE, TAX_STATUS_CODE TAX_STATUS_CODE, NUMERIC_RESULT NUMERIC_RESULT, ALPHANUMERIC_RESULT ALPHANUMERIC_RESULT, STATUS_RESULT STATUS_RESULT, RATE_RESULT RATE_RESULT, LEGAL_MESSAGE_CODE LEGAL_MESSAGE_CODE, MIN_TAX_AMT MIN_TAX_AMT, MAX_TAX_AMT MAX_TAX_AMT, MIN_TAXABLE_BASIS MIN_TAXABLE_BASIS, MAX_TAXABLE_BASIS MAX_TAXABLE_BASIS, MIN_TAX_RATE MIN_TAX_RATE, MAX_TAX_RATE MAX_TAX_RATE, ENABLED_FLAG ENABLED_FLAG, ALLOW_EXEMPTIONS_FLAG ALLOW_EXEMPTIONS_FLAG, ALLOW_EXCEPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG, RECORD_TYPE_CODE RECORD_TYPE_CODE, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, CONDITION_SET_ID CONDITION_SET_ID, EXCEPTION_SET_ID EXCEPTION_SET_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, RESULT_ID RESULT_ID, CONTENT_OWNER_ID CONTENT_OWNER_ID, CONDITION_GROUP_ID CONDITION_GROUP_ID, TAX_RULE_ID TAX_RULE_ID, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RESULT_API RESULT_API, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "ZX"."ZX_PROCESS_RESULTS"

View Text - HTML Formatted

SELECT CONDITION_GROUP_CODE CONDITION_GROUP_CODE
, PRIORITY PRIORITY
, RESULT_TYPE_CODE RESULT_TYPE_CODE
, TAX_STATUS_CODE TAX_STATUS_CODE
, NUMERIC_RESULT NUMERIC_RESULT
, ALPHANUMERIC_RESULT ALPHANUMERIC_RESULT
, STATUS_RESULT STATUS_RESULT
, RATE_RESULT RATE_RESULT
, LEGAL_MESSAGE_CODE LEGAL_MESSAGE_CODE
, MIN_TAX_AMT MIN_TAX_AMT
, MAX_TAX_AMT MAX_TAX_AMT
, MIN_TAXABLE_BASIS MIN_TAXABLE_BASIS
, MAX_TAXABLE_BASIS MAX_TAXABLE_BASIS
, MIN_TAX_RATE MIN_TAX_RATE
, MAX_TAX_RATE MAX_TAX_RATE
, ENABLED_FLAG ENABLED_FLAG
, ALLOW_EXEMPTIONS_FLAG ALLOW_EXEMPTIONS_FLAG
, ALLOW_EXCEPTIONS_FLAG ALLOW_EXCEPTIONS_FLAG
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, CONDITION_SET_ID CONDITION_SET_ID
, EXCEPTION_SET_ID EXCEPTION_SET_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, RESULT_ID RESULT_ID
, CONTENT_OWNER_ID CONTENT_OWNER_ID
, CONDITION_GROUP_ID CONDITION_GROUP_ID
, TAX_RULE_ID TAX_RULE_ID
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RESULT_API RESULT_API
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "ZX"."ZX_PROCESS_RESULTS"