ZX_DETERMINING_FACTORS_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name

ROW_ID TAX_CALCULATION_FLAG INTERNAL_FLAG RECORD_ONLY_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID PROGRAM_APP_NAME PROGRAM_NAME PROGRAM_LOGIN_ID TAX_SUMMARIZATION_FLAG TAX_RULES_FLAG TAXABLE_BASIS_FLAG DETERMINING_FACTOR_CLASS_CODE VALUE_SET TAX_PARAMETER_CODE DATA_TYPE_CODE TAX_FUNCTION_CODE RECORD_TYPE_CODE TAX_REGIME_DET_FLAG DETERMINING_FACTOR_CODE DETERMINING_FACTOR_ID DETERMINING_FACTOR_NAME DETERMINING_FACTOR_DESC REPORTING_USAGE_FLAG DEFAULTING_USAGE_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID ,B.TAX_CALCULATION_FLAG ,B.INTERNAL_FLAG ,B.RECORD_ONLY_FLAG ,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 ,B.TAX_SUMMARIZATION_FLAG ,B.TAX_RULES_FLAG ,B.TAXABLE_BASIS_FLAG ,B.DETERMINING_FACTOR_CLASS_CODE ,B.VALUE_SET ,B.TAX_PARAMETER_CODE ,B.DATA_TYPE_CODE ,B.TAX_FUNCTION_CODE ,B.RECORD_TYPE_CODE ,B.TAX_REGIME_DET_FLAG ,B.DETERMINING_FACTOR_CODE ,B.DETERMINING_FACTOR_ID ,T.DETERMINING_FACTOR_NAME ,T.DETERMINING_FACTOR_DESC ,B.REPORTING_USAGE_FLAG ,B.DEFAULTING_USAGE_FLAG FROM ZX_DET_FACTORS_TL T, ZX_DETERMINING_FACTORS_B B WHERE B.DETERMINING_FACTOR_ID = T.DETERMINING_FACTOR_ID AND T.LANGUAGE = userenv('LANG')