VIEW: IMC.IMC_THREE_SIXTY_QUERY_B#

Source

View Text - Preformatted

select QUERY_ID QUERY_ID, APPLICATION_ID APPLICATION_ID, QUERY_TYPE_FLAG QUERY_TYPE_FLAG, PRODUCT_QUERY1 PRODUCT_QUERY1, PRODUCT_QUERY2 PRODUCT_QUERY2, PRODUCT_QUERY3 PRODUCT_QUERY3, PRODUCT_QUERY4 PRODUCT_QUERY4, PRODUCT_QUERY5 PRODUCT_QUERY5, SEQUENCE_NO SEQUENCE_NO, SECURITY_FUNCTION SECURITY_FUNCTION, DISPLAY_FLAG DISPLAY_FLAG, FILTER_COUNT FILTER_COUNT, DISPLAY_COLUMN_COUNT DISPLAY_COLUMN_COUNT, PRODUCT_URL PRODUCT_URL, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BE_CODE BE_CODE, CATEGORY_CODE CATEGORY_CODE, OPERATING_UNIT_FLAG OPERATING_UNIT_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "IMC"."IMC_THREE_SIXTY_QUERY_B"

View Text - HTML Formatted

SELECT QUERY_ID QUERY_ID
, APPLICATION_ID APPLICATION_ID
, QUERY_TYPE_FLAG QUERY_TYPE_FLAG
, PRODUCT_QUERY1 PRODUCT_QUERY1
, PRODUCT_QUERY2 PRODUCT_QUERY2
, PRODUCT_QUERY3 PRODUCT_QUERY3
, PRODUCT_QUERY4 PRODUCT_QUERY4
, PRODUCT_QUERY5 PRODUCT_QUERY5
, SEQUENCE_NO SEQUENCE_NO
, SECURITY_FUNCTION SECURITY_FUNCTION
, DISPLAY_FLAG DISPLAY_FLAG
, FILTER_COUNT FILTER_COUNT
, DISPLAY_COLUMN_COUNT DISPLAY_COLUMN_COUNT
, PRODUCT_URL PRODUCT_URL
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BE_CODE BE_CODE
, CATEGORY_CODE CATEGORY_CODE
, OPERATING_UNIT_FLAG OPERATING_UNIT_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "IMC"."IMC_THREE_SIXTY_QUERY_B"