VIEW: BEN.BEN_EXT_DFN#

Source

View Text - Preformatted

select EXT_DFN_ID EXT_DFN_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, KICKOFF_WRT_PRC_FLAG KICKOFF_WRT_PRC_FLAG, APND_RQST_ID_FLAG APND_RQST_ID_FLAG, PRMY_SORT_CD PRMY_SORT_CD, SCND_SORT_CD SCND_SORT_CD, STRT_DT STRT_DT, END_DT END_DT, SPCL_HNDL_FLAG SPCL_HNDL_FLAG, UPD_CM_SENT_DT_FLAG UPD_CM_SENT_DT_FLAG, USE_EFF_DT_FOR_CHGS_FLAG USE_EFF_DT_FOR_CHGS_FLAG, EXT_CRIT_PRFL_ID EXT_CRIT_PRFL_ID, EXT_FILE_ID EXT_FILE_ID, EXT_POST_PRCS_RL EXT_POST_PRCS_RL, XDF_ATTRIBUTE_CATEGORY XDF_ATTRIBUTE_CATEGORY, XDF_ATTRIBUTE1 XDF_ATTRIBUTE1, XDF_ATTRIBUTE2 XDF_ATTRIBUTE2, XDF_ATTRIBUTE3 XDF_ATTRIBUTE3, XDF_ATTRIBUTE4 XDF_ATTRIBUTE4, XDF_ATTRIBUTE5 XDF_ATTRIBUTE5, XDF_ATTRIBUTE6 XDF_ATTRIBUTE6, XDF_ATTRIBUTE7 XDF_ATTRIBUTE7, XDF_ATTRIBUTE8 XDF_ATTRIBUTE8, XDF_ATTRIBUTE9 XDF_ATTRIBUTE9, XDF_ATTRIBUTE10 XDF_ATTRIBUTE10, XDF_ATTRIBUTE11 XDF_ATTRIBUTE11, XDF_ATTRIBUTE12 XDF_ATTRIBUTE12, XDF_ATTRIBUTE13 XDF_ATTRIBUTE13, XDF_ATTRIBUTE14 XDF_ATTRIBUTE14, XDF_ATTRIBUTE15 XDF_ATTRIBUTE15, XDF_ATTRIBUTE16 XDF_ATTRIBUTE16, XDF_ATTRIBUTE17 XDF_ATTRIBUTE17, XDF_ATTRIBUTE18 XDF_ATTRIBUTE18, XDF_ATTRIBUTE19 XDF_ATTRIBUTE19, XDF_ATTRIBUTE20 XDF_ATTRIBUTE20, XDF_ATTRIBUTE21 XDF_ATTRIBUTE21, XDF_ATTRIBUTE22 XDF_ATTRIBUTE22, XDF_ATTRIBUTE23 XDF_ATTRIBUTE23, XDF_ATTRIBUTE24 XDF_ATTRIBUTE24, XDF_ATTRIBUTE25 XDF_ATTRIBUTE25, XDF_ATTRIBUTE26 XDF_ATTRIBUTE26, XDF_ATTRIBUTE27 XDF_ATTRIBUTE27, XDF_ATTRIBUTE28 XDF_ATTRIBUTE28, XDF_ATTRIBUTE29 XDF_ATTRIBUTE29, XDF_ATTRIBUTE30 XDF_ATTRIBUTE30, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, NAME NAME, DATA_TYP_CD DATA_TYP_CD, EXT_TYP_CD EXT_TYP_CD, DRCTRY_NAME DRCTRY_NAME, OUTPUT_NAME OUTPUT_NAME, LEGISLATION_CODE LEGISLATION_CODE, OUTPUT_TYPE OUTPUT_TYPE, XML_TAG_NAME XML_TAG_NAME, XDO_TEMPLATE_ID XDO_TEMPLATE_ID, EXT_GLOBAL_FLAG EXT_GLOBAL_FLAG, CM_DISPLAY_FLAG CM_DISPLAY_FLAG, ZD_EDITION_NAME ZD_EDITION_NAME from "BEN"."BEN_EXT_DFN"

View Text - HTML Formatted

SELECT EXT_DFN_ID EXT_DFN_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, KICKOFF_WRT_PRC_FLAG KICKOFF_WRT_PRC_FLAG
, APND_RQST_ID_FLAG APND_RQST_ID_FLAG
, PRMY_SORT_CD PRMY_SORT_CD
, SCND_SORT_CD SCND_SORT_CD
, STRT_DT STRT_DT
, END_DT END_DT
, SPCL_HNDL_FLAG SPCL_HNDL_FLAG
, UPD_CM_SENT_DT_FLAG UPD_CM_SENT_DT_FLAG
, USE_EFF_DT_FOR_CHGS_FLAG USE_EFF_DT_FOR_CHGS_FLAG
, EXT_CRIT_PRFL_ID EXT_CRIT_PRFL_ID
, EXT_FILE_ID EXT_FILE_ID
, EXT_POST_PRCS_RL EXT_POST_PRCS_RL
, XDF_ATTRIBUTE_CATEGORY XDF_ATTRIBUTE_CATEGORY
, XDF_ATTRIBUTE1 XDF_ATTRIBUTE1
, XDF_ATTRIBUTE2 XDF_ATTRIBUTE2
, XDF_ATTRIBUTE3 XDF_ATTRIBUTE3
, XDF_ATTRIBUTE4 XDF_ATTRIBUTE4
, XDF_ATTRIBUTE5 XDF_ATTRIBUTE5
, XDF_ATTRIBUTE6 XDF_ATTRIBUTE6
, XDF_ATTRIBUTE7 XDF_ATTRIBUTE7
, XDF_ATTRIBUTE8 XDF_ATTRIBUTE8
, XDF_ATTRIBUTE9 XDF_ATTRIBUTE9
, XDF_ATTRIBUTE10 XDF_ATTRIBUTE10
, XDF_ATTRIBUTE11 XDF_ATTRIBUTE11
, XDF_ATTRIBUTE12 XDF_ATTRIBUTE12
, XDF_ATTRIBUTE13 XDF_ATTRIBUTE13
, XDF_ATTRIBUTE14 XDF_ATTRIBUTE14
, XDF_ATTRIBUTE15 XDF_ATTRIBUTE15
, XDF_ATTRIBUTE16 XDF_ATTRIBUTE16
, XDF_ATTRIBUTE17 XDF_ATTRIBUTE17
, XDF_ATTRIBUTE18 XDF_ATTRIBUTE18
, XDF_ATTRIBUTE19 XDF_ATTRIBUTE19
, XDF_ATTRIBUTE20 XDF_ATTRIBUTE20
, XDF_ATTRIBUTE21 XDF_ATTRIBUTE21
, XDF_ATTRIBUTE22 XDF_ATTRIBUTE22
, XDF_ATTRIBUTE23 XDF_ATTRIBUTE23
, XDF_ATTRIBUTE24 XDF_ATTRIBUTE24
, XDF_ATTRIBUTE25 XDF_ATTRIBUTE25
, XDF_ATTRIBUTE26 XDF_ATTRIBUTE26
, XDF_ATTRIBUTE27 XDF_ATTRIBUTE27
, XDF_ATTRIBUTE28 XDF_ATTRIBUTE28
, XDF_ATTRIBUTE29 XDF_ATTRIBUTE29
, XDF_ATTRIBUTE30 XDF_ATTRIBUTE30
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NAME NAME
, DATA_TYP_CD DATA_TYP_CD
, EXT_TYP_CD EXT_TYP_CD
, DRCTRY_NAME DRCTRY_NAME
, OUTPUT_NAME OUTPUT_NAME
, LEGISLATION_CODE LEGISLATION_CODE
, OUTPUT_TYPE OUTPUT_TYPE
, XML_TAG_NAME XML_TAG_NAME
, XDO_TEMPLATE_ID XDO_TEMPLATE_ID
, EXT_GLOBAL_FLAG EXT_GLOBAL_FLAG
, CM_DISPLAY_FLAG CM_DISPLAY_FLAG
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "BEN"."BEN_EXT_DFN"