VIEW: APPS.ZX_SCO_RULES_B_V

Source

View Text - Preformatted

SELECT "TAX_RULE_CODE","TAX","TAX_REGIME_CODE","SERVICE_TYPE_CODE","APPLICATION_ID","RECOVERY_TYPE_CODE","PRIORITY","DET_FACTOR_TEMPL_CODE","SYSTEM_DEFAULT_FLAG","EFFECTIVE_FROM","EFFECTIVE_TO","ENABLED_FLAG","RECORD_TYPE_CODE","CREATION_DATE","LAST_UPDATE_DATE","REQUEST_ID","PROGRAM_APPLICATION_ID","PROGRAM_ID","TAX_EVENT_CLASS_CODE","PROGRAM_LOGIN_ID","TAX_RULE_ID","CONTENT_OWNER_ID","CREATED_BY","LAST_UPDATED_BY","LAST_UPDATE_LOGIN","OBJECT_VERSION_NUMBER","DETERMINING_FACTOR_CQ_CODE","GEOGRAPHY_TYPE","GEOGRAPHY_ID","TAX_LAW_REF_CODE","LAST_UPDATE_MODE_FLAG","NEVER_BEEN_ENABLED_FLAG","EVENT_CLASS_MAPPING_ID" FROM  zx_rules_b

View Text - HTML Formatted

SELECT "TAX_RULE_CODE"
, "TAX"
, "TAX_REGIME_CODE"
, "SERVICE_TYPE_CODE"
, "APPLICATION_ID"
, "RECOVERY_TYPE_CODE"
, "PRIORITY"
, "DET_FACTOR_TEMPL_CODE"
, "SYSTEM_DEFAULT_FLAG"
, "EFFECTIVE_FROM"
, "EFFECTIVE_TO"
, "ENABLED_FLAG"
, "RECORD_TYPE_CODE"
, "CREATION_DATE"
, "LAST_UPDATE_DATE"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "TAX_EVENT_CLASS_CODE"
, "PROGRAM_LOGIN_ID"
, "TAX_RULE_ID"
, "CONTENT_OWNER_ID"
, "CREATED_BY"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_LOGIN"
, "OBJECT_VERSION_NUMBER"
, "DETERMINING_FACTOR_CQ_CODE"
, "GEOGRAPHY_TYPE"
, "GEOGRAPHY_ID"
, "TAX_LAW_REF_CODE"
, "LAST_UPDATE_MODE_FLAG"
, "NEVER_BEEN_ENABLED_FLAG"
, "EVENT_CLASS_MAPPING_ID"
FROM ZX_RULES_B