1. Tables and Views for Financials
  2. ZX_SCO_RULES_B_V

ZX_SCO_RULES_B_V

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: VIEW

Columns

Name

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_APP_NAME

PROGRAM_NAME

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

TAX_STATUS_CODE

Query

SQL_Statement

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_APP_NAME,

PROGRAM_NAME,

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,

TAX_STATUS_CODE

FROM

ZX_RULES_B