DBA Data[Home] [Help]

VIEW: QPR.QPR_DIM_ATTRIBUTES#

Source

View Text - Preformatted

select DIM_ATTR_ID DIM_ATTR_ID, PRICE_PLAN_DIM_ID PRICE_PLAN_DIM_ID, PRICE_PLAN_ID PRICE_PLAN_ID, ATTR_PPA_CODE ATTR_PPA_CODE, TEMPLATE_FLAG TEMPLATE_FLAG, SEEDED_FLAG SEEDED_FLAG, ATTR_SHORT_NAME ATTR_SHORT_NAME, ATTR_LONG_NAME ATTR_LONG_NAME, ATTR_PLURAL_NAME ATTR_PLURAL_NAME, ATTR_DATA_TYPE ATTR_DATA_TYPE, ATTR_CLASSIFICATION ATTR_CLASSIFICATION, DEFAULT_ORDER_FLAG DEFAULT_ORDER_FLAG, 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_DIM_ATTRIBUTES"
View Text - HTML Formatted

SELECT DIM_ATTR_ID DIM_ATTR_ID
, PRICE_PLAN_DIM_ID PRICE_PLAN_DIM_ID
, PRICE_PLAN_ID PRICE_PLAN_ID
, ATTR_PPA_CODE ATTR_PPA_CODE
, TEMPLATE_FLAG TEMPLATE_FLAG
, SEEDED_FLAG SEEDED_FLAG
, ATTR_SHORT_NAME ATTR_SHORT_NAME
, ATTR_LONG_NAME ATTR_LONG_NAME
, ATTR_PLURAL_NAME ATTR_PLURAL_NAME
, ATTR_DATA_TYPE ATTR_DATA_TYPE
, ATTR_CLASSIFICATION ATTR_CLASSIFICATION
, DEFAULT_ORDER_FLAG DEFAULT_ORDER_FLAG
, 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_DIM_ATTRIBUTES"