VIEW: APPS.ZX_DETERMINING_FACTORS_VL

Source

View Text - Preformatted

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_APPLICATION_ID
         ,B.PROGRAM_ID
         ,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
    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')

   

View Text - HTML Formatted

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_APPLICATION_ID
, B.PROGRAM_ID
, 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
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')