VIEW: BEN.BEN_CRT_ORDR#

Source

View Text - Preformatted

select CRT_ORDR_ID CRT_ORDR_ID, CRT_ORDR_TYP_CD CRT_ORDR_TYP_CD, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, APLS_PERD_ENDG_DT APLS_PERD_ENDG_DT, APLS_PERD_STRTG_DT APLS_PERD_STRTG_DT, CRT_IDENT CRT_IDENT, DESCRIPTION DESCRIPTION, DETD_QLFD_ORDR_DT DETD_QLFD_ORDR_DT, ISSUE_DT ISSUE_DT, QDRO_AMT QDRO_AMT, QDRO_DSTR_MTHD_CD QDRO_DSTR_MTHD_CD, QDRO_PCT QDRO_PCT, QDRO_NUM_PYMT_VAL QDRO_NUM_PYMT_VAL, PERSON_ID PERSON_ID, QDRO_PER_PERD_CD QDRO_PER_PERD_CD, RCVD_DT RCVD_DT, UOM UOM, PL_ID PL_ID, CRT_ISSNG CRT_ISSNG, PL_TYP_ID PL_TYP_ID, CRT_ATTRIBUTE_CATEGORY CRT_ATTRIBUTE_CATEGORY, CRT_ATTRIBUTE1 CRT_ATTRIBUTE1, CRT_ATTRIBUTE2 CRT_ATTRIBUTE2, CRT_ATTRIBUTE3 CRT_ATTRIBUTE3, CRT_ATTRIBUTE4 CRT_ATTRIBUTE4, CRT_ATTRIBUTE5 CRT_ATTRIBUTE5, CRT_ATTRIBUTE6 CRT_ATTRIBUTE6, CRT_ATTRIBUTE7 CRT_ATTRIBUTE7, CRT_ATTRIBUTE8 CRT_ATTRIBUTE8, CRT_ATTRIBUTE9 CRT_ATTRIBUTE9, CRT_ATTRIBUTE10 CRT_ATTRIBUTE10, CRT_ATTRIBUTE11 CRT_ATTRIBUTE11, CRT_ATTRIBUTE12 CRT_ATTRIBUTE12, CRT_ATTRIBUTE13 CRT_ATTRIBUTE13, CRT_ATTRIBUTE14 CRT_ATTRIBUTE14, CRT_ATTRIBUTE15 CRT_ATTRIBUTE15, CRT_ATTRIBUTE16 CRT_ATTRIBUTE16, CRT_ATTRIBUTE17 CRT_ATTRIBUTE17, CRT_ATTRIBUTE18 CRT_ATTRIBUTE18, CRT_ATTRIBUTE19 CRT_ATTRIBUTE19, CRT_ATTRIBUTE20 CRT_ATTRIBUTE20, CRT_ATTRIBUTE21 CRT_ATTRIBUTE21, CRT_ATTRIBUTE22 CRT_ATTRIBUTE22, CRT_ATTRIBUTE23 CRT_ATTRIBUTE23, CRT_ATTRIBUTE24 CRT_ATTRIBUTE24, CRT_ATTRIBUTE25 CRT_ATTRIBUTE25, CRT_ATTRIBUTE26 CRT_ATTRIBUTE26, CRT_ATTRIBUTE27 CRT_ATTRIBUTE27, CRT_ATTRIBUTE28 CRT_ATTRIBUTE28, CRT_ATTRIBUTE29 CRT_ATTRIBUTE29, CRT_ATTRIBUTE30 CRT_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 from "BEN"."BEN_CRT_ORDR"

View Text - HTML Formatted

SELECT CRT_ORDR_ID CRT_ORDR_ID
, CRT_ORDR_TYP_CD CRT_ORDR_TYP_CD
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, APLS_PERD_ENDG_DT APLS_PERD_ENDG_DT
, APLS_PERD_STRTG_DT APLS_PERD_STRTG_DT
, CRT_IDENT CRT_IDENT
, DESCRIPTION DESCRIPTION
, DETD_QLFD_ORDR_DT DETD_QLFD_ORDR_DT
, ISSUE_DT ISSUE_DT
, QDRO_AMT QDRO_AMT
, QDRO_DSTR_MTHD_CD QDRO_DSTR_MTHD_CD
, QDRO_PCT QDRO_PCT
, QDRO_NUM_PYMT_VAL QDRO_NUM_PYMT_VAL
, PERSON_ID PERSON_ID
, QDRO_PER_PERD_CD QDRO_PER_PERD_CD
, RCVD_DT RCVD_DT
, UOM UOM
, PL_ID PL_ID
, CRT_ISSNG CRT_ISSNG
, PL_TYP_ID PL_TYP_ID
, CRT_ATTRIBUTE_CATEGORY CRT_ATTRIBUTE_CATEGORY
, CRT_ATTRIBUTE1 CRT_ATTRIBUTE1
, CRT_ATTRIBUTE2 CRT_ATTRIBUTE2
, CRT_ATTRIBUTE3 CRT_ATTRIBUTE3
, CRT_ATTRIBUTE4 CRT_ATTRIBUTE4
, CRT_ATTRIBUTE5 CRT_ATTRIBUTE5
, CRT_ATTRIBUTE6 CRT_ATTRIBUTE6
, CRT_ATTRIBUTE7 CRT_ATTRIBUTE7
, CRT_ATTRIBUTE8 CRT_ATTRIBUTE8
, CRT_ATTRIBUTE9 CRT_ATTRIBUTE9
, CRT_ATTRIBUTE10 CRT_ATTRIBUTE10
, CRT_ATTRIBUTE11 CRT_ATTRIBUTE11
, CRT_ATTRIBUTE12 CRT_ATTRIBUTE12
, CRT_ATTRIBUTE13 CRT_ATTRIBUTE13
, CRT_ATTRIBUTE14 CRT_ATTRIBUTE14
, CRT_ATTRIBUTE15 CRT_ATTRIBUTE15
, CRT_ATTRIBUTE16 CRT_ATTRIBUTE16
, CRT_ATTRIBUTE17 CRT_ATTRIBUTE17
, CRT_ATTRIBUTE18 CRT_ATTRIBUTE18
, CRT_ATTRIBUTE19 CRT_ATTRIBUTE19
, CRT_ATTRIBUTE20 CRT_ATTRIBUTE20
, CRT_ATTRIBUTE21 CRT_ATTRIBUTE21
, CRT_ATTRIBUTE22 CRT_ATTRIBUTE22
, CRT_ATTRIBUTE23 CRT_ATTRIBUTE23
, CRT_ATTRIBUTE24 CRT_ATTRIBUTE24
, CRT_ATTRIBUTE25 CRT_ATTRIBUTE25
, CRT_ATTRIBUTE26 CRT_ATTRIBUTE26
, CRT_ATTRIBUTE27 CRT_ATTRIBUTE27
, CRT_ATTRIBUTE28 CRT_ATTRIBUTE28
, CRT_ATTRIBUTE29 CRT_ATTRIBUTE29
, CRT_ATTRIBUTE30 CRT_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
FROM "BEN"."BEN_CRT_ORDR"