CSE_W_COVERAGES_VL
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: VIEW
Columns
Name |
---|
COVERAGE_ID OBJECT_VERSION_NUMBER COVERAGE_CODE COVERAGE_NAME COVERAGE_DESCRIPTION COVERAGE_STATUS_CODE COVERAGE_START_DATE COVERAGE_END_DATE COVERAGE_TYPE_CODE MANUFACTURER_ID SUPPLIER_ID WARRANTY_PROVIDER_ID WARRANTY_DURATION WARRANTY_DURATION_UOM_CODE TERMS_AND_CONDITIONS REACTIONS_AND_RESOLUTIONS SERVICE_LEVEL_AGREEMENTS INTERNAL_REPAIR_ALLOWED_FLAG AUTHORIZATION_REQUIRED_FLAG PARTS_RETURN_REQUIRED_FLAG PARTS_REIMBURSEMENT_FLAG LABOR_REIMBURSEMENT_FLAG FILTER_BY_TXN_CODE_FLAG EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB005 CURRENCY_CODE CORP_CURRENCY_CODE CURCY_CONV_RATE_TYPE ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE WARRANTY_PROVIDER_TYPE_CODE |
Query
SQL_Statement |
---|
SELECT cwcb.COVERAGE_ID COVERAGE_ID, cwcb.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, cwcb.COVERAGE_CODE COVERAGE_CODE, cwctl.COVERAGE_NAME COVERAGE_NAME, cwctl.COVERAGE_DESCRIPTION COVERAGE_DESCRIPTION, cwcb.COVERAGE_STATUS_CODE COVERAGE_STATUS_CODE, cwcb.COVERAGE_START_DATE COVERAGE_START_DATE, cwcb.COVERAGE_END_DATE COVERAGE_END_DATE, cwcb.COVERAGE_TYPE_CODE COVERAGE_TYPE_CODE, cwcb.MANUFACTURER_ID MANUFACTURER_ID, cwcb.SUPPLIER_ID SUPPLIER_ID, cwcb.WARRANTY_PROVIDER_ID WARRANTY_PROVIDER_ID, cwcb.WARRANTY_DURATION WARRANTY_DURATION, cwcb.WARRANTY_DURATION_UOM_CODE WARRANTY_DURATION_UOM_CODE, cwcb.TERMS_AND_CONDITIONS TERMS_AND_CONDITIONS, cwcb.REACTIONS_AND_RESOLUTIONS REACTIONS_AND_RESOLUTIONS, cwcb.SERVICE_LEVEL_AGREEMENTS SERVICE_LEVEL_AGREEMENTS, cwcb.INTERNAL_REPAIR_ALLOWED_FLAG INTERNAL_REPAIR_ALLOWED_FLAG, cwcb.AUTHORIZATION_REQUIRED_FLAG AUTHORIZATION_REQUIRED_FLAG, cwcb.PARTS_RETURN_REQUIRED_FLAG PARTS_RETURN_REQUIRED_FLAG, cwcb.PARTS_REIMBURSEMENT_FLAG PARTS_REIMBURSEMENT_FLAG, cwcb.LABOR_REIMBURSEMENT_FLAG LABOR_REIMBURSEMENT_FLAG, cwcb.FILTER_BY_TXN_CODE_FLAG FILTER_BY_TXN_CODE_FLAG, cwcb.EXTN_ATTRIBUTE_CHAR001 EXTN_ATTRIBUTE_CHAR001, cwcb.EXTN_ATTRIBUTE_CHAR002 EXTN_ATTRIBUTE_CHAR002, cwcb.EXTN_ATTRIBUTE_CHAR003 EXTN_ATTRIBUTE_CHAR003, cwcb.EXTN_ATTRIBUTE_CHAR004 EXTN_ATTRIBUTE_CHAR004, cwcb.EXTN_ATTRIBUTE_CHAR005 EXTN_ATTRIBUTE_CHAR005, cwcb.EXTN_ATTRIBUTE_CHAR006 EXTN_ATTRIBUTE_CHAR006, cwcb.EXTN_ATTRIBUTE_CHAR007 EXTN_ATTRIBUTE_CHAR007, cwcb.EXTN_ATTRIBUTE_CHAR008 EXTN_ATTRIBUTE_CHAR008, cwcb.EXTN_ATTRIBUTE_CHAR009 EXTN_ATTRIBUTE_CHAR009, cwcb.EXTN_ATTRIBUTE_CHAR010 EXTN_ATTRIBUTE_CHAR010, cwcb.EXTN_ATTRIBUTE_CHAR011 EXTN_ATTRIBUTE_CHAR011, cwcb.EXTN_ATTRIBUTE_CHAR012 EXTN_ATTRIBUTE_CHAR012, cwcb.EXTN_ATTRIBUTE_CHAR013 EXTN_ATTRIBUTE_CHAR013, cwcb.EXTN_ATTRIBUTE_CHAR014 EXTN_ATTRIBUTE_CHAR014, cwcb.EXTN_ATTRIBUTE_CHAR015 EXTN_ATTRIBUTE_CHAR015, cwcb.EXTN_ATTRIBUTE_CHAR016 EXTN_ATTRIBUTE_CHAR016, cwcb.EXTN_ATTRIBUTE_CHAR017 EXTN_ATTRIBUTE_CHAR017, cwcb.EXTN_ATTRIBUTE_CHAR018 EXTN_ATTRIBUTE_CHAR018, cwcb.EXTN_ATTRIBUTE_CHAR019 EXTN_ATTRIBUTE_CHAR019, cwcb.EXTN_ATTRIBUTE_CHAR020 EXTN_ATTRIBUTE_CHAR020, cwcb.EXTN_ATTRIBUTE_CHAR021 EXTN_ATTRIBUTE_CHAR021, cwcb.EXTN_ATTRIBUTE_CHAR022 EXTN_ATTRIBUTE_CHAR022, cwcb.EXTN_ATTRIBUTE_CHAR023 EXTN_ATTRIBUTE_CHAR023, cwcb.EXTN_ATTRIBUTE_CHAR024 EXTN_ATTRIBUTE_CHAR024, cwcb.EXTN_ATTRIBUTE_CHAR025 EXTN_ATTRIBUTE_CHAR025, cwcb.EXTN_ATTRIBUTE_CHAR026 EXTN_ATTRIBUTE_CHAR026, cwcb.EXTN_ATTRIBUTE_CHAR027 EXTN_ATTRIBUTE_CHAR027, cwcb.EXTN_ATTRIBUTE_CHAR028 EXTN_ATTRIBUTE_CHAR028, cwcb.EXTN_ATTRIBUTE_CHAR029 EXTN_ATTRIBUTE_CHAR029, cwcb.EXTN_ATTRIBUTE_CHAR030 EXTN_ATTRIBUTE_CHAR030, cwcb.EXTN_ATTRIBUTE_CHAR031 EXTN_ATTRIBUTE_CHAR031, cwcb.EXTN_ATTRIBUTE_CHAR032 EXTN_ATTRIBUTE_CHAR032, cwcb.EXTN_ATTRIBUTE_CHAR033 EXTN_ATTRIBUTE_CHAR033, cwcb.EXTN_ATTRIBUTE_CHAR034 EXTN_ATTRIBUTE_CHAR034, cwcb.EXTN_ATTRIBUTE_CHAR035 EXTN_ATTRIBUTE_CHAR035, cwcb.EXTN_ATTRIBUTE_CHAR036 EXTN_ATTRIBUTE_CHAR036, cwcb.EXTN_ATTRIBUTE_CHAR037 EXTN_ATTRIBUTE_CHAR037, cwcb.EXTN_ATTRIBUTE_CHAR038 EXTN_ATTRIBUTE_CHAR038, cwcb.EXTN_ATTRIBUTE_CHAR039 EXTN_ATTRIBUTE_CHAR039, cwcb.EXTN_ATTRIBUTE_CHAR040 EXTN_ATTRIBUTE_CHAR040, cwcb.EXTN_ATTRIBUTE_CHAR041 EXTN_ATTRIBUTE_CHAR041, cwcb.EXTN_ATTRIBUTE_CHAR042 EXTN_ATTRIBUTE_CHAR042, cwcb.EXTN_ATTRIBUTE_CHAR043 EXTN_ATTRIBUTE_CHAR043, cwcb.EXTN_ATTRIBUTE_CHAR044 EXTN_ATTRIBUTE_CHAR044, cwcb.EXTN_ATTRIBUTE_CHAR045 EXTN_ATTRIBUTE_CHAR045, cwcb.EXTN_ATTRIBUTE_CHAR046 EXTN_ATTRIBUTE_CHAR046, cwcb.EXTN_ATTRIBUTE_CHAR047 EXTN_ATTRIBUTE_CHAR047, cwcb.EXTN_ATTRIBUTE_CHAR048 EXTN_ATTRIBUTE_CHAR048, cwcb.EXTN_ATTRIBUTE_CHAR049 EXTN_ATTRIBUTE_CHAR049, cwcb.EXTN_ATTRIBUTE_CHAR050 EXTN_ATTRIBUTE_CHAR050, cwcb.EXTN_ATTRIBUTE_CHAR051 EXTN_ATTRIBUTE_CHAR051, cwcb.EXTN_ATTRIBUTE_CHAR052 EXTN_ATTRIBUTE_CHAR052, cwcb.EXTN_ATTRIBUTE_CHAR053 EXTN_ATTRIBUTE_CHAR053, cwcb.EXTN_ATTRIBUTE_CHAR054 EXTN_ATTRIBUTE_CHAR054, cwcb.EXTN_ATTRIBUTE_CHAR055 EXTN_ATTRIBUTE_CHAR055, cwcb.EXTN_ATTRIBUTE_CHAR056 EXTN_ATTRIBUTE_CHAR056, cwcb.EXTN_ATTRIBUTE_CHAR057 EXTN_ATTRIBUTE_CHAR057, cwcb.EXTN_ATTRIBUTE_CHAR058 EXTN_ATTRIBUTE_CHAR058, cwcb.EXTN_ATTRIBUTE_CHAR059 EXTN_ATTRIBUTE_CHAR059, cwcb.EXTN_ATTRIBUTE_CHAR060 EXTN_ATTRIBUTE_CHAR060, cwcb.EXTN_ATTRIBUTE_CHAR061 EXTN_ATTRIBUTE_CHAR061, cwcb.EXTN_ATTRIBUTE_CHAR062 EXTN_ATTRIBUTE_CHAR062, cwcb.EXTN_ATTRIBUTE_CHAR063 EXTN_ATTRIBUTE_CHAR063, cwcb.EXTN_ATTRIBUTE_CHAR064 EXTN_ATTRIBUTE_CHAR064, cwcb.EXTN_ATTRIBUTE_CHAR065 EXTN_ATTRIBUTE_CHAR065, cwcb.EXTN_ATTRIBUTE_CHAR066 EXTN_ATTRIBUTE_CHAR066, cwcb.EXTN_ATTRIBUTE_CHAR067 EXTN_ATTRIBUTE_CHAR067, cwcb.EXTN_ATTRIBUTE_CHAR068 EXTN_ATTRIBUTE_CHAR068, cwcb.EXTN_ATTRIBUTE_CHAR069 EXTN_ATTRIBUTE_CHAR069, cwcb.EXTN_ATTRIBUTE_CHAR070 EXTN_ATTRIBUTE_CHAR070, cwcb.EXTN_ATTRIBUTE_CHAR071 EXTN_ATTRIBUTE_CHAR071, cwcb.EXTN_ATTRIBUTE_CHAR072 EXTN_ATTRIBUTE_CHAR072, cwcb.EXTN_ATTRIBUTE_CHAR073 EXTN_ATTRIBUTE_CHAR073, cwcb.EXTN_ATTRIBUTE_CHAR074 EXTN_ATTRIBUTE_CHAR074, cwcb.EXTN_ATTRIBUTE_CHAR075 EXTN_ATTRIBUTE_CHAR075, cwcb.EXTN_ATTRIBUTE_CHAR076 EXTN_ATTRIBUTE_CHAR076, cwcb.EXTN_ATTRIBUTE_CHAR077 EXTN_ATTRIBUTE_CHAR077, cwcb.EXTN_ATTRIBUTE_CHAR078 EXTN_ATTRIBUTE_CHAR078, cwcb.EXTN_ATTRIBUTE_CHAR079 EXTN_ATTRIBUTE_CHAR079, cwcb.EXTN_ATTRIBUTE_CHAR080 EXTN_ATTRIBUTE_CHAR080, cwcb.EXTN_ATTRIBUTE_CHAR081 EXTN_ATTRIBUTE_CHAR081, cwcb.EXTN_ATTRIBUTE_CHAR082 EXTN_ATTRIBUTE_CHAR082, cwcb.EXTN_ATTRIBUTE_CHAR083 EXTN_ATTRIBUTE_CHAR083, cwcb.EXTN_ATTRIBUTE_CHAR084 EXTN_ATTRIBUTE_CHAR084, cwcb.EXTN_ATTRIBUTE_CHAR085 EXTN_ATTRIBUTE_CHAR085, cwcb.EXTN_ATTRIBUTE_CHAR086 EXTN_ATTRIBUTE_CHAR086, cwcb.EXTN_ATTRIBUTE_CHAR087 EXTN_ATTRIBUTE_CHAR087, cwcb.EXTN_ATTRIBUTE_CHAR088 EXTN_ATTRIBUTE_CHAR088, cwcb.EXTN_ATTRIBUTE_CHAR089 EXTN_ATTRIBUTE_CHAR089, cwcb.EXTN_ATTRIBUTE_CHAR090 EXTN_ATTRIBUTE_CHAR090, cwcb.EXTN_ATTRIBUTE_CHAR091 EXTN_ATTRIBUTE_CHAR091, cwcb.EXTN_ATTRIBUTE_CHAR092 EXTN_ATTRIBUTE_CHAR092, cwcb.EXTN_ATTRIBUTE_CHAR093 EXTN_ATTRIBUTE_CHAR093, cwcb.EXTN_ATTRIBUTE_CHAR094 EXTN_ATTRIBUTE_CHAR094, cwcb.EXTN_ATTRIBUTE_CHAR095 EXTN_ATTRIBUTE_CHAR095, cwcb.EXTN_ATTRIBUTE_CHAR096 EXTN_ATTRIBUTE_CHAR096, cwcb.EXTN_ATTRIBUTE_CHAR097 EXTN_ATTRIBUTE_CHAR097, cwcb.EXTN_ATTRIBUTE_CHAR098 EXTN_ATTRIBUTE_CHAR098, cwcb.EXTN_ATTRIBUTE_CHAR099 EXTN_ATTRIBUTE_CHAR099, cwcb.EXTN_ATTRIBUTE_CHAR100 EXTN_ATTRIBUTE_CHAR100, cwcb.EXTN_ATTRIBUTE_NUMBER001 EXTN_ATTRIBUTE_NUMBER001, cwcb.EXTN_ATTRIBUTE_NUMBER002 EXTN_ATTRIBUTE_NUMBER002, cwcb.EXTN_ATTRIBUTE_NUMBER003 EXTN_ATTRIBUTE_NUMBER003, cwcb.EXTN_ATTRIBUTE_NUMBER004 EXTN_ATTRIBUTE_NUMBER004, cwcb.EXTN_ATTRIBUTE_NUMBER005 EXTN_ATTRIBUTE_NUMBER005, cwcb.EXTN_ATTRIBUTE_NUMBER006 EXTN_ATTRIBUTE_NUMBER006, cwcb.EXTN_ATTRIBUTE_NUMBER007 EXTN_ATTRIBUTE_NUMBER007, cwcb.EXTN_ATTRIBUTE_NUMBER008 EXTN_ATTRIBUTE_NUMBER008, cwcb.EXTN_ATTRIBUTE_NUMBER009 EXTN_ATTRIBUTE_NUMBER009, cwcb.EXTN_ATTRIBUTE_NUMBER010 EXTN_ATTRIBUTE_NUMBER010, cwcb.EXTN_ATTRIBUTE_NUMBER011 EXTN_ATTRIBUTE_NUMBER011, cwcb.EXTN_ATTRIBUTE_NUMBER012 EXTN_ATTRIBUTE_NUMBER012, cwcb.EXTN_ATTRIBUTE_NUMBER013 EXTN_ATTRIBUTE_NUMBER013, cwcb.EXTN_ATTRIBUTE_NUMBER014 EXTN_ATTRIBUTE_NUMBER014, cwcb.EXTN_ATTRIBUTE_NUMBER015 EXTN_ATTRIBUTE_NUMBER015, cwcb.EXTN_ATTRIBUTE_NUMBER016 EXTN_ATTRIBUTE_NUMBER016, cwcb.EXTN_ATTRIBUTE_NUMBER017 EXTN_ATTRIBUTE_NUMBER017, cwcb.EXTN_ATTRIBUTE_NUMBER018 EXTN_ATTRIBUTE_NUMBER018, cwcb.EXTN_ATTRIBUTE_NUMBER019 EXTN_ATTRIBUTE_NUMBER019, cwcb.EXTN_ATTRIBUTE_NUMBER020 EXTN_ATTRIBUTE_NUMBER020, cwcb.EXTN_ATTRIBUTE_NUMBER021 EXTN_ATTRIBUTE_NUMBER021, cwcb.EXTN_ATTRIBUTE_NUMBER022 EXTN_ATTRIBUTE_NUMBER022, cwcb.EXTN_ATTRIBUTE_NUMBER023 EXTN_ATTRIBUTE_NUMBER023, cwcb.EXTN_ATTRIBUTE_NUMBER024 EXTN_ATTRIBUTE_NUMBER024, cwcb.EXTN_ATTRIBUTE_NUMBER025 EXTN_ATTRIBUTE_NUMBER025, cwcb.EXTN_ATTRIBUTE_NUMBER026 EXTN_ATTRIBUTE_NUMBER026, cwcb.EXTN_ATTRIBUTE_NUMBER027 EXTN_ATTRIBUTE_NUMBER027, cwcb.EXTN_ATTRIBUTE_NUMBER028 EXTN_ATTRIBUTE_NUMBER028, cwcb.EXTN_ATTRIBUTE_NUMBER029 EXTN_ATTRIBUTE_NUMBER029, cwcb.EXTN_ATTRIBUTE_NUMBER030 EXTN_ATTRIBUTE_NUMBER030, cwcb.EXTN_ATTRIBUTE_NUMBER031 EXTN_ATTRIBUTE_NUMBER031, cwcb.EXTN_ATTRIBUTE_NUMBER032 EXTN_ATTRIBUTE_NUMBER032, cwcb.EXTN_ATTRIBUTE_NUMBER033 EXTN_ATTRIBUTE_NUMBER033, cwcb.EXTN_ATTRIBUTE_NUMBER034 EXTN_ATTRIBUTE_NUMBER034, cwcb.EXTN_ATTRIBUTE_NUMBER035 EXTN_ATTRIBUTE_NUMBER035, cwcb.EXTN_ATTRIBUTE_NUMBER036 EXTN_ATTRIBUTE_NUMBER036, cwcb.EXTN_ATTRIBUTE_NUMBER037 EXTN_ATTRIBUTE_NUMBER037, cwcb.EXTN_ATTRIBUTE_NUMBER038 EXTN_ATTRIBUTE_NUMBER038, cwcb.EXTN_ATTRIBUTE_NUMBER039 EXTN_ATTRIBUTE_NUMBER039, cwcb.EXTN_ATTRIBUTE_NUMBER040 EXTN_ATTRIBUTE_NUMBER040, cwcb.EXTN_ATTRIBUTE_NUMBER041 EXTN_ATTRIBUTE_NUMBER041, cwcb.EXTN_ATTRIBUTE_NUMBER042 EXTN_ATTRIBUTE_NUMBER042, cwcb.EXTN_ATTRIBUTE_NUMBER043 EXTN_ATTRIBUTE_NUMBER043, cwcb.EXTN_ATTRIBUTE_NUMBER044 EXTN_ATTRIBUTE_NUMBER044, cwcb.EXTN_ATTRIBUTE_NUMBER045 EXTN_ATTRIBUTE_NUMBER045, cwcb.EXTN_ATTRIBUTE_NUMBER046 EXTN_ATTRIBUTE_NUMBER046, cwcb.EXTN_ATTRIBUTE_NUMBER047 EXTN_ATTRIBUTE_NUMBER047, cwcb.EXTN_ATTRIBUTE_NUMBER048 EXTN_ATTRIBUTE_NUMBER048, cwcb.EXTN_ATTRIBUTE_NUMBER049 EXTN_ATTRIBUTE_NUMBER049, cwcb.EXTN_ATTRIBUTE_NUMBER050 EXTN_ATTRIBUTE_NUMBER050, cwcb.EXTN_ATTRIBUTE_TIMESTAMP001 EXTN_ATTRIBUTE_TIMESTAMP001, cwcb.EXTN_ATTRIBUTE_TIMESTAMP002 EXTN_ATTRIBUTE_TIMESTAMP002, cwcb.EXTN_ATTRIBUTE_TIMESTAMP003 EXTN_ATTRIBUTE_TIMESTAMP003, cwcb.EXTN_ATTRIBUTE_TIMESTAMP004 EXTN_ATTRIBUTE_TIMESTAMP004, cwcb.EXTN_ATTRIBUTE_TIMESTAMP005 EXTN_ATTRIBUTE_TIMESTAMP005, cwcb.EXTN_ATTRIBUTE_TIMESTAMP006 EXTN_ATTRIBUTE_TIMESTAMP006, cwcb.EXTN_ATTRIBUTE_TIMESTAMP007 EXTN_ATTRIBUTE_TIMESTAMP007, cwcb.EXTN_ATTRIBUTE_TIMESTAMP008 EXTN_ATTRIBUTE_TIMESTAMP008, cwcb.EXTN_ATTRIBUTE_TIMESTAMP009 EXTN_ATTRIBUTE_TIMESTAMP009, cwcb.EXTN_ATTRIBUTE_TIMESTAMP010 EXTN_ATTRIBUTE_TIMESTAMP010, cwcb.EXTN_ATTRIBUTE_CLOB001 EXTN_ATTRIBUTE_CLOB001, cwcb.EXTN_ATTRIBUTE_CLOB002 EXTN_ATTRIBUTE_CLOB002, cwcb.EXTN_ATTRIBUTE_CLOB003 EXTN_ATTRIBUTE_CLOB003, cwcb.EXTN_ATTRIBUTE_CLOB004 EXTN_ATTRIBUTE_CLOB004, cwcb.EXTN_ATTRIBUTE_CLOB005 EXTN_ATTRIBUTE_CLOB005, cwcb.CURRENCY_CODE CURRENCY_CODE, cwcb.CORP_CURRENCY_CODE CORP_CURRENCY_CODE, cwcb.CURCY_CONV_RATE_TYPE CURCY_CONV_RATE_TYPE, cwcb.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, cwcb.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, cwcb.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, cwcb.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, cwcb.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, cwcb.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, cwcb.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, cwcb.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, cwcb.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, cwcb.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, cwcb.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, cwcb.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, cwcb.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, cwcb.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, cwcb.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, cwcb.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, cwcb.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, cwcb.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, cwcb.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, cwcb.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, cwcb.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, cwcb.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, cwcb.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, cwcb.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, cwcb.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, cwcb.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, cwcb.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, cwcb.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, cwcb.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, cwcb.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, cwcb.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, cwcb.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, cwcb.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, cwcb.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, cwcb.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, cwcb.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, cwcb.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, cwcb.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, cwcb.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, cwcb.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, cwcb.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, cwcb.CREATED_BY CREATED_BY, cwcb.CREATION_DATE CREATION_DATE, cwcb.LAST_UPDATED_BY LAST_UPDATED_BY, cwcb.LAST_UPDATE_DATE LAST_UPDATE_DATE, cwcb.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, cwcb.REQUEST_ID REQUEST_ID, cwcb.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, cwcb.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE, cwcb.WARRANTY_PROVIDER_TYPE_CODE FROM CSE_W_COVERAGES_B cwcb, CSE_W_COVERAGES_TL cwctl WHERE cwctl.COVERAGE_ID = cwcb.COVERAGE_ID AND cwctl.LANGUAGE = USERENV('LANG') |