ZX_RULES_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_RULE_ID CONTENT_OWNER_ID TAX_RULE_CODE TAX TAX_REGIME_CODE SERVICE_TYPE_CODE RECOVERY_TYPE_CODE PRIORITY DET_FACTOR_TEMPL_CODE SYSTEM_DEFAULT_FLAG EFFECTIVE_FROM EFFECTIVE_TO ENABLED_FLAG APPLICATION_ID RECORD_TYPE_CODE TAX_EVENT_CLASS_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID TAX_RULE_NAME TAX_RULE_DESC OBJECT_VERSION_NUMBER DETERMINING_FACTOR_CQ_CODE GEOGRAPHY_TYPE GEOGRAPHY_ID TAX_LAW_REF_CODE TAX_LAW_REF_DESC LAST_UPDATE_MODE_FLAG NEVER_BEEN_ENABLED_FLAG EVENT_CLASS_MAPPING_ID TAX_STATUS_CODE REPORTING_TYPE_CODE PERIODICITY_CODE

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.TAX_RULE_ID, B.CONTENT_OWNER_ID, B.TAX_RULE_CODE, B.TAX, B.TAX_REGIME_CODE, B.SERVICE_TYPE_CODE, B.RECOVERY_TYPE_CODE, B.PRIORITY, B.DET_FACTOR_TEMPL_CODE, B.SYSTEM_DEFAULT_FLAG, B.EFFECTIVE_FROM, B.EFFECTIVE_TO, B.ENABLED_FLAG, B.APPLICATION_ID, B.RECORD_TYPE_CODE, B.TAX_EVENT_CLASS_CODE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.REQUEST_ID, B.PROGRAM_APP_NAME, B.PROGRAM_NAME, B.PROGRAM_LOGIN_ID, T.TAX_RULE_NAME, T.TAX_RULE_DESC, B.OBJECT_VERSION_NUMBER, B.DETERMINING_FACTOR_CQ_CODE, B.GEOGRAPHY_TYPE, B.GEOGRAPHY_ID, B.TAX_LAW_REF_CODE, T.TAX_LAW_REF_DESC, B.LAST_UPDATE_MODE_FLAG, B.NEVER_BEEN_ENABLED_FLAG, B.EVENT_CLASS_MAPPING_ID, B.TAX_STATUS_CODE, B.REPORTING_TYPE_CODE, B.PERIODICITY_CODE FROM ZX_RULES_TL T, ZX_RULES_B B WHERE B.TAX_RULE_ID = T.TAX_RULE_ID AND T.LANGUAGE = USERENV('LANG')