CSE_W_CLAIMS

Details

Schema: FUSION
Object owner: CSE
Object type: VIEW

Columns

Name
CLAIM_ID OBJECT_VERSION_NUMBER CLAIM_NUMBER CLAIM_DESCRIPTION CLAIM_TYPE_CODE MANUALLY_CREATED_FLAG OBJECT_TYPE_CODE OBJECT_ID WARRANTY_PROVIDER_ID CLAIM_DATE CLAIM_STATUS_CODE SUBMIT_BY_DATE CLAIM_NOTES REIMBURSEMENT_REFERENCE ASSIGNED_TO_PERSON_ID REASON_FOR_REPAIR_CODE_ID PROVIDER_LABOR_RATE MATCH_TO_TXN_CODE_FLAG MATERIAL_AMOUNT_TOTAL EQUIPMENT_AMOUNT_TOTAL LABOR_AMOUNT_TOTAL STANDARD_LABOR_AMOUNT OTHER_AMOUNT CLAIM_AMOUNT CLAIM_ADJUSTMENT_AMOUNT CLAIM_AMOUNT_CURRENCY_CODE CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_RATE REIMBURSEMENT_AMOUNT REIMBURSEMENT_TYPE_CODE RESOLUTION_DATE ACTIVE_END_DATE 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

Name

CLAIM_ID

OBJECT_VERSION_NUMBER

CLAIM_NUMBER

CLAIM_DESCRIPTION

CLAIM_TYPE_CODE

MANUALLY_CREATED_FLAG

OBJECT_TYPE_CODE

OBJECT_ID

WARRANTY_PROVIDER_ID

CLAIM_DATE

CLAIM_STATUS_CODE

SUBMIT_BY_DATE

CLAIM_NOTES

REIMBURSEMENT_REFERENCE

ASSIGNED_TO_PERSON_ID

REASON_FOR_REPAIR_CODE_ID

PROVIDER_LABOR_RATE

MATCH_TO_TXN_CODE_FLAG

MATERIAL_AMOUNT_TOTAL

EQUIPMENT_AMOUNT_TOTAL

LABOR_AMOUNT_TOTAL

STANDARD_LABOR_AMOUNT

OTHER_AMOUNT

CLAIM_AMOUNT

CLAIM_ADJUSTMENT_AMOUNT

CLAIM_AMOUNT_CURRENCY_CODE

CURRENCY_CONVERSION_TYPE

CURRENCY_CONVERSION_RATE

REIMBURSEMENT_AMOUNT

REIMBURSEMENT_TYPE_CODE

RESOLUTION_DATE

ACTIVE_END_DATE

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

Query

SQL_Statement
SELECT cwcb.CLAIM_ID CLAIM_ID, cwcb.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, cwcb.CLAIM_NUMBER CLAIM_NUMBER, cwct.CLAIM_DESCRIPTION CLAIM_DESCRIPTION, cwcb.CLAIM_TYPE_CODE CLAIM_TYPE_CODE, cwcb.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG, cwcb.OBJECT_TYPE_CODE OBJECT_TYPE_CODE, cwcb.OBJECT_ID OBJECT_ID, cwcb.WARRANTY_PROVIDER_ID WARRANTY_PROVIDER_ID, cwcb.CLAIM_DATE CLAIM_DATE, cwcb.CLAIM_STATUS_CODE CLAIM_STATUS_CODE, cwcb.SUBMIT_BY_DATE SUBMIT_BY_DATE, cwcb.CLAIM_NOTES CLAIM_NOTES, cwcb.REIMBURSEMENT_REFERENCE REIMBURSEMENT_REFERENCE, cwcb.ASSIGNED_TO_PERSON_ID ASSIGNED_TO_PERSON_ID, cwcb.REASON_FOR_REPAIR_CODE_ID REASON_FOR_REPAIR_CODE_ID, cwcb.PROVIDER_LABOR_RATE PROVIDER_LABOR_RATE, cwcb.MATCH_TO_TXN_CODE_FLAG MATCH_TO_TXN_CODE_FLAG, cwcb.MATERIAL_AMOUNT_TOTAL MATERIAL_AMOUNT_TOTAL, cwcb.EQUIPMENT_AMOUNT_TOTAL EQUIPMENT_AMOUNT_TOTAL, cwcb.LABOR_AMOUNT_TOTAL LABOR_AMOUNT_TOTAL, cwcb.STANDARD_LABOR_AMOUNT STANDARD_LABOR_AMOUNT, cwcb.OTHER_AMOUNT OTHER_AMOUNT, cwcb.CLAIM_AMOUNT CLAIM_AMOUNT, cwcb.CLAIM_ADJUSTMENT_AMOUNT CLAIM_ADJUSTMENT_AMOUNT, cwcb.CLAIM_AMOUNT_CURRENCY_CODE CLAIM_AMOUNT_CURRENCY_CODE, cwcb.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, cwcb.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, cwcb.REIMBURSEMENT_AMOUNT REIMBURSEMENT_AMOUNT, cwcb.REIMBURSEMENT_TYPE_CODE REIMBURSEMENT_TYPE_CODE, cwcb.RESOLUTION_DATE RESOLUTION_DATE, cwcb.ACTIVE_END_DATE ACTIVE_END_DATE, 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 FROM CSE_W_CLAIMS_B cwcb, CSE_W_CLAIMS_TL cwct WHERE cwct.CLAIM_ID = cwcb.CLAIM_ID AND cwct.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

cwcb.CLAIM_ID CLAIM_ID,

cwcb.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

cwcb.CLAIM_NUMBER CLAIM_NUMBER,

cwct.CLAIM_DESCRIPTION CLAIM_DESCRIPTION,

cwcb.CLAIM_TYPE_CODE CLAIM_TYPE_CODE,

cwcb.MANUALLY_CREATED_FLAG MANUALLY_CREATED_FLAG,

cwcb.OBJECT_TYPE_CODE OBJECT_TYPE_CODE,

cwcb.OBJECT_ID OBJECT_ID,

cwcb.WARRANTY_PROVIDER_ID WARRANTY_PROVIDER_ID,

cwcb.CLAIM_DATE CLAIM_DATE,

cwcb.CLAIM_STATUS_CODE CLAIM_STATUS_CODE,

cwcb.SUBMIT_BY_DATE SUBMIT_BY_DATE,

cwcb.CLAIM_NOTES CLAIM_NOTES,

cwcb.REIMBURSEMENT_REFERENCE REIMBURSEMENT_REFERENCE,

cwcb.ASSIGNED_TO_PERSON_ID ASSIGNED_TO_PERSON_ID,

cwcb.REASON_FOR_REPAIR_CODE_ID REASON_FOR_REPAIR_CODE_ID,

cwcb.PROVIDER_LABOR_RATE PROVIDER_LABOR_RATE,

cwcb.MATCH_TO_TXN_CODE_FLAG MATCH_TO_TXN_CODE_FLAG,

cwcb.MATERIAL_AMOUNT_TOTAL MATERIAL_AMOUNT_TOTAL,

cwcb.EQUIPMENT_AMOUNT_TOTAL EQUIPMENT_AMOUNT_TOTAL,

cwcb.LABOR_AMOUNT_TOTAL LABOR_AMOUNT_TOTAL,

cwcb.STANDARD_LABOR_AMOUNT STANDARD_LABOR_AMOUNT,

cwcb.OTHER_AMOUNT OTHER_AMOUNT,

cwcb.CLAIM_AMOUNT CLAIM_AMOUNT,

cwcb.CLAIM_ADJUSTMENT_AMOUNT CLAIM_ADJUSTMENT_AMOUNT,

cwcb.CLAIM_AMOUNT_CURRENCY_CODE CLAIM_AMOUNT_CURRENCY_CODE,

cwcb.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE,

cwcb.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE,

cwcb.REIMBURSEMENT_AMOUNT REIMBURSEMENT_AMOUNT,

cwcb.REIMBURSEMENT_TYPE_CODE REIMBURSEMENT_TYPE_CODE,

cwcb.RESOLUTION_DATE RESOLUTION_DATE,

cwcb.ACTIVE_END_DATE ACTIVE_END_DATE,

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

FROM

CSE_W_CLAIMS_B cwcb,

CSE_W_CLAIMS_TL cwct

WHERE

cwct.CLAIM_ID = cwcb.CLAIM_ID AND cwct.LANGUAGE = USERENV('LANG')