OKC_K_LINES_VL

Details

  • Schema: FUSION

  • Object owner: OKC

  • Object type: VIEW

Columns

Name

ID

LINE_PUID

MAJOR_VERSION

VERSION_TYPE

LINE_NUMBER

CHR_ID

CLE_ID

DNZ_CHR_ID

LINE_TYPE_ID

START_DATE

END_DATE

OBJECT1_ID1

OBJECT1_ID2

JTOT_OBJECT1_CODE

DISPLAY_SEQUENCE

STS_CODE

UOM_CODE

NUM_OF_ITEM

CURRENCY_CODE

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

PRICE_UNIT

LINE_AMOUNT

TAX_AMOUNT

CANCELLED_AMOUNT

DATE_CANCELLED

DATE_TERMINATED

TRN_CODE

TERM_CANCEL_SOURCE

UNBILLED_TERMINATED_AMONT

CREDITED_AMOUNT

SUPPRESSED_AMOUNT

OVERRIDEN_AMOUNT

ORDER_NUMBER

ORDER_ID

ORDER_LINE_NUMBER

ORDER_LINE_ID

CUSTOMER_ITEM_ID

CUSTOMER_ITEM_NUMBER

NSP_FLAG

UNDEF_UNIT_PRICE

UNDEF_LINE_VALUE

UNDEF_LINE_TOTAL

DELIVERY_DATE

BILLABLE_FLAG

BILL_PLAN_ID

REVENUE_PLAN_ID

SHIP_TO_ACCT_ID

BILL_TO_ACCT_ID

SHIP_TO_SITE_USE_ID

BILL_TO_SITE_USE_ID

SUPPLIER_ID

SUPPLIER_SITE_ID

SHIP_INV_ORG_ID

RECV_INV_ORG_ID

TAX_EXEMPTION_CONTROL

EXEMPT_CERTIFICATE_NUMBER

EXEMPT_REASON_CODE

OUTPUT_TAX_CLASSIFICATION_CODE

ORIG_SYSTEM_SOURCE_CODE

ORIG_SYSTEM_ID1

ORIG_SYSTEM_REFERENCE1

ATTRIBUTE_CATEGORY

ATTRIBUTE1

ATTRIBUTE2

ATTRIBUTE3

ATTRIBUTE4

ATTRIBUTE5

ATTRIBUTE6

ATTRIBUTE7

ATTRIBUTE8

ATTRIBUTE9

ATTRIBUTE10

ATTRIBUTE11

ATTRIBUTE12

ATTRIBUTE13

ATTRIBUTE14

ATTRIBUTE15

ATTRIBUTE16

ATTRIBUTE17

ATTRIBUTE18

ATTRIBUTE19

ATTRIBUTE20

ATTRIBUTE21

ATTRIBUTE22

ATTRIBUTE23

ATTRIBUTE24

ATTRIBUTE25

ATTRIBUTE26

ATTRIBUTE27

ATTRIBUTE28

ATTRIBUTE29

ATTRIBUTE30

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_DATE6

ATTRIBUTE_DATE7

ATTRIBUTE_DATE8

ATTRIBUTE_DATE9

ATTRIBUTE_DATE10

LAST_REV_RECOG_DATE

REVENUE_RECOG_AMT

BUDGET_GROSS_MARGIN

REVENUE_IMPACT_DATE

REQUEST_ID

PROGRAM_NAME

PROGRAM_APP_NAME

SOURCE_CODE_CLASS

PERCENT_COMPLETE

AT_RISK_YN

LINE_VALUE

HOLD_UNTIL_DATE

HOLD_REASON_CODE

LINE_DESCRIPTION

LINE_NAME

LINE_REFERENCE

COGNOMEN

COMMENTS

ITEM_NAME

ITEM_DESCRIPTION

VERSION_TYPE_TL

PAYMENT_TERMS_ID

FREIGHT_TERMS_CODE

FOB_CODE

PURCHASING_CATEGORY_ID

RECV_LOCATION_ID

CARRIER_ID

FIXED_PRICE_SERVICE_YN

AGREEMENT_UNIT_PRICE

AGREEMENT_PRICE_OVER_ALLWD_YN

AGREEMENT_PRICE_LIMIT

AGREEMENT_QTY_LIMIT

AGREEMENT_AMT_LIMIT

AGREED_QTY

AGREED_AMT

MIN_RELEASE_QTY

MIN_RELEASE_AMT

LINE_HIERARCHY_NUMBER

EXTERNAL_KEY1

EXTERNAL_KEY2

CUST_PO_NUMBER

PRICE_LIST_ID

ALLOW_PRICELIST_OVERRIDE_YN

COMMIT_LEVEL_CODE

EXTERNAL_ITEM_SOURCE

EXTERNAL_ITEM_KEY

EXTERNAL_ITEM_REFERENCE1

EXTERNAL_ITEM_REFERENCE2

EXTERNAL_ITEM_REFERENCE3

EXTERNAL_ITEM_REFERENCE4

EXTERNAL_ITEM_REFERENCE5

FULFILLED_QTY

FULFILLED_AMT

HOLD_REASON_CODE_SET_ID

TRN_CODE_SET_ID

ALLOW_PROMOTIONS_YN

SOURCE_SYSTEM_ATTRIBUTES

INVOICE_RULE_ID

EXTERNAL_SEARCH_KEY1

EXTERNAL_SEARCH_KEY2

SHIP_TO_PARTY_ID

SHIP_TO_PARTY_SITE_ID

LANGUAGE

SOURCE_LANG

PRICE_UOM

ACCT_RULE_ID

BILLING_FREQ

ORDER_SOURCE

INVOICE_TEXT

PRICING_ERROR

LINE_SUB_TOTAL

TRX_BUSINESS_CATEGORY

PRODUCT_TYPE

PRODUCT_FISC_CLASSIFICATION

BILLING_FREQ_USED

INVOICE_RULE_ID_USED

RETURN_CREDIT_METHOD_CODE

TERMINATED_AMOUNT

INVOICED_AMOUNT

SUPPRESSED_CREDIT_AMOUNT

ONETIME_AMOUNT

RECURRING_AMOUNT

DATE_RENEWED

TAX_ERROR

PAYMENT_METHOD

PO_NUMBER

WIRE_NUMBER

TRXN_EXTENSION_ID

INSTR_ASSIGNMENT_ID

RENEWAL_TYPE

PRICE_DURING_BILLING_YN

BILLING_DATE_METHOD

SPECIFIC_DAYS

USG_BILLED_AMOUNT

USG_CREDITED_AMOUNT

USG_SUPPRESSED_CREDIT_AMT

PRICE_AS_OF

COVERAGE_SCHEDULE_ID

TRANSACTION_TYPE_NAME

PAYMENT_SET_ID

EST_VAR_CONSIDERATION_AMT

STANDALONE_SELLING_PRICE

PRICE_APPLICATION_RULE

AUTO_APPLY_STRTGY_PRICE_ADJ

LINE_ID

SOURCE_DOC_SYSTEM_CODE

SOURCE_DOC_ID

SOURCE_DOC_LINE_ID

EXTN_ATTRIBUTE_TIMESTAMP001

EXTN_ATTRIBUTE_TIMESTAMP002

EXTN_ATTRIBUTE_TIMESTAMP003

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_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_TIMESTAMP004

EXTN_ATTRIBUTE_TIMESTAMP005

EXTN_ATTRIBUTE_TIMESTAMP006

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_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_CLOB001

EXTN_ATTRIBUTE_CLOB002

EXTN_ATTRIBUTE_TIMESTAMP007

EXTN_ATTRIBUTE_TIMESTAMP008

EXTN_ATTRIBUTE_TIMESTAMP009

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_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_TIMESTAMP010

EXTN_ATTRIBUTE_TIMESTAMP011

EXTN_ATTRIBUTE_TIMESTAMP012

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_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_CLOB003

EXTN_ATTRIBUTE_CLOB004

EXTN_ATTRIBUTE_TIMESTAMP013

EXTN_ATTRIBUTE_TIMESTAMP014

EXTN_ATTRIBUTE_TIMESTAMP015

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_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_TIMESTAMP016

EXTN_ATTRIBUTE_TIMESTAMP017

EXTN_ATTRIBUTE_TIMESTAMP018

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_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_CLOB005

EXTN_ATTRIBUTE_CLOB006

EXTN_ATTRIBUTE_TIMESTAMP019

EXTN_ATTRIBUTE_TIMESTAMP020

EXTN_ATTRIBUTE_TIMESTAMP021

EXTN_ATTRIBUTE_NUMBER049

EXTN_ATTRIBUTE_NUMBER050

EXTN_ATTRIBUTE_NUMBER051

EXTN_ATTRIBUTE_NUMBER052

EXTN_ATTRIBUTE_NUMBER053

EXTN_ATTRIBUTE_NUMBER054

EXTN_ATTRIBUTE_NUMBER055

EXTN_ATTRIBUTE_NUMBER056

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_TIMESTAMP022

EXTN_ATTRIBUTE_TIMESTAMP023

EXTN_ATTRIBUTE_TIMESTAMP024

EXTN_ATTRIBUTE_NUMBER057

EXTN_ATTRIBUTE_NUMBER058

EXTN_ATTRIBUTE_NUMBER059

EXTN_ATTRIBUTE_NUMBER060

EXTN_ATTRIBUTE_NUMBER061

EXTN_ATTRIBUTE_NUMBER062

EXTN_ATTRIBUTE_NUMBER063

EXTN_ATTRIBUTE_NUMBER064

EXTN_ATTRIBUTE_CHAR099

EXTN_ATTRIBUTE_CHAR100

EXTN_ATTRIBUTE_CHAR101

EXTN_ATTRIBUTE_CHAR102

EXTN_ATTRIBUTE_CHAR103

EXTN_ATTRIBUTE_CHAR104

EXTN_ATTRIBUTE_CHAR105

EXTN_ATTRIBUTE_CHAR106

EXTN_ATTRIBUTE_CHAR107

EXTN_ATTRIBUTE_CHAR108

EXTN_ATTRIBUTE_CHAR109

EXTN_ATTRIBUTE_CHAR110

EXTN_ATTRIBUTE_CHAR111

EXTN_ATTRIBUTE_CHAR112

EXTN_ATTRIBUTE_CLOB007

EXTN_ATTRIBUTE_CLOB008

EXTN_ATTRIBUTE_TIMESTAMP025

EXTN_ATTRIBUTE_TIMESTAMP026

EXTN_ATTRIBUTE_TIMESTAMP027

EXTN_ATTRIBUTE_NUMBER065

EXTN_ATTRIBUTE_NUMBER066

EXTN_ATTRIBUTE_NUMBER067

EXTN_ATTRIBUTE_NUMBER068

EXTN_ATTRIBUTE_NUMBER069

EXTN_ATTRIBUTE_NUMBER070

EXTN_ATTRIBUTE_NUMBER071

EXTN_ATTRIBUTE_NUMBER072

EXTN_ATTRIBUTE_CHAR113

EXTN_ATTRIBUTE_CHAR114

EXTN_ATTRIBUTE_CHAR115

EXTN_ATTRIBUTE_CHAR116

EXTN_ATTRIBUTE_CHAR117

EXTN_ATTRIBUTE_CHAR118

EXTN_ATTRIBUTE_CHAR119

EXTN_ATTRIBUTE_CHAR120

EXTN_ATTRIBUTE_CHAR121

EXTN_ATTRIBUTE_CHAR122

EXTN_ATTRIBUTE_CHAR123

EXTN_ATTRIBUTE_CHAR124

EXTN_ATTRIBUTE_CHAR125

EXTN_ATTRIBUTE_CHAR126

EXTN_ATTRIBUTE_TIMESTAMP028

EXTN_ATTRIBUTE_TIMESTAMP029

EXTN_ATTRIBUTE_TIMESTAMP030

EXTN_ATTRIBUTE_NUMBER073

EXTN_ATTRIBUTE_NUMBER074

EXTN_ATTRIBUTE_NUMBER075

EXTN_ATTRIBUTE_NUMBER076

EXTN_ATTRIBUTE_NUMBER077

EXTN_ATTRIBUTE_NUMBER078

EXTN_ATTRIBUTE_NUMBER079

EXTN_ATTRIBUTE_NUMBER080

EXTN_ATTRIBUTE_CHAR127

EXTN_ATTRIBUTE_CHAR128

EXTN_ATTRIBUTE_CHAR129

EXTN_ATTRIBUTE_CHAR130

EXTN_ATTRIBUTE_CHAR131

EXTN_ATTRIBUTE_CHAR132

EXTN_ATTRIBUTE_CHAR133

EXTN_ATTRIBUTE_CHAR134

EXTN_ATTRIBUTE_CHAR135

EXTN_ATTRIBUTE_CHAR136

EXTN_ATTRIBUTE_CHAR137

EXTN_ATTRIBUTE_CHAR138

EXTN_ATTRIBUTE_CHAR139

EXTN_ATTRIBUTE_CHAR140

EXTN_ATTRIBUTE_CLOB009

EXTN_ATTRIBUTE_CLOB010

EXTN_ATTRIBUTE_TIMESTAMP031

EXTN_ATTRIBUTE_TIMESTAMP032

EXTN_ATTRIBUTE_TIMESTAMP033

EXTN_ATTRIBUTE_NUMBER081

EXTN_ATTRIBUTE_NUMBER082

EXTN_ATTRIBUTE_NUMBER083

EXTN_ATTRIBUTE_NUMBER084

EXTN_ATTRIBUTE_NUMBER085

EXTN_ATTRIBUTE_NUMBER086

EXTN_ATTRIBUTE_NUMBER087

EXTN_ATTRIBUTE_NUMBER088

EXTN_ATTRIBUTE_CHAR141

EXTN_ATTRIBUTE_CHAR142

EXTN_ATTRIBUTE_CHAR143

EXTN_ATTRIBUTE_CHAR144

EXTN_ATTRIBUTE_CHAR145

EXTN_ATTRIBUTE_CHAR146

EXTN_ATTRIBUTE_CHAR147

EXTN_ATTRIBUTE_CHAR148

EXTN_ATTRIBUTE_CHAR149

EXTN_ATTRIBUTE_CHAR150

EXTN_ATTRIBUTE_CHAR151

EXTN_ATTRIBUTE_CHAR152

EXTN_ATTRIBUTE_CHAR153

EXTN_ATTRIBUTE_CHAR154

EXTN_ATTRIBUTE_TIMESTAMP034

EXTN_ATTRIBUTE_TIMESTAMP035

EXTN_ATTRIBUTE_TIMESTAMP036

EXTN_ATTRIBUTE_NUMBER089

EXTN_ATTRIBUTE_NUMBER090

EXTN_ATTRIBUTE_NUMBER091

EXTN_ATTRIBUTE_NUMBER092

EXTN_ATTRIBUTE_NUMBER093

EXTN_ATTRIBUTE_NUMBER094

EXTN_ATTRIBUTE_NUMBER095

EXTN_ATTRIBUTE_NUMBER096

EXTN_ATTRIBUTE_CHAR155

EXTN_ATTRIBUTE_CHAR156

EXTN_ATTRIBUTE_CHAR157

EXTN_ATTRIBUTE_CHAR158

EXTN_ATTRIBUTE_CHAR159

EXTN_ATTRIBUTE_CHAR160

EXTN_ATTRIBUTE_CHAR161

EXTN_ATTRIBUTE_CHAR162

EXTN_ATTRIBUTE_CHAR163

EXTN_ATTRIBUTE_CHAR164

EXTN_ATTRIBUTE_CHAR165

EXTN_ATTRIBUTE_CHAR166

EXTN_ATTRIBUTE_CHAR167

EXTN_ATTRIBUTE_CHAR168

EXTN_ATTRIBUTE_CLOB011

EXTN_ATTRIBUTE_CLOB012

EXTN_ATTRIBUTE_TIMESTAMP037

EXTN_ATTRIBUTE_TIMESTAMP038

EXTN_ATTRIBUTE_TIMESTAMP039

EXTN_ATTRIBUTE_NUMBER097

EXTN_ATTRIBUTE_NUMBER098

EXTN_ATTRIBUTE_NUMBER099

EXTN_ATTRIBUTE_NUMBER100

EXTN_ATTRIBUTE_NUMBER101

EXTN_ATTRIBUTE_NUMBER102

EXTN_ATTRIBUTE_NUMBER103

EXTN_ATTRIBUTE_NUMBER104

EXTN_ATTRIBUTE_CHAR169

EXTN_ATTRIBUTE_CHAR170

EXTN_ATTRIBUTE_CHAR171

EXTN_ATTRIBUTE_CHAR172

EXTN_ATTRIBUTE_CHAR173

EXTN_ATTRIBUTE_CHAR174

EXTN_ATTRIBUTE_CHAR175

EXTN_ATTRIBUTE_CHAR176

EXTN_ATTRIBUTE_CHAR177

EXTN_ATTRIBUTE_CHAR178

EXTN_ATTRIBUTE_CHAR179

EXTN_ATTRIBUTE_CHAR180

EXTN_ATTRIBUTE_CHAR181

EXTN_ATTRIBUTE_CHAR182

EXTN_ATTRIBUTE_TIMESTAMP040

EXTN_ATTRIBUTE_TIMESTAMP041

EXTN_ATTRIBUTE_TIMESTAMP042

EXTN_ATTRIBUTE_NUMBER105

EXTN_ATTRIBUTE_NUMBER106

EXTN_ATTRIBUTE_NUMBER107

EXTN_ATTRIBUTE_NUMBER108

EXTN_ATTRIBUTE_NUMBER109

EXTN_ATTRIBUTE_NUMBER110

EXTN_ATTRIBUTE_NUMBER111

EXTN_ATTRIBUTE_NUMBER112

EXTN_ATTRIBUTE_CHAR183

EXTN_ATTRIBUTE_CHAR184

EXTN_ATTRIBUTE_CHAR185

EXTN_ATTRIBUTE_CHAR186

EXTN_ATTRIBUTE_CHAR187

EXTN_ATTRIBUTE_CHAR188

EXTN_ATTRIBUTE_CHAR189

EXTN_ATTRIBUTE_CHAR190

EXTN_ATTRIBUTE_CHAR191

EXTN_ATTRIBUTE_CHAR192

EXTN_ATTRIBUTE_CHAR193

EXTN_ATTRIBUTE_CHAR194

EXTN_ATTRIBUTE_CHAR195

EXTN_ATTRIBUTE_CHAR196

EXTN_ATTRIBUTE_CLOB013

EXTN_ATTRIBUTE_CLOB014

EXTN_ATTRIBUTE_TIMESTAMP043

EXTN_ATTRIBUTE_TIMESTAMP044

EXTN_ATTRIBUTE_TIMESTAMP045

EXTN_ATTRIBUTE_NUMBER113

EXTN_ATTRIBUTE_NUMBER114

EXTN_ATTRIBUTE_NUMBER115

EXTN_ATTRIBUTE_NUMBER116

EXTN_ATTRIBUTE_NUMBER117

EXTN_ATTRIBUTE_NUMBER118

EXTN_ATTRIBUTE_NUMBER119

EXTN_ATTRIBUTE_NUMBER120

EXTN_ATTRIBUTE_CHAR197

EXTN_ATTRIBUTE_CHAR198

EXTN_ATTRIBUTE_CHAR199

EXTN_ATTRIBUTE_CHAR200

EXTN_ATTRIBUTE_CHAR201

EXTN_ATTRIBUTE_CHAR202

EXTN_ATTRIBUTE_CHAR203

EXTN_ATTRIBUTE_CHAR204

EXTN_ATTRIBUTE_CHAR205

EXTN_ATTRIBUTE_CHAR206

EXTN_ATTRIBUTE_CHAR207

EXTN_ATTRIBUTE_CHAR208

EXTN_ATTRIBUTE_CHAR209

EXTN_ATTRIBUTE_CHAR210

EXTN_ATTRIBUTE_TIMESTAMP046

EXTN_ATTRIBUTE_TIMESTAMP047

EXTN_ATTRIBUTE_TIMESTAMP048

EXTN_ATTRIBUTE_NUMBER121

EXTN_ATTRIBUTE_NUMBER122

EXTN_ATTRIBUTE_NUMBER123

EXTN_ATTRIBUTE_NUMBER124

EXTN_ATTRIBUTE_NUMBER125

EXTN_ATTRIBUTE_NUMBER126

EXTN_ATTRIBUTE_NUMBER127

EXTN_ATTRIBUTE_NUMBER128

EXTN_ATTRIBUTE_CHAR211

EXTN_ATTRIBUTE_CHAR212

EXTN_ATTRIBUTE_CHAR213

EXTN_ATTRIBUTE_CHAR214

EXTN_ATTRIBUTE_CHAR215

EXTN_ATTRIBUTE_CHAR216

EXTN_ATTRIBUTE_CHAR217

EXTN_ATTRIBUTE_CHAR218

EXTN_ATTRIBUTE_CHAR219

EXTN_ATTRIBUTE_CHAR220

EXTN_ATTRIBUTE_CHAR221

EXTN_ATTRIBUTE_CHAR222

EXTN_ATTRIBUTE_CHAR223

EXTN_ATTRIBUTE_CHAR224

EXTN_ATTRIBUTE_CLOB015

EXTN_ATTRIBUTE_CLOB016

EXTN_ATTRIBUTE_TIMESTAMP049

EXTN_ATTRIBUTE_TIMESTAMP050

EXTN_ATTRIBUTE_NUMBER129

EXTN_ATTRIBUTE_NUMBER130

EXTN_ATTRIBUTE_NUMBER131

EXTN_ATTRIBUTE_NUMBER132

EXTN_ATTRIBUTE_NUMBER133

EXTN_ATTRIBUTE_NUMBER134

EXTN_ATTRIBUTE_NUMBER135

EXTN_ATTRIBUTE_NUMBER136

EXTN_ATTRIBUTE_CHAR225

EXTN_ATTRIBUTE_CHAR226

EXTN_ATTRIBUTE_CHAR227

EXTN_ATTRIBUTE_CHAR228

EXTN_ATTRIBUTE_CHAR229

EXTN_ATTRIBUTE_CHAR230

EXTN_ATTRIBUTE_CHAR231

EXTN_ATTRIBUTE_CHAR232

EXTN_ATTRIBUTE_CHAR233

EXTN_ATTRIBUTE_CHAR234

EXTN_ATTRIBUTE_CHAR235

EXTN_ATTRIBUTE_CHAR236

EXTN_ATTRIBUTE_CHAR237

EXTN_ATTRIBUTE_CHAR238

EXTN_ATTRIBUTE_NUMBER137

EXTN_ATTRIBUTE_NUMBER138

EXTN_ATTRIBUTE_NUMBER139

EXTN_ATTRIBUTE_NUMBER140

EXTN_ATTRIBUTE_NUMBER141

EXTN_ATTRIBUTE_NUMBER142

EXTN_ATTRIBUTE_NUMBER143

EXTN_ATTRIBUTE_NUMBER144

EXTN_ATTRIBUTE_CHAR239

EXTN_ATTRIBUTE_CHAR240

EXTN_ATTRIBUTE_CHAR241

EXTN_ATTRIBUTE_CHAR242

EXTN_ATTRIBUTE_CHAR243

EXTN_ATTRIBUTE_CHAR244

EXTN_ATTRIBUTE_CHAR245

EXTN_ATTRIBUTE_CHAR246

EXTN_ATTRIBUTE_CHAR247

EXTN_ATTRIBUTE_CHAR248

EXTN_ATTRIBUTE_CHAR249

EXTN_ATTRIBUTE_CHAR250

EXTN_ATTRIBUTE_CHAR251

EXTN_ATTRIBUTE_CHAR252

EXTN_ATTRIBUTE_CLOB017

EXTN_ATTRIBUTE_CLOB018

EXTN_ATTRIBUTE_NUMBER145

EXTN_ATTRIBUTE_NUMBER146

EXTN_ATTRIBUTE_NUMBER147

EXTN_ATTRIBUTE_NUMBER148

EXTN_ATTRIBUTE_NUMBER149

EXTN_ATTRIBUTE_NUMBER150

EXTN_ATTRIBUTE_NUMBER151

EXTN_ATTRIBUTE_NUMBER152

EXTN_ATTRIBUTE_CHAR253

EXTN_ATTRIBUTE_CHAR254

EXTN_ATTRIBUTE_CHAR255

EXTN_ATTRIBUTE_CHAR256

EXTN_ATTRIBUTE_CHAR257

EXTN_ATTRIBUTE_CHAR258

EXTN_ATTRIBUTE_CHAR259

EXTN_ATTRIBUTE_CHAR260

EXTN_ATTRIBUTE_CHAR261

EXTN_ATTRIBUTE_CHAR262

EXTN_ATTRIBUTE_CHAR263

EXTN_ATTRIBUTE_CHAR264

EXTN_ATTRIBUTE_CHAR265

EXTN_ATTRIBUTE_CHAR266

EXTN_ATTRIBUTE_NUMBER153

EXTN_ATTRIBUTE_NUMBER154

EXTN_ATTRIBUTE_NUMBER155

EXTN_ATTRIBUTE_NUMBER156

EXTN_ATTRIBUTE_NUMBER157

EXTN_ATTRIBUTE_NUMBER158

EXTN_ATTRIBUTE_NUMBER159

EXTN_ATTRIBUTE_NUMBER160

EXTN_ATTRIBUTE_CHAR267

EXTN_ATTRIBUTE_CHAR268

EXTN_ATTRIBUTE_CHAR269

EXTN_ATTRIBUTE_CHAR270

EXTN_ATTRIBUTE_CHAR271

EXTN_ATTRIBUTE_CHAR272

EXTN_ATTRIBUTE_CHAR273

EXTN_ATTRIBUTE_CHAR274

EXTN_ATTRIBUTE_CHAR275

EXTN_ATTRIBUTE_CHAR276

EXTN_ATTRIBUTE_CHAR277

EXTN_ATTRIBUTE_CHAR278

EXTN_ATTRIBUTE_CHAR279

EXTN_ATTRIBUTE_CHAR280

EXTN_ATTRIBUTE_CLOB019

EXTN_ATTRIBUTE_CLOB020

EXTN_ATTRIBUTE_NUMBER161

EXTN_ATTRIBUTE_NUMBER162

EXTN_ATTRIBUTE_NUMBER163

EXTN_ATTRIBUTE_NUMBER164

EXTN_ATTRIBUTE_NUMBER165

EXTN_ATTRIBUTE_NUMBER166

EXTN_ATTRIBUTE_NUMBER167

EXTN_ATTRIBUTE_NUMBER168

EXTN_ATTRIBUTE_CHAR281

EXTN_ATTRIBUTE_CHAR282

EXTN_ATTRIBUTE_CHAR283

EXTN_ATTRIBUTE_CHAR284

EXTN_ATTRIBUTE_CHAR285

EXTN_ATTRIBUTE_CHAR286

EXTN_ATTRIBUTE_CHAR287

EXTN_ATTRIBUTE_CHAR288

EXTN_ATTRIBUTE_CHAR289

EXTN_ATTRIBUTE_CHAR290

EXTN_ATTRIBUTE_CHAR291

EXTN_ATTRIBUTE_CHAR292

EXTN_ATTRIBUTE_CHAR293

EXTN_ATTRIBUTE_CHAR294

EXTN_ATTRIBUTE_NUMBER169

EXTN_ATTRIBUTE_NUMBER170

EXTN_ATTRIBUTE_NUMBER171

EXTN_ATTRIBUTE_NUMBER172

EXTN_ATTRIBUTE_NUMBER173

EXTN_ATTRIBUTE_NUMBER174

EXTN_ATTRIBUTE_NUMBER175

EXTN_ATTRIBUTE_NUMBER176

EXTN_ATTRIBUTE_CHAR295

EXTN_ATTRIBUTE_CHAR296

EXTN_ATTRIBUTE_CHAR297

EXTN_ATTRIBUTE_CHAR298

EXTN_ATTRIBUTE_CHAR299

EXTN_ATTRIBUTE_CHAR300

EXTN_ATTRIBUTE_CHAR301

EXTN_ATTRIBUTE_CHAR302

EXTN_ATTRIBUTE_CHAR303

EXTN_ATTRIBUTE_CHAR304

EXTN_ATTRIBUTE_CHAR305

EXTN_ATTRIBUTE_CHAR306

EXTN_ATTRIBUTE_CHAR307

EXTN_ATTRIBUTE_CHAR308

EXTN_ATTRIBUTE_CLOB021

EXTN_ATTRIBUTE_CLOB022

EXTN_ATTRIBUTE_NUMBER177

EXTN_ATTRIBUTE_NUMBER178

EXTN_ATTRIBUTE_NUMBER179

EXTN_ATTRIBUTE_NUMBER180

EXTN_ATTRIBUTE_NUMBER181

EXTN_ATTRIBUTE_NUMBER182

EXTN_ATTRIBUTE_NUMBER183

EXTN_ATTRIBUTE_NUMBER184

EXTN_ATTRIBUTE_CHAR309

EXTN_ATTRIBUTE_CHAR310

EXTN_ATTRIBUTE_CHAR311

EXTN_ATTRIBUTE_CHAR312

EXTN_ATTRIBUTE_CHAR313

EXTN_ATTRIBUTE_CHAR314

EXTN_ATTRIBUTE_CHAR315

EXTN_ATTRIBUTE_CHAR316

EXTN_ATTRIBUTE_CHAR317

EXTN_ATTRIBUTE_CHAR318

EXTN_ATTRIBUTE_CHAR319

EXTN_ATTRIBUTE_CHAR320

EXTN_ATTRIBUTE_CHAR321

EXTN_ATTRIBUTE_CHAR322

EXTN_ATTRIBUTE_NUMBER185

EXTN_ATTRIBUTE_NUMBER186

EXTN_ATTRIBUTE_NUMBER187

EXTN_ATTRIBUTE_NUMBER188

EXTN_ATTRIBUTE_NUMBER189

EXTN_ATTRIBUTE_NUMBER190

EXTN_ATTRIBUTE_NUMBER191

EXTN_ATTRIBUTE_NUMBER192

EXTN_ATTRIBUTE_CHAR323

EXTN_ATTRIBUTE_CHAR324

EXTN_ATTRIBUTE_CHAR325

EXTN_ATTRIBUTE_CHAR326

EXTN_ATTRIBUTE_CHAR327

EXTN_ATTRIBUTE_CHAR328

EXTN_ATTRIBUTE_CHAR329

EXTN_ATTRIBUTE_CHAR330

EXTN_ATTRIBUTE_CHAR331

EXTN_ATTRIBUTE_CHAR332

EXTN_ATTRIBUTE_CHAR333

EXTN_ATTRIBUTE_CHAR334

EXTN_ATTRIBUTE_CHAR335

EXTN_ATTRIBUTE_CHAR336

EXTN_ATTRIBUTE_CLOB023

EXTN_ATTRIBUTE_CLOB024

EXTN_ATTRIBUTE_NUMBER193

EXTN_ATTRIBUTE_NUMBER194

EXTN_ATTRIBUTE_NUMBER195

EXTN_ATTRIBUTE_NUMBER196

EXTN_ATTRIBUTE_NUMBER197

EXTN_ATTRIBUTE_NUMBER198

EXTN_ATTRIBUTE_NUMBER199

EXTN_ATTRIBUTE_NUMBER200

EXTN_ATTRIBUTE_CHAR337

EXTN_ATTRIBUTE_CHAR338

EXTN_ATTRIBUTE_CHAR339

EXTN_ATTRIBUTE_CHAR340

EXTN_ATTRIBUTE_CHAR341

EXTN_ATTRIBUTE_CHAR342

EXTN_ATTRIBUTE_CHAR343

EXTN_ATTRIBUTE_CHAR344

EXTN_ATTRIBUTE_CHAR345

EXTN_ATTRIBUTE_CHAR346

EXTN_ATTRIBUTE_CHAR347

EXTN_ATTRIBUTE_CHAR348

EXTN_ATTRIBUTE_CHAR349

EXTN_ATTRIBUTE_CHAR350

EXTN_ATTRIBUTE_CLOB025

Query

SQL_Statement

SELECT

B.ID,

B.LINE_PUID,

B.MAJOR_VERSION,

B.VERSION_TYPE,

B.LINE_NUMBER,

B.CHR_ID,

B.CLE_ID,

B.DNZ_CHR_ID,

B.LINE_TYPE_ID,

B.START_DATE,

B.END_DATE,

B.OBJECT1_ID1,

B.OBJECT1_ID2,

B.JTOT_OBJECT1_CODE,

B.DISPLAY_SEQUENCE,

B.STS_CODE,

B.UOM_CODE,

B.NUM_OF_ITEM,

B.CURRENCY_CODE,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.PRICE_UNIT,

B.LINE_AMOUNT,

B.TAX_AMOUNT,

B.CANCELLED_AMOUNT,

B.DATE_CANCELLED,

B.DATE_TERMINATED,

B.TRN_CODE,

B.TERM_CANCEL_SOURCE,

B.UNBILLED_TERMINATED_AMONT,

B.CREDITED_AMOUNT,

B.SUPPRESSED_AMOUNT,

B.OVERRIDEN_AMOUNT,

B.ORDER_NUMBER,

B.ORDER_ID,

B.ORDER_LINE_NUMBER,

B.ORDER_LINE_ID,

B.CUSTOMER_ITEM_ID,

B.CUSTOMER_ITEM_NUMBER,

B.NSP_FLAG,

B.UNDEF_UNIT_PRICE,

B.UNDEF_LINE_VALUE,

B.UNDEF_LINE_TOTAL,

B.DELIVERY_DATE,

B.BILLABLE_FLAG,

B.BILL_PLAN_ID,

B.REVENUE_PLAN_ID,

B.SHIP_TO_ACCT_ID,

B.BILL_TO_ACCT_ID,

B.SHIP_TO_SITE_USE_ID,

B.BILL_TO_SITE_USE_ID,

B.SUPPLIER_ID,

B.SUPPLIER_SITE_ID,

B.SHIP_INV_ORG_ID,

B.RECV_INV_ORG_ID,

B.TAX_EXEMPTION_CONTROL,

B.EXEMPT_CERTIFICATE_NUMBER,

B.EXEMPT_REASON_CODE,

B.OUTPUT_TAX_CLASSIFICATION_CODE,

B.ORIG_SYSTEM_SOURCE_CODE,

B.ORIG_SYSTEM_ID1,

B.ORIG_SYSTEM_REFERENCE1,

B.ATTRIBUTE_CATEGORY,

B.ATTRIBUTE1,

B.ATTRIBUTE2,

B.ATTRIBUTE3,

B.ATTRIBUTE4,

B.ATTRIBUTE5,

B.ATTRIBUTE6,

B.ATTRIBUTE7,

B.ATTRIBUTE8,

B.ATTRIBUTE9,

B.ATTRIBUTE10,

B.ATTRIBUTE11,

B.ATTRIBUTE12,

B.ATTRIBUTE13,

B.ATTRIBUTE14,

B.ATTRIBUTE15,

B.ATTRIBUTE16,

B.ATTRIBUTE17,

B.ATTRIBUTE18,

B.ATTRIBUTE19,

B.ATTRIBUTE20,

B.ATTRIBUTE21,

B.ATTRIBUTE22,

B.ATTRIBUTE23,

B.ATTRIBUTE24,

B.ATTRIBUTE25,

B.ATTRIBUTE26,

B.ATTRIBUTE27,

B.ATTRIBUTE28,

B.ATTRIBUTE29,

B.ATTRIBUTE30,

B.ATTRIBUTE_NUMBER1,

B.ATTRIBUTE_NUMBER2,

B.ATTRIBUTE_NUMBER3,

B.ATTRIBUTE_NUMBER4,

B.ATTRIBUTE_NUMBER5,

B.ATTRIBUTE_NUMBER6,

B.ATTRIBUTE_NUMBER7,

B.ATTRIBUTE_NUMBER8,

B.ATTRIBUTE_NUMBER9,

B.ATTRIBUTE_NUMBER10,

B.ATTRIBUTE_DATE1,

B.ATTRIBUTE_DATE2,

B.ATTRIBUTE_DATE3,

B.ATTRIBUTE_DATE4,

B.ATTRIBUTE_DATE5,

B.ATTRIBUTE_DATE6,

B.ATTRIBUTE_DATE7,

B.ATTRIBUTE_DATE8,

B.ATTRIBUTE_DATE9,

B.ATTRIBUTE_DATE10,

B.LAST_REV_RECOG_DATE,

B.REVENUE_RECOG_AMT,

B.BUDGET_GROSS_MARGIN,

B.REVENUE_IMPACT_DATE,

B.REQUEST_ID,

B.PROGRAM_NAME,

B.PROGRAM_APP_NAME,

B.SOURCE_CODE_CLASS,

B.PERCENT_COMPLETE,

B.AT_RISK_YN,

B.LINE_VALUE,

B.HOLD_UNTIL_DATE,

B.HOLD_REASON_CODE,

TL.ITEM_DESCRIPTION AS LINE_DESCRIPTION,

TL.ITEM_NAME AS LINE_NAME,

TL.LINE_REFERENCE,

TL.COGNOMEN,

TL.COMMENTS,

TL.ITEM_NAME,

TL.ITEM_DESCRIPTION,

TL.VERSION_TYPE VERSION_TYPE_TL,

B.PAYMENT_TERMS_ID,

B.FREIGHT_TERMS_CODE,

B.FOB_CODE,

B.PURCHASING_CATEGORY_ID,

B.RECV_LOCATION_ID,

B.CARRIER_ID,

B.FIXED_PRICE_SERVICE_YN,

B.AGREEMENT_UNIT_PRICE,

B.AGREEMENT_PRICE_OVER_ALLWD_YN,

B.AGREEMENT_PRICE_LIMIT,

B.AGREEMENT_QTY_LIMIT,

B.AGREEMENT_AMT_LIMIT,

B.AGREED_QTY,

B.AGREED_AMT,

B.MIN_RELEASE_QTY,

B.MIN_RELEASE_AMT,

B.LINE_HIERARCHY_NUMBER,

B.EXTERNAL_KEY1,

B.EXTERNAL_KEY2,

B.CUST_PO_NUMBER,

B.PRICE_LIST_ID,

B.ALLOW_PRICELIST_OVERRIDE_YN,

B.COMMIT_LEVEL_CODE,

B.EXTERNAL_ITEM_SOURCE,

B.EXTERNAL_ITEM_KEY,

B.EXTERNAL_ITEM_REFERENCE1,

B.EXTERNAL_ITEM_REFERENCE2,

B.EXTERNAL_ITEM_REFERENCE3,

B.EXTERNAL_ITEM_REFERENCE4,

B.EXTERNAL_ITEM_REFERENCE5,

B.FULFILLED_QTY,

B.FULFILLED_AMT,

B.HOLD_REASON_CODE_SET_ID,

B.TRN_CODE_SET_ID,

B.ALLOW_PROMOTIONS_YN,

B.SOURCE_SYSTEM_ATTRIBUTES,

B.INVOICE_RULE_ID,

B.EXTERNAL_SEARCH_KEY1,

B.EXTERNAL_SEARCH_KEY2,

B.SHIP_TO_PARTY_ID,

B.SHIP_TO_PARTY_SITE_ID,

TL.LANGUAGE,

TL.SOURCE_LANG,

B.PRICE_UOM,

B.ACCT_RULE_ID,

B.BILLING_FREQ,

B.ORDER_SOURCE,

B.INVOICE_TEXT,

B.PRICING_ERROR,

B.LINE_SUB_TOTAL,

B.TRX_BUSINESS_CATEGORY,

B.PRODUCT_TYPE,

B.PRODUCT_FISC_CLASSIFICATION,

B.BILLING_FREQ_USED,

B.INVOICE_RULE_ID_USED,

B.RETURN_CREDIT_METHOD_CODE,

B.TERMINATED_AMOUNT,

B.INVOICED_AMOUNT,

B.SUPPRESSED_CREDIT_AMOUNT,

B.ONETIME_AMOUNT,

B.RECURRING_AMOUNT,

B.DATE_RENEWED,

B.TAX_ERROR,

B.PAYMENT_METHOD,

B.PO_NUMBER,

B.WIRE_NUMBER,

B.TRXN_EXTENSION_ID,

B.INSTR_ASSIGNMENT_ID,

B.RENEWAL_TYPE,

B.PRICE_DURING_BILLING_YN,

B.BILLING_DATE_METHOD,

B.SPECIFIC_DAYS,

B.USG_BILLED_AMOUNT,

B.USG_CREDITED_AMOUNT,

B.USG_SUPPRESSED_CREDIT_AMT,

B.PRICE_AS_OF,

B.COVERAGE_SCHEDULE_ID,

B.TRANSACTION_TYPE_NAME,

B.PAYMENT_SET_ID,

B.EST_VAR_CONSIDERATION_AMT,

B.STANDALONE_SELLING_PRICE,

B.PRICE_APPLICATION_RULE,

B.AUTO_APPLY_STRTGY_PRICE_ADJ,

B.LINE_ID,

B.SOURCE_DOC_SYSTEM_CODE,

B.SOURCE_DOC_ID,

B.SOURCE_DOC_LINE_ID,

B.EXTN_ATTRIBUTE_TIMESTAMP001,

B.EXTN_ATTRIBUTE_TIMESTAMP002,

B.EXTN_ATTRIBUTE_TIMESTAMP003,

B.EXTN_ATTRIBUTE_NUMBER001,

B.EXTN_ATTRIBUTE_NUMBER002,

B.EXTN_ATTRIBUTE_NUMBER003,

B.EXTN_ATTRIBUTE_NUMBER004,

B.EXTN_ATTRIBUTE_NUMBER005,

B.EXTN_ATTRIBUTE_NUMBER006,

B.EXTN_ATTRIBUTE_NUMBER007,

B.EXTN_ATTRIBUTE_NUMBER008,

B.EXTN_ATTRIBUTE_CHAR001,

B.EXTN_ATTRIBUTE_CHAR002,

B.EXTN_ATTRIBUTE_CHAR003,

B.EXTN_ATTRIBUTE_CHAR004,

B.EXTN_ATTRIBUTE_CHAR005,

B.EXTN_ATTRIBUTE_CHAR006,

B.EXTN_ATTRIBUTE_CHAR007,

B.EXTN_ATTRIBUTE_CHAR008,

B.EXTN_ATTRIBUTE_CHAR009,

B.EXTN_ATTRIBUTE_CHAR010,

B.EXTN_ATTRIBUTE_CHAR011,

B.EXTN_ATTRIBUTE_CHAR012,

B.EXTN_ATTRIBUTE_CHAR013,

B.EXTN_ATTRIBUTE_CHAR014,

B.EXTN_ATTRIBUTE_TIMESTAMP004,

B.EXTN_ATTRIBUTE_TIMESTAMP005,

B.EXTN_ATTRIBUTE_TIMESTAMP006,

B.EXTN_ATTRIBUTE_NUMBER009,

B.EXTN_ATTRIBUTE_NUMBER010,

B.EXTN_ATTRIBUTE_NUMBER011,

B.EXTN_ATTRIBUTE_NUMBER012,

B.EXTN_ATTRIBUTE_NUMBER013,

B.EXTN_ATTRIBUTE_NUMBER014,

B.EXTN_ATTRIBUTE_NUMBER015,

B.EXTN_ATTRIBUTE_NUMBER016,

B.EXTN_ATTRIBUTE_CHAR015,

B.EXTN_ATTRIBUTE_CHAR016,

B.EXTN_ATTRIBUTE_CHAR017,

B.EXTN_ATTRIBUTE_CHAR018,

B.EXTN_ATTRIBUTE_CHAR019,

B.EXTN_ATTRIBUTE_CHAR020,

B.EXTN_ATTRIBUTE_CHAR021,

B.EXTN_ATTRIBUTE_CHAR022,

B.EXTN_ATTRIBUTE_CHAR023,

B.EXTN_ATTRIBUTE_CHAR024,

B.EXTN_ATTRIBUTE_CHAR025,

B.EXTN_ATTRIBUTE_CHAR026,

B.EXTN_ATTRIBUTE_CHAR027,

B.EXTN_ATTRIBUTE_CHAR028,

B.EXTN_ATTRIBUTE_CLOB001,

B.EXTN_ATTRIBUTE_CLOB002,

B.EXTN_ATTRIBUTE_TIMESTAMP007,

B.EXTN_ATTRIBUTE_TIMESTAMP008,

B.EXTN_ATTRIBUTE_TIMESTAMP009,

B.EXTN_ATTRIBUTE_NUMBER017,

B.EXTN_ATTRIBUTE_NUMBER018,

B.EXTN_ATTRIBUTE_NUMBER019,

B.EXTN_ATTRIBUTE_NUMBER020,

B.EXTN_ATTRIBUTE_NUMBER021,

B.EXTN_ATTRIBUTE_NUMBER022,

B.EXTN_ATTRIBUTE_NUMBER023,

B.EXTN_ATTRIBUTE_NUMBER024,

B.EXTN_ATTRIBUTE_CHAR029,

B.EXTN_ATTRIBUTE_CHAR030,

B.EXTN_ATTRIBUTE_CHAR031,

B.EXTN_ATTRIBUTE_CHAR032,

B.EXTN_ATTRIBUTE_CHAR033,

B.EXTN_ATTRIBUTE_CHAR034,

B.EXTN_ATTRIBUTE_CHAR035,

B.EXTN_ATTRIBUTE_CHAR036,

B.EXTN_ATTRIBUTE_CHAR037,

B.EXTN_ATTRIBUTE_CHAR038,

B.EXTN_ATTRIBUTE_CHAR039,

B.EXTN_ATTRIBUTE_CHAR040,

B.EXTN_ATTRIBUTE_CHAR041,

B.EXTN_ATTRIBUTE_CHAR042,

B.EXTN_ATTRIBUTE_TIMESTAMP010,

B.EXTN_ATTRIBUTE_TIMESTAMP011,

B.EXTN_ATTRIBUTE_TIMESTAMP012,

B.EXTN_ATTRIBUTE_NUMBER025,

B.EXTN_ATTRIBUTE_NUMBER026,

B.EXTN_ATTRIBUTE_NUMBER027,

B.EXTN_ATTRIBUTE_NUMBER028,

B.EXTN_ATTRIBUTE_NUMBER029,

B.EXTN_ATTRIBUTE_NUMBER030,

B.EXTN_ATTRIBUTE_NUMBER031,

B.EXTN_ATTRIBUTE_NUMBER032,

B.EXTN_ATTRIBUTE_CHAR043,

B.EXTN_ATTRIBUTE_CHAR044,

B.EXTN_ATTRIBUTE_CHAR045,

B.EXTN_ATTRIBUTE_CHAR046,

B.EXTN_ATTRIBUTE_CHAR047,

B.EXTN_ATTRIBUTE_CHAR048,

B.EXTN_ATTRIBUTE_CHAR049,

B.EXTN_ATTRIBUTE_CHAR050,

B.EXTN_ATTRIBUTE_CHAR051,

B.EXTN_ATTRIBUTE_CHAR052,

B.EXTN_ATTRIBUTE_CHAR053,

B.EXTN_ATTRIBUTE_CHAR054,

B.EXTN_ATTRIBUTE_CHAR055,

B.EXTN_ATTRIBUTE_CHAR056,

B.EXTN_ATTRIBUTE_CLOB003,

B.EXTN_ATTRIBUTE_CLOB004,

B.EXTN_ATTRIBUTE_TIMESTAMP013,

B.EXTN_ATTRIBUTE_TIMESTAMP014,

B.EXTN_ATTRIBUTE_TIMESTAMP015,

B.EXTN_ATTRIBUTE_NUMBER033,

B.EXTN_ATTRIBUTE_NUMBER034,

B.EXTN_ATTRIBUTE_NUMBER035,

B.EXTN_ATTRIBUTE_NUMBER036,

B.EXTN_ATTRIBUTE_NUMBER037,

B.EXTN_ATTRIBUTE_NUMBER038,

B.EXTN_ATTRIBUTE_NUMBER039,

B.EXTN_ATTRIBUTE_NUMBER040,

B.EXTN_ATTRIBUTE_CHAR057,

B.EXTN_ATTRIBUTE_CHAR058,

B.EXTN_ATTRIBUTE_CHAR059,

B.EXTN_ATTRIBUTE_CHAR060,

B.EXTN_ATTRIBUTE_CHAR061,

B.EXTN_ATTRIBUTE_CHAR062,

B.EXTN_ATTRIBUTE_CHAR063,

B.EXTN_ATTRIBUTE_CHAR064,

B.EXTN_ATTRIBUTE_CHAR065,

B.EXTN_ATTRIBUTE_CHAR066,

B.EXTN_ATTRIBUTE_CHAR067,

B.EXTN_ATTRIBUTE_CHAR068,

B.EXTN_ATTRIBUTE_CHAR069,

B.EXTN_ATTRIBUTE_CHAR070,

B.EXTN_ATTRIBUTE_TIMESTAMP016,

B.EXTN_ATTRIBUTE_TIMESTAMP017,

B.EXTN_ATTRIBUTE_TIMESTAMP018,

B.EXTN_ATTRIBUTE_NUMBER041,

B.EXTN_ATTRIBUTE_NUMBER042,

B.EXTN_ATTRIBUTE_NUMBER043,

B.EXTN_ATTRIBUTE_NUMBER044,

B.EXTN_ATTRIBUTE_NUMBER045,

B.EXTN_ATTRIBUTE_NUMBER046,

B.EXTN_ATTRIBUTE_NUMBER047,

B.EXTN_ATTRIBUTE_NUMBER048,

B.EXTN_ATTRIBUTE_CHAR071,

B.EXTN_ATTRIBUTE_CHAR072,

B.EXTN_ATTRIBUTE_CHAR073,

B.EXTN_ATTRIBUTE_CHAR074,

B.EXTN_ATTRIBUTE_CHAR075,

B.EXTN_ATTRIBUTE_CHAR076,

B.EXTN_ATTRIBUTE_CHAR077,

B.EXTN_ATTRIBUTE_CHAR078,

B.EXTN_ATTRIBUTE_CHAR079,

B.EXTN_ATTRIBUTE_CHAR080,

B.EXTN_ATTRIBUTE_CHAR081,

B.EXTN_ATTRIBUTE_CHAR082,

B.EXTN_ATTRIBUTE_CHAR083,

B.EXTN_ATTRIBUTE_CHAR084,

B.EXTN_ATTRIBUTE_CLOB005,

B.EXTN_ATTRIBUTE_CLOB006,

B.EXTN_ATTRIBUTE_TIMESTAMP019,

B.EXTN_ATTRIBUTE_TIMESTAMP020,

B.EXTN_ATTRIBUTE_TIMESTAMP021,

B.EXTN_ATTRIBUTE_NUMBER049,

B.EXTN_ATTRIBUTE_NUMBER050,

B.EXTN_ATTRIBUTE_NUMBER051,

B.EXTN_ATTRIBUTE_NUMBER052,

B.EXTN_ATTRIBUTE_NUMBER053,

B.EXTN_ATTRIBUTE_NUMBER054,

B.EXTN_ATTRIBUTE_NUMBER055,

B.EXTN_ATTRIBUTE_NUMBER056,

B.EXTN_ATTRIBUTE_CHAR085,

B.EXTN_ATTRIBUTE_CHAR086,

B.EXTN_ATTRIBUTE_CHAR087,

B.EXTN_ATTRIBUTE_CHAR088,

B.EXTN_ATTRIBUTE_CHAR089,

B.EXTN_ATTRIBUTE_CHAR090,

B.EXTN_ATTRIBUTE_CHAR091,

B.EXTN_ATTRIBUTE_CHAR092,

B.EXTN_ATTRIBUTE_CHAR093,

B.EXTN_ATTRIBUTE_CHAR094,

B.EXTN_ATTRIBUTE_CHAR095,

B.EXTN_ATTRIBUTE_CHAR096,

B.EXTN_ATTRIBUTE_CHAR097,

B.EXTN_ATTRIBUTE_CHAR098,

B.EXTN_ATTRIBUTE_TIMESTAMP022,

B.EXTN_ATTRIBUTE_TIMESTAMP023,

B.EXTN_ATTRIBUTE_TIMESTAMP024,

B.EXTN_ATTRIBUTE_NUMBER057,

B.EXTN_ATTRIBUTE_NUMBER058,

B.EXTN_ATTRIBUTE_NUMBER059,

B.EXTN_ATTRIBUTE_NUMBER060,

B.EXTN_ATTRIBUTE_NUMBER061,

B.EXTN_ATTRIBUTE_NUMBER062,

B.EXTN_ATTRIBUTE_NUMBER063,

B.EXTN_ATTRIBUTE_NUMBER064,

B.EXTN_ATTRIBUTE_CHAR099,

B.EXTN_ATTRIBUTE_CHAR100,

B.EXTN_ATTRIBUTE_CHAR101,

B.EXTN_ATTRIBUTE_CHAR102,

B.EXTN_ATTRIBUTE_CHAR103,

B.EXTN_ATTRIBUTE_CHAR104,

B.EXTN_ATTRIBUTE_CHAR105,

B.EXTN_ATTRIBUTE_CHAR106,

B.EXTN_ATTRIBUTE_CHAR107,

B.EXTN_ATTRIBUTE_CHAR108,

B.EXTN_ATTRIBUTE_CHAR109,

B.EXTN_ATTRIBUTE_CHAR110,

B.EXTN_ATTRIBUTE_CHAR111,

B.EXTN_ATTRIBUTE_CHAR112,

B.EXTN_ATTRIBUTE_CLOB007,

B.EXTN_ATTRIBUTE_CLOB008,

B.EXTN_ATTRIBUTE_TIMESTAMP025,

B.EXTN_ATTRIBUTE_TIMESTAMP026,

B.EXTN_ATTRIBUTE_TIMESTAMP027,

B.EXTN_ATTRIBUTE_NUMBER065,

B.EXTN_ATTRIBUTE_NUMBER066,

B.EXTN_ATTRIBUTE_NUMBER067,

B.EXTN_ATTRIBUTE_NUMBER068,

B.EXTN_ATTRIBUTE_NUMBER069,

B.EXTN_ATTRIBUTE_NUMBER070,

B.EXTN_ATTRIBUTE_NUMBER071,

B.EXTN_ATTRIBUTE_NUMBER072,

B.EXTN_ATTRIBUTE_CHAR113,

B.EXTN_ATTRIBUTE_CHAR114,

B.EXTN_ATTRIBUTE_CHAR115,

B.EXTN_ATTRIBUTE_CHAR116,

B.EXTN_ATTRIBUTE_CHAR117,

B.EXTN_ATTRIBUTE_CHAR118,

B.EXTN_ATTRIBUTE_CHAR119,

B.EXTN_ATTRIBUTE_CHAR120,

B.EXTN_ATTRIBUTE_CHAR121,

B.EXTN_ATTRIBUTE_CHAR122,

B.EXTN_ATTRIBUTE_CHAR123,

B.EXTN_ATTRIBUTE_CHAR124,

B.EXTN_ATTRIBUTE_CHAR125,

B.EXTN_ATTRIBUTE_CHAR126,

B.EXTN_ATTRIBUTE_TIMESTAMP028,

B.EXTN_ATTRIBUTE_TIMESTAMP029,

B.EXTN_ATTRIBUTE_TIMESTAMP030,

B.EXTN_ATTRIBUTE_NUMBER073,

B.EXTN_ATTRIBUTE_NUMBER074,

B.EXTN_ATTRIBUTE_NUMBER075,

B.EXTN_ATTRIBUTE_NUMBER076,

B.EXTN_ATTRIBUTE_NUMBER077,

B.EXTN_ATTRIBUTE_NUMBER078,

B.EXTN_ATTRIBUTE_NUMBER079,

B.EXTN_ATTRIBUTE_NUMBER080,

B.EXTN_ATTRIBUTE_CHAR127,

B.EXTN_ATTRIBUTE_CHAR128,

B.EXTN_ATTRIBUTE_CHAR129,

B.EXTN_ATTRIBUTE_CHAR130,

B.EXTN_ATTRIBUTE_CHAR131,

B.EXTN_ATTRIBUTE_CHAR132,

B.EXTN_ATTRIBUTE_CHAR133,

B.EXTN_ATTRIBUTE_CHAR134,

B.EXTN_ATTRIBUTE_CHAR135,

B.EXTN_ATTRIBUTE_CHAR136,

B.EXTN_ATTRIBUTE_CHAR137,

B.EXTN_ATTRIBUTE_CHAR138,

B.EXTN_ATTRIBUTE_CHAR139,

B.EXTN_ATTRIBUTE_CHAR140,

B.EXTN_ATTRIBUTE_CLOB009,

B.EXTN_ATTRIBUTE_CLOB010,

B.EXTN_ATTRIBUTE_TIMESTAMP031,

B.EXTN_ATTRIBUTE_TIMESTAMP032,

B.EXTN_ATTRIBUTE_TIMESTAMP033,

B.EXTN_ATTRIBUTE_NUMBER081,

B.EXTN_ATTRIBUTE_NUMBER082,

B.EXTN_ATTRIBUTE_NUMBER083,

B.EXTN_ATTRIBUTE_NUMBER084,

B.EXTN_ATTRIBUTE_NUMBER085,

B.EXTN_ATTRIBUTE_NUMBER086,

B.EXTN_ATTRIBUTE_NUMBER087,

B.EXTN_ATTRIBUTE_NUMBER088,

B.EXTN_ATTRIBUTE_CHAR141,

B.EXTN_ATTRIBUTE_CHAR142,

B.EXTN_ATTRIBUTE_CHAR143,

B.EXTN_ATTRIBUTE_CHAR144,

B.EXTN_ATTRIBUTE_CHAR145,

B.EXTN_ATTRIBUTE_CHAR146,

B.EXTN_ATTRIBUTE_CHAR147,

B.EXTN_ATTRIBUTE_CHAR148,

B.EXTN_ATTRIBUTE_CHAR149,

B.EXTN_ATTRIBUTE_CHAR150,

B.EXTN_ATTRIBUTE_CHAR151,

B.EXTN_ATTRIBUTE_CHAR152,

B.EXTN_ATTRIBUTE_CHAR153,

B.EXTN_ATTRIBUTE_CHAR154,

B.EXTN_ATTRIBUTE_TIMESTAMP034,

B.EXTN_ATTRIBUTE_TIMESTAMP035,

B.EXTN_ATTRIBUTE_TIMESTAMP036,

B.EXTN_ATTRIBUTE_NUMBER089,

B.EXTN_ATTRIBUTE_NUMBER090,

B.EXTN_ATTRIBUTE_NUMBER091,

B.EXTN_ATTRIBUTE_NUMBER092,

B.EXTN_ATTRIBUTE_NUMBER093,

B.EXTN_ATTRIBUTE_NUMBER094,

B.EXTN_ATTRIBUTE_NUMBER095,

B.EXTN_ATTRIBUTE_NUMBER096,

B.EXTN_ATTRIBUTE_CHAR155,

B.EXTN_ATTRIBUTE_CHAR156,

B.EXTN_ATTRIBUTE_CHAR157,

B.EXTN_ATTRIBUTE_CHAR158,

B.EXTN_ATTRIBUTE_CHAR159,

B.EXTN_ATTRIBUTE_CHAR160,

B.EXTN_ATTRIBUTE_CHAR161,

B.EXTN_ATTRIBUTE_CHAR162,

B.EXTN_ATTRIBUTE_CHAR163,

B.EXTN_ATTRIBUTE_CHAR164,

B.EXTN_ATTRIBUTE_CHAR165,

B.EXTN_ATTRIBUTE_CHAR166,

B.EXTN_ATTRIBUTE_CHAR167,

B.EXTN_ATTRIBUTE_CHAR168,

B.EXTN_ATTRIBUTE_CLOB011,

B.EXTN_ATTRIBUTE_CLOB012,

B.EXTN_ATTRIBUTE_TIMESTAMP037,

B.EXTN_ATTRIBUTE_TIMESTAMP038,

B.EXTN_ATTRIBUTE_TIMESTAMP039,

B.EXTN_ATTRIBUTE_NUMBER097,

B.EXTN_ATTRIBUTE_NUMBER098,

B.EXTN_ATTRIBUTE_NUMBER099,

B.EXTN_ATTRIBUTE_NUMBER100,

B.EXTN_ATTRIBUTE_NUMBER101,

B.EXTN_ATTRIBUTE_NUMBER102,

B.EXTN_ATTRIBUTE_NUMBER103,

B.EXTN_ATTRIBUTE_NUMBER104,

B.EXTN_ATTRIBUTE_CHAR169,

B.EXTN_ATTRIBUTE_CHAR170,

B.EXTN_ATTRIBUTE_CHAR171,

B.EXTN_ATTRIBUTE_CHAR172,

B.EXTN_ATTRIBUTE_CHAR173,

B.EXTN_ATTRIBUTE_CHAR174,

B.EXTN_ATTRIBUTE_CHAR175,

B.EXTN_ATTRIBUTE_CHAR176,

B.EXTN_ATTRIBUTE_CHAR177,

B.EXTN_ATTRIBUTE_CHAR178,

B.EXTN_ATTRIBUTE_CHAR179,

B.EXTN_ATTRIBUTE_CHAR180,

B.EXTN_ATTRIBUTE_CHAR181,

B.EXTN_ATTRIBUTE_CHAR182,

B.EXTN_ATTRIBUTE_TIMESTAMP040,

B.EXTN_ATTRIBUTE_TIMESTAMP041,

B.EXTN_ATTRIBUTE_TIMESTAMP042,

B.EXTN_ATTRIBUTE_NUMBER105,

B.EXTN_ATTRIBUTE_NUMBER106,

B.EXTN_ATTRIBUTE_NUMBER107,

B.EXTN_ATTRIBUTE_NUMBER108,

B.EXTN_ATTRIBUTE_NUMBER109,

B.EXTN_ATTRIBUTE_NUMBER110,

B.EXTN_ATTRIBUTE_NUMBER111,

B.EXTN_ATTRIBUTE_NUMBER112,

B.EXTN_ATTRIBUTE_CHAR183,

B.EXTN_ATTRIBUTE_CHAR184,

B.EXTN_ATTRIBUTE_CHAR185,

B.EXTN_ATTRIBUTE_CHAR186,

B.EXTN_ATTRIBUTE_CHAR187,

B.EXTN_ATTRIBUTE_CHAR188,

B.EXTN_ATTRIBUTE_CHAR189,

B.EXTN_ATTRIBUTE_CHAR190,

B.EXTN_ATTRIBUTE_CHAR191,

B.EXTN_ATTRIBUTE_CHAR192,

B.EXTN_ATTRIBUTE_CHAR193,

B.EXTN_ATTRIBUTE_CHAR194,

B.EXTN_ATTRIBUTE_CHAR195,

B.EXTN_ATTRIBUTE_CHAR196,

B.EXTN_ATTRIBUTE_CLOB013,

B.EXTN_ATTRIBUTE_CLOB014,

B.EXTN_ATTRIBUTE_TIMESTAMP043,

B.EXTN_ATTRIBUTE_TIMESTAMP044,

B.EXTN_ATTRIBUTE_TIMESTAMP045,

B.EXTN_ATTRIBUTE_NUMBER113,

B.EXTN_ATTRIBUTE_NUMBER114,

B.EXTN_ATTRIBUTE_NUMBER115,

B.EXTN_ATTRIBUTE_NUMBER116,

B.EXTN_ATTRIBUTE_NUMBER117,

B.EXTN_ATTRIBUTE_NUMBER118,

B.EXTN_ATTRIBUTE_NUMBER119,

B.EXTN_ATTRIBUTE_NUMBER120,

B.EXTN_ATTRIBUTE_CHAR197,

B.EXTN_ATTRIBUTE_CHAR198,

B.EXTN_ATTRIBUTE_CHAR199,

B.EXTN_ATTRIBUTE_CHAR200,

B.EXTN_ATTRIBUTE_CHAR201,

B.EXTN_ATTRIBUTE_CHAR202,

B.EXTN_ATTRIBUTE_CHAR203,

B.EXTN_ATTRIBUTE_CHAR204,

B.EXTN_ATTRIBUTE_CHAR205,

B.EXTN_ATTRIBUTE_CHAR206,

B.EXTN_ATTRIBUTE_CHAR207,

B.EXTN_ATTRIBUTE_CHAR208,

B.EXTN_ATTRIBUTE_CHAR209,

B.EXTN_ATTRIBUTE_CHAR210,

B.EXTN_ATTRIBUTE_TIMESTAMP046,

B.EXTN_ATTRIBUTE_TIMESTAMP047,

B.EXTN_ATTRIBUTE_TIMESTAMP048,

B.EXTN_ATTRIBUTE_NUMBER121,

B.EXTN_ATTRIBUTE_NUMBER122,

B.EXTN_ATTRIBUTE_NUMBER123,

B.EXTN_ATTRIBUTE_NUMBER124,

B.EXTN_ATTRIBUTE_NUMBER125,

B.EXTN_ATTRIBUTE_NUMBER126,

B.EXTN_ATTRIBUTE_NUMBER127,

B.EXTN_ATTRIBUTE_NUMBER128,

B.EXTN_ATTRIBUTE_CHAR211,

B.EXTN_ATTRIBUTE_CHAR212,

B.EXTN_ATTRIBUTE_CHAR213,

B.EXTN_ATTRIBUTE_CHAR214,

B.EXTN_ATTRIBUTE_CHAR215,

B.EXTN_ATTRIBUTE_CHAR216,

B.EXTN_ATTRIBUTE_CHAR217,

B.EXTN_ATTRIBUTE_CHAR218,

B.EXTN_ATTRIBUTE_CHAR219,

B.EXTN_ATTRIBUTE_CHAR220,

B.EXTN_ATTRIBUTE_CHAR221,

B.EXTN_ATTRIBUTE_CHAR222,

B.EXTN_ATTRIBUTE_CHAR223,

B.EXTN_ATTRIBUTE_CHAR224,

B.EXTN_ATTRIBUTE_CLOB015,

B.EXTN_ATTRIBUTE_CLOB016,

B.EXTN_ATTRIBUTE_TIMESTAMP049,

B.EXTN_ATTRIBUTE_TIMESTAMP050,

B.EXTN_ATTRIBUTE_NUMBER129,

B.EXTN_ATTRIBUTE_NUMBER130,

B.EXTN_ATTRIBUTE_NUMBER131,

B.EXTN_ATTRIBUTE_NUMBER132,

B.EXTN_ATTRIBUTE_NUMBER133,

B.EXTN_ATTRIBUTE_NUMBER134,

B.EXTN_ATTRIBUTE_NUMBER135,

B.EXTN_ATTRIBUTE_NUMBER136,

B.EXTN_ATTRIBUTE_CHAR225,

B.EXTN_ATTRIBUTE_CHAR226,

B.EXTN_ATTRIBUTE_CHAR227,

B.EXTN_ATTRIBUTE_CHAR228,

B.EXTN_ATTRIBUTE_CHAR229,

B.EXTN_ATTRIBUTE_CHAR230,

B.EXTN_ATTRIBUTE_CHAR231,

B.EXTN_ATTRIBUTE_CHAR232,

B.EXTN_ATTRIBUTE_CHAR233,

B.EXTN_ATTRIBUTE_CHAR234,

B.EXTN_ATTRIBUTE_CHAR235,

B.EXTN_ATTRIBUTE_CHAR236,

B.EXTN_ATTRIBUTE_CHAR237,

B.EXTN_ATTRIBUTE_CHAR238,

B.EXTN_ATTRIBUTE_NUMBER137,

B.EXTN_ATTRIBUTE_NUMBER138,

B.EXTN_ATTRIBUTE_NUMBER139,

B.EXTN_ATTRIBUTE_NUMBER140,

B.EXTN_ATTRIBUTE_NUMBER141,

B.EXTN_ATTRIBUTE_NUMBER142,

B.EXTN_ATTRIBUTE_NUMBER143,

B.EXTN_ATTRIBUTE_NUMBER144,

B.EXTN_ATTRIBUTE_CHAR239,

B.EXTN_ATTRIBUTE_CHAR240,

B.EXTN_ATTRIBUTE_CHAR241,

B.EXTN_ATTRIBUTE_CHAR242,

B.EXTN_ATTRIBUTE_CHAR243,

B.EXTN_ATTRIBUTE_CHAR244,

B.EXTN_ATTRIBUTE_CHAR245,

B.EXTN_ATTRIBUTE_CHAR246,

B.EXTN_ATTRIBUTE_CHAR247,

B.EXTN_ATTRIBUTE_CHAR248,

B.EXTN_ATTRIBUTE_CHAR249,

B.EXTN_ATTRIBUTE_CHAR250,

B.EXTN_ATTRIBUTE_CHAR251,

B.EXTN_ATTRIBUTE_CHAR252,

B.EXTN_ATTRIBUTE_CLOB017,

B.EXTN_ATTRIBUTE_CLOB018,

B.EXTN_ATTRIBUTE_NUMBER145,

B.EXTN_ATTRIBUTE_NUMBER146,

B.EXTN_ATTRIBUTE_NUMBER147,

B.EXTN_ATTRIBUTE_NUMBER148,

B.EXTN_ATTRIBUTE_NUMBER149,

B.EXTN_ATTRIBUTE_NUMBER150,

B.EXTN_ATTRIBUTE_NUMBER151,

B.EXTN_ATTRIBUTE_NUMBER152,

B.EXTN_ATTRIBUTE_CHAR253,

B.EXTN_ATTRIBUTE_CHAR254,

B.EXTN_ATTRIBUTE_CHAR255,

B.EXTN_ATTRIBUTE_CHAR256,

B.EXTN_ATTRIBUTE_CHAR257,

B.EXTN_ATTRIBUTE_CHAR258,

B.EXTN_ATTRIBUTE_CHAR259,

B.EXTN_ATTRIBUTE_CHAR260,

B.EXTN_ATTRIBUTE_CHAR261,

B.EXTN_ATTRIBUTE_CHAR262,

B.EXTN_ATTRIBUTE_CHAR263,

B.EXTN_ATTRIBUTE_CHAR264,

B.EXTN_ATTRIBUTE_CHAR265,

B.EXTN_ATTRIBUTE_CHAR266,

B.EXTN_ATTRIBUTE_NUMBER153,

B.EXTN_ATTRIBUTE_NUMBER154,

B.EXTN_ATTRIBUTE_NUMBER155,

B.EXTN_ATTRIBUTE_NUMBER156,

B.EXTN_ATTRIBUTE_NUMBER157,

B.EXTN_ATTRIBUTE_NUMBER158,

B.EXTN_ATTRIBUTE_NUMBER159,

B.EXTN_ATTRIBUTE_NUMBER160,

B.EXTN_ATTRIBUTE_CHAR267,

B.EXTN_ATTRIBUTE_CHAR268,

B.EXTN_ATTRIBUTE_CHAR269,

B.EXTN_ATTRIBUTE_CHAR270,

B.EXTN_ATTRIBUTE_CHAR271,

B.EXTN_ATTRIBUTE_CHAR272,

B.EXTN_ATTRIBUTE_CHAR273,

B.EXTN_ATTRIBUTE_CHAR274,

B.EXTN_ATTRIBUTE_CHAR275,

B.EXTN_ATTRIBUTE_CHAR276,

B.EXTN_ATTRIBUTE_CHAR277,

B.EXTN_ATTRIBUTE_CHAR278,

B.EXTN_ATTRIBUTE_CHAR279,

B.EXTN_ATTRIBUTE_CHAR280,

B.EXTN_ATTRIBUTE_CLOB019,

B.EXTN_ATTRIBUTE_CLOB020,

B.EXTN_ATTRIBUTE_NUMBER161,

B.EXTN_ATTRIBUTE_NUMBER162,

B.EXTN_ATTRIBUTE_NUMBER163,

B.EXTN_ATTRIBUTE_NUMBER164,

B.EXTN_ATTRIBUTE_NUMBER165,

B.EXTN_ATTRIBUTE_NUMBER166,

B.EXTN_ATTRIBUTE_NUMBER167,

B.EXTN_ATTRIBUTE_NUMBER168,

B.EXTN_ATTRIBUTE_CHAR281,

B.EXTN_ATTRIBUTE_CHAR282,

B.EXTN_ATTRIBUTE_CHAR283,

B.EXTN_ATTRIBUTE_CHAR284,

B.EXTN_ATTRIBUTE_CHAR285,

B.EXTN_ATTRIBUTE_CHAR286,

B.EXTN_ATTRIBUTE_CHAR287,

B.EXTN_ATTRIBUTE_CHAR288,

B.EXTN_ATTRIBUTE_CHAR289,

B.EXTN_ATTRIBUTE_CHAR290,

B.EXTN_ATTRIBUTE_CHAR291,

B.EXTN_ATTRIBUTE_CHAR292,

B.EXTN_ATTRIBUTE_CHAR293,

B.EXTN_ATTRIBUTE_CHAR294,

B.EXTN_ATTRIBUTE_NUMBER169,

B.EXTN_ATTRIBUTE_NUMBER170,

B.EXTN_ATTRIBUTE_NUMBER171,

B.EXTN_ATTRIBUTE_NUMBER172,

B.EXTN_ATTRIBUTE_NUMBER173,

B.EXTN_ATTRIBUTE_NUMBER174,

B.EXTN_ATTRIBUTE_NUMBER175,

B.EXTN_ATTRIBUTE_NUMBER176,

B.EXTN_ATTRIBUTE_CHAR295,

B.EXTN_ATTRIBUTE_CHAR296,

B.EXTN_ATTRIBUTE_CHAR297,

B.EXTN_ATTRIBUTE_CHAR298,

B.EXTN_ATTRIBUTE_CHAR299,

B.EXTN_ATTRIBUTE_CHAR300,

B.EXTN_ATTRIBUTE_CHAR301,

B.EXTN_ATTRIBUTE_CHAR302,

B.EXTN_ATTRIBUTE_CHAR303,

B.EXTN_ATTRIBUTE_CHAR304,

B.EXTN_ATTRIBUTE_CHAR305,

B.EXTN_ATTRIBUTE_CHAR306,

B.EXTN_ATTRIBUTE_CHAR307,

B.EXTN_ATTRIBUTE_CHAR308,

B.EXTN_ATTRIBUTE_CLOB021,

B.EXTN_ATTRIBUTE_CLOB022,

B.EXTN_ATTRIBUTE_NUMBER177,

B.EXTN_ATTRIBUTE_NUMBER178,

B.EXTN_ATTRIBUTE_NUMBER179,

B.EXTN_ATTRIBUTE_NUMBER180,

B.EXTN_ATTRIBUTE_NUMBER181,

B.EXTN_ATTRIBUTE_NUMBER182,

B.EXTN_ATTRIBUTE_NUMBER183,

B.EXTN_ATTRIBUTE_NUMBER184,

B.EXTN_ATTRIBUTE_CHAR309,

B.EXTN_ATTRIBUTE_CHAR310,

B.EXTN_ATTRIBUTE_CHAR311,

B.EXTN_ATTRIBUTE_CHAR312,

B.EXTN_ATTRIBUTE_CHAR313,

B.EXTN_ATTRIBUTE_CHAR314,

B.EXTN_ATTRIBUTE_CHAR315,

B.EXTN_ATTRIBUTE_CHAR316,

B.EXTN_ATTRIBUTE_CHAR317,

B.EXTN_ATTRIBUTE_CHAR318,

B.EXTN_ATTRIBUTE_CHAR319,

B.EXTN_ATTRIBUTE_CHAR320,

B.EXTN_ATTRIBUTE_CHAR321,

B.EXTN_ATTRIBUTE_CHAR322,

B.EXTN_ATTRIBUTE_NUMBER185,

B.EXTN_ATTRIBUTE_NUMBER186,

B.EXTN_ATTRIBUTE_NUMBER187,

B.EXTN_ATTRIBUTE_NUMBER188,

B.EXTN_ATTRIBUTE_NUMBER189,

B.EXTN_ATTRIBUTE_NUMBER190,

B.EXTN_ATTRIBUTE_NUMBER191,

B.EXTN_ATTRIBUTE_NUMBER192,

B.EXTN_ATTRIBUTE_CHAR323,

B.EXTN_ATTRIBUTE_CHAR324,

B.EXTN_ATTRIBUTE_CHAR325,

B.EXTN_ATTRIBUTE_CHAR326,

B.EXTN_ATTRIBUTE_CHAR327,

B.EXTN_ATTRIBUTE_CHAR328,

B.EXTN_ATTRIBUTE_CHAR329,

B.EXTN_ATTRIBUTE_CHAR330,

B.EXTN_ATTRIBUTE_CHAR331,

B.EXTN_ATTRIBUTE_CHAR332,

B.EXTN_ATTRIBUTE_CHAR333,

B.EXTN_ATTRIBUTE_CHAR334,

B.EXTN_ATTRIBUTE_CHAR335,

B.EXTN_ATTRIBUTE_CHAR336,

B.EXTN_ATTRIBUTE_CLOB023,

B.EXTN_ATTRIBUTE_CLOB024,

B.EXTN_ATTRIBUTE_NUMBER193,

B.EXTN_ATTRIBUTE_NUMBER194,

B.EXTN_ATTRIBUTE_NUMBER195,

B.EXTN_ATTRIBUTE_NUMBER196,

B.EXTN_ATTRIBUTE_NUMBER197,

B.EXTN_ATTRIBUTE_NUMBER198,

B.EXTN_ATTRIBUTE_NUMBER199,

B.EXTN_ATTRIBUTE_NUMBER200,

B.EXTN_ATTRIBUTE_CHAR337,

B.EXTN_ATTRIBUTE_CHAR338,

B.EXTN_ATTRIBUTE_CHAR339,

B.EXTN_ATTRIBUTE_CHAR340,

B.EXTN_ATTRIBUTE_CHAR341,

B.EXTN_ATTRIBUTE_CHAR342,

B.EXTN_ATTRIBUTE_CHAR343,

B.EXTN_ATTRIBUTE_CHAR344,

B.EXTN_ATTRIBUTE_CHAR345,

B.EXTN_ATTRIBUTE_CHAR346,

B.EXTN_ATTRIBUTE_CHAR347,

B.EXTN_ATTRIBUTE_CHAR348,

B.EXTN_ATTRIBUTE_CHAR349,

B.EXTN_ATTRIBUTE_CHAR350,

B.EXTN_ATTRIBUTE_CLOB025

FROM

OKC_K_LINES_B B,

OKC_K_LINES_TL TL

WHERE

B.ID = TL.ID AND B.MAJOR_VERSION = TL.MAJOR_VERSION AND TL.LANGUAGE = USERENV('LANG')