VIEW: APPS.OKL_AP_REF_V

Source

View Text - Preformatted

SELECT pxl.source_id OKL_TPL_ID ,'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE ,pxh.khr_id OKL_KHR_ID ,pxl.kle_id OKL_KLE_ID ,pxh.try_id OKL_TRY_ID ,pxl.sty_id TCL_STY_ID ,pxh.contract_number TEH_CONTRACT_NUMBER ,pxh.customer_name TEH_CUSTOMER_NAME ,pxh.cust_account_number TEH_CUSTOMER_ACCOUNT_NUMBER ,pxh.rent_ia_contract_number TEH_RENT_IA_CONTRACT_NUMBER ,pxh.res_ia_contract_number TEH_RES_IA_CONTRACT_NUMBER ,pxh.converted_number TEH_CONVERTED_NUMBER ,pxh.contract_effective_from TEH_CONTRACT_EFFECTIVE_FROM ,pxh.contract_currency_code TEH_CONTRACT_CURRENCY_CODE ,pxh.sales_rep_name TEH_SALES_REP_NAME ,pxh.rent_ia_product_name TEH_RENT_IA_PRODUCT_NAME ,pxh.res_ia_product_name TEH_RES_IA_PRODUCT_NAME ,pxh.po_order_number TEH_PO_ORDER_NUMBER ,pxh.vendor_program_number TEH_VENDOR_PROGRAM_NUMBER ,pxh.rent_ia_accounting_code TEH_RENT_IA_ACCOUNTING_CODE ,pxh.res_ia_accounting_code TEH_RES_IA_ACCOUNTING_CODE ,pxh.assignable_flag TEH_ASSIGNABLE_FLAG ,pxh.converted_account_flag TEH_CONVERTED_ACCOUNT_FLAG ,pxh.accrual_override_flag TEH_ACCRUAL_OVERRIDE_FLAG ,pxh.khr_attribute_category TCN_ATTRIBUTE_CATEGORY ,pxh.khr_attribute1 TCN_ATTRIBUTE1 ,pxh.khr_attribute2 TCN_ATTRIBUTE2 ,pxh.khr_attribute3 TCN_ATTRIBUTE3 ,pxh.khr_attribute4 TCN_ATTRIBUTE4 ,pxh.khr_attribute5 TCN_ATTRIBUTE5 ,pxh.khr_attribute6 TCN_ATTRIBUTE6 ,pxh.khr_attribute7 TCN_ATTRIBUTE7 ,pxh.khr_attribute8 TCN_ATTRIBUTE8 ,pxh.khr_attribute9 TCN_ATTRIBUTE9 ,pxh.khr_attribute10 TCN_ATTRIBUTE10 ,pxh.khr_attribute11 TCN_ATTRIBUTE11 ,pxh.khr_attribute12 TCN_ATTRIBUTE12 ,pxh.khr_attribute13 TCN_ATTRIBUTE13 ,pxh.khr_attribute14 TCN_ATTRIBUTE14 ,pxh.khr_attribute15 TCN_ATTRIBUTE15 ,pxh.cust_attribute_category TEH_CUST_ATTRIBUTE_CATEGORY ,pxh.cust_attribute1 TEH_CUST_ATTRIBUTE1 ,pxh.cust_attribute2 TEH_CUST_ATTRIBUTE2 ,pxh.cust_attribute3 TEH_CUST_ATTRIBUTE3 ,pxh.cust_attribute4 TEH_CUST_ATTRIBUTE4 ,pxh.cust_attribute5 TEH_CUST_ATTRIBUTE5 ,pxh.cust_attribute6 TEH_CUST_ATTRIBUTE6 ,pxh.cust_attribute7 TEH_CUST_ATTRIBUTE7 ,pxh.cust_attribute8 TEH_CUST_ATTRIBUTE8 ,pxh.cust_attribute9 TEH_CUST_ATTRIBUTE9 ,pxh.cust_attribute10 TEH_CUST_ATTRIBUTE10 ,pxh.cust_attribute11 TEH_CUST_ATTRIBUTE11 ,pxh.cust_attribute12 TEH_CUST_ATTRIBUTE12 ,pxh.cust_attribute13 TEH_CUST_ATTRIBUTE13 ,pxh.cust_attribute14 TEH_CUST_ATTRIBUTE14 ,pxh.cust_attribute15 TEH_CUST_ATTRIBUTE15 ,pxh.rev_rec_method_code TEH_REV_REC_METHOD_CODE ,pxh.int_calc_method_code TEH_INT_CALC_METHOD_CODE ,pxl.asset_number TEL_ASSET_NUMBER ,pxl.contract_line_number TEL_CONTRACT_LINE_NUMBER ,pxh.book_classification_code TCN_BOOK_CLASSIFICATION_CODE ,pxh.product_name TCN_CONTRACT_PRODUCT_NAME ,pxh.tax_owner_code TCN_TAX_OWNER_CODE ,pxl.asset_vendor_name TEL_ASSET_VENDOR_NAME ,pxl.installed_site_id TEL_INSTALLED_SITE_ID ,pxl.fixed_asset_location_name TEL_FIXED_ASSET_LOCATION_NAME ,pxl.memo_flag TEL_MEMO_FLAG ,pxl.accounting_template_name DIST_ACCOUNTING_TEMPLATE_NAME ,pxl.fee_type_code TEL_FEE_TYPE_CODE ,pxl.contract_line_type OKL_KHR_LINE_TYPE ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute_category, NULL) TCL_ASSET_ATTRIBUTE_CATEGORY ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute1, NULL) TCL_ASSET_ATTRIBUTE1 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute2, NULL) TCL_ASSET_ATTRIBUTE2 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute3, NULL) TCL_ASSET_ATTRIBUTE3 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute4, NULL) TCL_ASSET_ATTRIBUTE4 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute5, NULL) TCL_ASSET_ATTRIBUTE5 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute6, NULL) TCL_ASSET_ATTRIBUTE6 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute7, NULL) TCL_ASSET_ATTRIBUTE7 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute8, NULL) TCL_ASSET_ATTRIBUTE8 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute9, NULL) TCL_ASSET_ATTRIBUTE9 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute10, NULL) TCL_ASSET_ATTRIBUTE10 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute11, NULL) TCL_ASSET_ATTRIBUTE11 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute12, NULL) TCL_ASSET_ATTRIBUTE12 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute13, NULL) TCL_ASSET_ATTRIBUTE13 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute14, NULL) TCL_ASSET_ATTRIBUTE14 ,DECODE( pxl.contract_line_type, 'FREE_FORM1', pxl.line_attribute15, NULL) TCL_ASSET_ATTRIBUTE15 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute_category, NULL) TCL_FEE_ATTRIBUTE_CATEGORY ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute1, NULL) TCL_FEE_ATTRIBUTE1 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute2, NULL) TCL_FEE_ATTRIBUTE2 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute3, NULL) TCL_FEE_ATTRIBUTE3 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute4, NULL) TCL_FEE_ATTRIBUTE4 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute5, NULL) TCL_FEE_ATTRIBUTE5 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute6, NULL) TCL_FEE_ATTRIBUTE6 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute7, NULL) TCL_FEE_ATTRIBUTE7 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute8, NULL) TCL_FEE_ATTRIBUTE8 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute9, NULL) TCL_FEE_ATTRIBUTE9 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute10, NULL) TCL_FEE_ATTRIBUTE10 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute11, NULL) TCL_FEE_ATTRIBUTE11 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute12, NULL) TCL_FEE_ATTRIBUTE12 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute13, NULL) TCL_FEE_ATTRIBUTE13 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute14, NULL) TCL_FEE_ATTRIBUTE14 ,DECODE( pxl.contract_line_type, 'FEE', pxl.line_attribute15, NULL) TCL_FEE_ATTRIBUTE15 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute_category, NULL) TCL_SERVICE_ATTRIBUTE_CATEGORY ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute1, NULL) TCL_SERVICE_ATTRIBUTE1 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute2, NULL) TCL_SERVICE_ATTRIBUTE2 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute3, NULL) TCL_SERVICE_ATTRIBUTE3 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute4, NULL) TCL_SERVICE_ATTRIBUTE4 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute5, NULL) TCL_SERVICE_ATTRIBUTE5 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute6, NULL) TCL_SERVICE_ATTRIBUTE6 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute7, NULL) TCL_SERVICE_ATTRIBUTE7 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute8, NULL) TCL_SERVICE_ATTRIBUTE8 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute9, NULL) TCL_SERVICE_ATTRIBUTE9 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute10, NULL) TCL_SERVICE_ATTRIBUTE10 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute11, NULL) TCL_SERVICE_ATTRIBUTE11 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute12, NULL) TCL_SERVICE_ATTRIBUTE12 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute13, NULL) TCL_SERVICE_ATTRIBUTE13 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute14, NULL) TCL_SERVICE_ATTRIBUTE14 ,DECODE( pxl.contract_line_type, 'SERVICE', pxl.line_attribute15, NULL) TCL_SERVICE_ATTRIBUTE15 ,pxh.contract_status_code TEH_CONTRACT_STATUS_CODE ,pxh.trx_type_class_code TEH_TRX_TYPE_CLASS_CODE ,pxl.inventory_org_code TEL_INVENTORY_ORG_CODE ,pxl.stream_type_code TCL_STREAM_TYPE_CODE ,pxl.stream_type_purpose_code TCL_STREAM_TYPE_PURPOSE ,pxl.asset_category_name tel_asset_category_name ,pxl.inventory_item_name_code tel_inventory_item_name_code FROM OKL_EXT_AP_HEADER_SOURCES_B PXH,OKL_EXT_AP_LINE_SOURCES_B PXL WHERE pxh.header_extension_id = pxl.header_extension_id AND pxl.source_table = 'OKL_TXL_AP_INV_LNS_B'

View Text - HTML Formatted

SELECT PXL.SOURCE_ID OKL_TPL_ID
, 'OKL_TXL_AP_INV_LNS_ALL_B' OKL_PRODUCT_TABLE
, PXH.KHR_ID OKL_KHR_ID
, PXL.KLE_ID OKL_KLE_ID
, PXH.TRY_ID OKL_TRY_ID
, PXL.STY_ID TCL_STY_ID
, PXH.CONTRACT_NUMBER TEH_CONTRACT_NUMBER
, PXH.CUSTOMER_NAME TEH_CUSTOMER_NAME
, PXH.CUST_ACCOUNT_NUMBER TEH_CUSTOMER_ACCOUNT_NUMBER
, PXH.RENT_IA_CONTRACT_NUMBER TEH_RENT_IA_CONTRACT_NUMBER
, PXH.RES_IA_CONTRACT_NUMBER TEH_RES_IA_CONTRACT_NUMBER
, PXH.CONVERTED_NUMBER TEH_CONVERTED_NUMBER
, PXH.CONTRACT_EFFECTIVE_FROM TEH_CONTRACT_EFFECTIVE_FROM
, PXH.CONTRACT_CURRENCY_CODE TEH_CONTRACT_CURRENCY_CODE
, PXH.SALES_REP_NAME TEH_SALES_REP_NAME
, PXH.RENT_IA_PRODUCT_NAME TEH_RENT_IA_PRODUCT_NAME
, PXH.RES_IA_PRODUCT_NAME TEH_RES_IA_PRODUCT_NAME
, PXH.PO_ORDER_NUMBER TEH_PO_ORDER_NUMBER
, PXH.VENDOR_PROGRAM_NUMBER TEH_VENDOR_PROGRAM_NUMBER
, PXH.RENT_IA_ACCOUNTING_CODE TEH_RENT_IA_ACCOUNTING_CODE
, PXH.RES_IA_ACCOUNTING_CODE TEH_RES_IA_ACCOUNTING_CODE
, PXH.ASSIGNABLE_FLAG TEH_ASSIGNABLE_FLAG
, PXH.CONVERTED_ACCOUNT_FLAG TEH_CONVERTED_ACCOUNT_FLAG
, PXH.ACCRUAL_OVERRIDE_FLAG TEH_ACCRUAL_OVERRIDE_FLAG
, PXH.KHR_ATTRIBUTE_CATEGORY TCN_ATTRIBUTE_CATEGORY
, PXH.KHR_ATTRIBUTE1 TCN_ATTRIBUTE1
, PXH.KHR_ATTRIBUTE2 TCN_ATTRIBUTE2
, PXH.KHR_ATTRIBUTE3 TCN_ATTRIBUTE3
, PXH.KHR_ATTRIBUTE4 TCN_ATTRIBUTE4
, PXH.KHR_ATTRIBUTE5 TCN_ATTRIBUTE5
, PXH.KHR_ATTRIBUTE6 TCN_ATTRIBUTE6
, PXH.KHR_ATTRIBUTE7 TCN_ATTRIBUTE7
, PXH.KHR_ATTRIBUTE8 TCN_ATTRIBUTE8
, PXH.KHR_ATTRIBUTE9 TCN_ATTRIBUTE9
, PXH.KHR_ATTRIBUTE10 TCN_ATTRIBUTE10
, PXH.KHR_ATTRIBUTE11 TCN_ATTRIBUTE11
, PXH.KHR_ATTRIBUTE12 TCN_ATTRIBUTE12
, PXH.KHR_ATTRIBUTE13 TCN_ATTRIBUTE13
, PXH.KHR_ATTRIBUTE14 TCN_ATTRIBUTE14
, PXH.KHR_ATTRIBUTE15 TCN_ATTRIBUTE15
, PXH.CUST_ATTRIBUTE_CATEGORY TEH_CUST_ATTRIBUTE_CATEGORY
, PXH.CUST_ATTRIBUTE1 TEH_CUST_ATTRIBUTE1
, PXH.CUST_ATTRIBUTE2 TEH_CUST_ATTRIBUTE2
, PXH.CUST_ATTRIBUTE3 TEH_CUST_ATTRIBUTE3
, PXH.CUST_ATTRIBUTE4 TEH_CUST_ATTRIBUTE4
, PXH.CUST_ATTRIBUTE5 TEH_CUST_ATTRIBUTE5
, PXH.CUST_ATTRIBUTE6 TEH_CUST_ATTRIBUTE6
, PXH.CUST_ATTRIBUTE7 TEH_CUST_ATTRIBUTE7
, PXH.CUST_ATTRIBUTE8 TEH_CUST_ATTRIBUTE8
, PXH.CUST_ATTRIBUTE9 TEH_CUST_ATTRIBUTE9
, PXH.CUST_ATTRIBUTE10 TEH_CUST_ATTRIBUTE10
, PXH.CUST_ATTRIBUTE11 TEH_CUST_ATTRIBUTE11
, PXH.CUST_ATTRIBUTE12 TEH_CUST_ATTRIBUTE12
, PXH.CUST_ATTRIBUTE13 TEH_CUST_ATTRIBUTE13
, PXH.CUST_ATTRIBUTE14 TEH_CUST_ATTRIBUTE14
, PXH.CUST_ATTRIBUTE15 TEH_CUST_ATTRIBUTE15
, PXH.REV_REC_METHOD_CODE TEH_REV_REC_METHOD_CODE
, PXH.INT_CALC_METHOD_CODE TEH_INT_CALC_METHOD_CODE
, PXL.ASSET_NUMBER TEL_ASSET_NUMBER
, PXL.CONTRACT_LINE_NUMBER TEL_CONTRACT_LINE_NUMBER
, PXH.BOOK_CLASSIFICATION_CODE TCN_BOOK_CLASSIFICATION_CODE
, PXH.PRODUCT_NAME TCN_CONTRACT_PRODUCT_NAME
, PXH.TAX_OWNER_CODE TCN_TAX_OWNER_CODE
, PXL.ASSET_VENDOR_NAME TEL_ASSET_VENDOR_NAME
, PXL.INSTALLED_SITE_ID TEL_INSTALLED_SITE_ID
, PXL.FIXED_ASSET_LOCATION_NAME TEL_FIXED_ASSET_LOCATION_NAME
, PXL.MEMO_FLAG TEL_MEMO_FLAG
, PXL.ACCOUNTING_TEMPLATE_NAME DIST_ACCOUNTING_TEMPLATE_NAME
, PXL.FEE_TYPE_CODE TEL_FEE_TYPE_CODE
, PXL.CONTRACT_LINE_TYPE OKL_KHR_LINE_TYPE
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_ASSET_ATTRIBUTE_CATEGORY
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE1
, NULL) TCL_ASSET_ATTRIBUTE1
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE2
, NULL) TCL_ASSET_ATTRIBUTE2
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE3
, NULL) TCL_ASSET_ATTRIBUTE3
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE4
, NULL) TCL_ASSET_ATTRIBUTE4
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE5
, NULL) TCL_ASSET_ATTRIBUTE5
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE6
, NULL) TCL_ASSET_ATTRIBUTE6
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE7
, NULL) TCL_ASSET_ATTRIBUTE7
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE8
, NULL) TCL_ASSET_ATTRIBUTE8
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE9
, NULL) TCL_ASSET_ATTRIBUTE9
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE10
, NULL) TCL_ASSET_ATTRIBUTE10
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE11
, NULL) TCL_ASSET_ATTRIBUTE11
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE12
, NULL) TCL_ASSET_ATTRIBUTE12
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE13
, NULL) TCL_ASSET_ATTRIBUTE13
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE14
, NULL) TCL_ASSET_ATTRIBUTE14
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FREE_FORM1'
, PXL.LINE_ATTRIBUTE15
, NULL) TCL_ASSET_ATTRIBUTE15
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_FEE_ATTRIBUTE_CATEGORY
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE1
, NULL) TCL_FEE_ATTRIBUTE1
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE2
, NULL) TCL_FEE_ATTRIBUTE2
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE3
, NULL) TCL_FEE_ATTRIBUTE3
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE4
, NULL) TCL_FEE_ATTRIBUTE4
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE5
, NULL) TCL_FEE_ATTRIBUTE5
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE6
, NULL) TCL_FEE_ATTRIBUTE6
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE7
, NULL) TCL_FEE_ATTRIBUTE7
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE8
, NULL) TCL_FEE_ATTRIBUTE8
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE9
, NULL) TCL_FEE_ATTRIBUTE9
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE10
, NULL) TCL_FEE_ATTRIBUTE10
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE11
, NULL) TCL_FEE_ATTRIBUTE11
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE12
, NULL) TCL_FEE_ATTRIBUTE12
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE13
, NULL) TCL_FEE_ATTRIBUTE13
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE14
, NULL) TCL_FEE_ATTRIBUTE14
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'FEE'
, PXL.LINE_ATTRIBUTE15
, NULL) TCL_FEE_ATTRIBUTE15
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE_CATEGORY
, NULL) TCL_SERVICE_ATTRIBUTE_CATEGORY
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE1
, NULL) TCL_SERVICE_ATTRIBUTE1
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE2
, NULL) TCL_SERVICE_ATTRIBUTE2
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE3
, NULL) TCL_SERVICE_ATTRIBUTE3
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE4
, NULL) TCL_SERVICE_ATTRIBUTE4
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE5
, NULL) TCL_SERVICE_ATTRIBUTE5
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE6
, NULL) TCL_SERVICE_ATTRIBUTE6
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE7
, NULL) TCL_SERVICE_ATTRIBUTE7
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE8
, NULL) TCL_SERVICE_ATTRIBUTE8
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE9
, NULL) TCL_SERVICE_ATTRIBUTE9
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE10
, NULL) TCL_SERVICE_ATTRIBUTE10
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE11
, NULL) TCL_SERVICE_ATTRIBUTE11
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE12
, NULL) TCL_SERVICE_ATTRIBUTE12
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE13
, NULL) TCL_SERVICE_ATTRIBUTE13
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE14
, NULL) TCL_SERVICE_ATTRIBUTE14
, DECODE( PXL.CONTRACT_LINE_TYPE
, 'SERVICE'
, PXL.LINE_ATTRIBUTE15
, NULL) TCL_SERVICE_ATTRIBUTE15
, PXH.CONTRACT_STATUS_CODE TEH_CONTRACT_STATUS_CODE
, PXH.TRX_TYPE_CLASS_CODE TEH_TRX_TYPE_CLASS_CODE
, PXL.INVENTORY_ORG_CODE TEL_INVENTORY_ORG_CODE
, PXL.STREAM_TYPE_CODE TCL_STREAM_TYPE_CODE
, PXL.STREAM_TYPE_PURPOSE_CODE TCL_STREAM_TYPE_PURPOSE
, PXL.ASSET_CATEGORY_NAME TEL_ASSET_CATEGORY_NAME
, PXL.INVENTORY_ITEM_NAME_CODE TEL_INVENTORY_ITEM_NAME_CODE
FROM OKL_EXT_AP_HEADER_SOURCES_B PXH
, OKL_EXT_AP_LINE_SOURCES_B PXL
WHERE PXH.HEADER_EXTENSION_ID = PXL.HEADER_EXTENSION_ID
AND PXL.SOURCE_TABLE = 'OKL_TXL_AP_INV_LNS_B'