DBA Data[Home] [Help]

VIEW: QPR.QPR_MEASURE_SOURCES#

Source

View Text - Preformatted

select MEAS_SRC_ID MEAS_SRC_ID, INSTANCE_ID INSTANCE_ID, INSTANCE_TYPE INSTANCE_TYPE, MEASURE_PPA_CODE MEASURE_PPA_CODE, MEASURE_TYPE_CODE MEASURE_TYPE_CODE, SEEDED_FLAG SEEDED_FLAG, SRC_TBL_NAME SRC_TBL_NAME, SRC_COL_NAME SRC_COL_NAME, TGT_TBL_NAME TGT_TBL_NAME, TGT_COL_NAME TGT_COL_NAME, USER_TGT_TBL_NAME USER_TGT_TBL_NAME, USER_SRC_TBL_NAME USER_SRC_TBL_NAME, USER_SRC_COL_NAME USER_SRC_COL_NAME, USER_TGT_COL_NAME USER_TGT_COL_NAME, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "QPR"."QPR_MEASURE_SOURCES"
View Text - HTML Formatted

SELECT MEAS_SRC_ID MEAS_SRC_ID
, INSTANCE_ID INSTANCE_ID
, INSTANCE_TYPE INSTANCE_TYPE
, MEASURE_PPA_CODE MEASURE_PPA_CODE
, MEASURE_TYPE_CODE MEASURE_TYPE_CODE
, SEEDED_FLAG SEEDED_FLAG
, SRC_TBL_NAME SRC_TBL_NAME
, SRC_COL_NAME SRC_COL_NAME
, TGT_TBL_NAME TGT_TBL_NAME
, TGT_COL_NAME TGT_COL_NAME
, USER_TGT_TBL_NAME USER_TGT_TBL_NAME
, USER_SRC_TBL_NAME USER_SRC_TBL_NAME
, USER_SRC_COL_NAME USER_SRC_COL_NAME
, USER_TGT_COL_NAME USER_TGT_COL_NAME
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "QPR"."QPR_MEASURE_SOURCES"