VIEW: OTA.OTA_RESOURCE_DEFINITIONS#

Source

View Text - Preformatted

select RESOURCE_DEFINITION_ID RESOURCE_DEFINITION_ID, ENABLED_FLAG ENABLED_FLAG, ID_FLEX_NUM ID_FLEX_NUM, SUMMARY_FLAG SUMMARY_FLAG, END_DATE_ACTIVE END_DATE_ACTIVE, RESOURCE_NAME RESOURCE_NAME, SEGMENT1 SEGMENT1, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT2 SEGMENT2, SEGMENT20 SEGMENT20, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, START_DATE_ACTIVE START_DATE_ACTIVE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "OTA"."OTA_RESOURCE_DEFINITIONS"

View Text - HTML Formatted

SELECT RESOURCE_DEFINITION_ID RESOURCE_DEFINITION_ID
, ENABLED_FLAG ENABLED_FLAG
, ID_FLEX_NUM ID_FLEX_NUM
, SUMMARY_FLAG SUMMARY_FLAG
, END_DATE_ACTIVE END_DATE_ACTIVE
, RESOURCE_NAME RESOURCE_NAME
, SEGMENT1 SEGMENT1
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT2 SEGMENT2
, SEGMENT20 SEGMENT20
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, START_DATE_ACTIVE START_DATE_ACTIVE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "OTA"."OTA_RESOURCE_DEFINITIONS"