1. Tables and Views for Procurement
  2. POI_MODELS_V

POI_MODELS_V

Details

  • Schema: FUSION

  • Object owner: POI

  • Object type: VIEW

Columns

Name

MODEL_NAME

TAXONOMY_ID

CREATION_DATE

START_DATE

END_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

TARGET_COLUMN

STATUS

MODEL_TYPE

BUILD_OPERATION_NAME

DATA_SOURCE_LISTS

ERROR_MESSAGE

CURRENT_STEP

CURRENT_STEP_PERCENT_COMPLETE

OPERATION_TYPE

Query

SQL_Statement

SELECT model_name,taxonomy_id,

creation_date,start_date,

end_date,created_by,

last_update_date,last_updated_by,

target_column,status,'H'model_type,

BUILD_OPERATION_NAME,data_source_lists,

error_message,

current_step,

current_step_percent_complete,

OPERATION_TYPE

FROM poi_h_models