MOT_QM_PREDICTION_FORMULA_VL

Details

• Schema: FUSION

• Object owner: MOT

• Object type: VIEW

Columns

Name
PREDICTION_FORMULA_ID FORMULA_NUMBER FORMULA_EXPRESSION NO_OF_PARAMETERS FORMULA_NAME FORMULA_DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN CREATED_BY_PARTY_ID LAST_UPDATED_BY_PARTY_ID TYPE_CODE STATUS_CODE

Query

SQL_Statement

SELECT MOT_QM_PREDICTION_FORMULA_B.PREDICTION_FORMULA_ID PREDICTION_FORMULA_ID, MOT_QM_PREDICTION_FORMULA_B.FORMULA_NUMBER FORMULA_NUMBER, MOT_QM_PREDICTION_FORMULA_B.FORMULA_EXPRESSION FORMULA_EXPRESSION, MOT_QM_PREDICTION_FORMULA_B.NO_OF_PARAMETERS NO_OF_PARAMETERS, MOT_QM_PREDICTION_FORMULA_TL.FORMULA_NAME FORMULA_NAME, MOT_QM_PREDICTION_FORMULA_TL.FORMULA_DESCRIPTION FORMULA_DESCRIPTION, MOT_QM_PREDICTION_FORMULA_B.OBJECT_VERSION_NUMBER, MOT_QM_PREDICTION_FORMULA_B.CREATED_BY, MOT_QM_PREDICTION_FORMULA_B.CREATION_DATE, MOT_QM_PREDICTION_FORMULA_B.LAST_UPDATED_BY, MOT_QM_PREDICTION_FORMULA_B.LAST_UPDATE_DATE, MOT_QM_PREDICTION_FORMULA_B.LAST_UPDATE_LOGIN, MOT_QM_PREDICTION_FORMULA_B.CREATED_BY_PARTY_ID CREATED_BY_PARTY_ID, MOT_QM_PREDICTION_FORMULA_B.LAST_UPDATED_BY_PARTY_ID LAST_UPDATED_BY_PARTY_ID, MOT_QM_PREDICTION_FORMULA_B.TYPE_CODE TYPE_CODE, MOT_QM_PREDICTION_FORMULA_B.STATUS_CODE STATUS_CODE FROM MOT_QM_PREDICTION_FORMULA_B, MOT_QM_PREDICTION_FORMULA_TL WHERE MOT_QM_PREDICTION_FORMULA_B.PREDICTION_FORMULA_ID = MOT_QM_PREDICTION_FORMULA_TL.PREDICTION_FORMULA_ID AND MOT_QM_PREDICTION_FORMULA_TL.LANGUAGE = USERENV('LANG')