ZX_DET_FACTOR_TEMPL_VL

Details

• Schema: FUSION

• Object owner: FND

• Object type: VIEW

Columns

Name
ROW_ID PROGRAM_LOGIN_ID DET_FACTOR_TEMPL_ID DET_FACTOR_TEMPL_CODE TAX_REGIME_CODE LEDGER_ID CHART_OF_ACCOUNTS_ID TEMPLATE_USAGE_CODE RECORD_TYPE_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY PROGRAM_NAME PROGRAM_APP_NAME REQUEST_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER DET_FACTOR_TEMPL_NAME DET_FACTOR_TEMPL_DESC TAX SERVICE_TYPE_CODE

Query

SQL_Statement

SELECT B.ROWID ROW_ID ,B.PROGRAM_LOGIN_ID ,B.DET_FACTOR_TEMPL_ID ,B.DET_FACTOR_TEMPL_CODE ,B.TAX_REGIME_CODE ,B.LEDGER_ID ,B.CHART_OF_ACCOUNTS_ID ,B.TEMPLATE_USAGE_CODE ,B.RECORD_TYPE_CODE ,B.CREATED_BY ,B.CREATION_DATE ,B.LAST_UPDATED_BY ,B.PROGRAM_NAME ,B.PROGRAM_APP_NAME ,B.REQUEST_ID ,B.LAST_UPDATE_DATE ,B.LAST_UPDATE_LOGIN ,B.OBJECT_VERSION_NUMBER ,T.DET_FACTOR_TEMPL_NAME ,T.DET_FACTOR_TEMPL_DESC ,B.TAX ,B.SERVICE_TYPE_CODE FROM ZX_DET_FACTOR_TEMPL_TL T, ZX_DET_FACTOR_TEMPL_B B WHERE B.DET_FACTOR_TEMPL_ID = T.DET_FACTOR_TEMPL_ID AND T.LANGUAGE = userenv('LANG')