VIEW: BOM.CST_REPORT_TYPES#

Source

View Text - Preformatted

select UNIQUE_ID UNIQUE_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REPORT_NAME REPORT_NAME, REPORT_TITLE REPORT_TITLE, DESCRIPTION DESCRIPTION, USER_DEFINED USER_DEFINED, COLUMN1_HEADING COLUMN1_HEADING, COLUMN2_HEADING COLUMN2_HEADING, COLUMN3_HEADING COLUMN3_HEADING, COLUMN4_HEADING COLUMN4_HEADING, COLUMN1 COLUMN1, COLUMN2 COLUMN2, COLUMN3 COLUMN3, COLUMN4 COLUMN4, INVENTORY_FLAG INVENTORY_FLAG, DISABLE_DATE DISABLE_DATE, FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID, DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEXFIELD_NAME, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "BOM"."CST_REPORT_TYPES"

View Text - HTML Formatted

SELECT UNIQUE_ID UNIQUE_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REPORT_NAME REPORT_NAME
, REPORT_TITLE REPORT_TITLE
, DESCRIPTION DESCRIPTION
, USER_DEFINED USER_DEFINED
, COLUMN1_HEADING COLUMN1_HEADING
, COLUMN2_HEADING COLUMN2_HEADING
, COLUMN3_HEADING COLUMN3_HEADING
, COLUMN4_HEADING COLUMN4_HEADING
, COLUMN1 COLUMN1
, COLUMN2 COLUMN2
, COLUMN3 COLUMN3
, COLUMN4 COLUMN4
, INVENTORY_FLAG INVENTORY_FLAG
, DISABLE_DATE DISABLE_DATE
, FLEXFIELD_APPLICATION_ID FLEXFIELD_APPLICATION_ID
, DESCRIPTIVE_FLEXFIELD_NAME DESCRIPTIVE_FLEXFIELD_NAME
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BOM"."CST_REPORT_TYPES"