VIEW: APPS.OKL_EXT_FA_LINE_SOURCES_V

Source

View Text - Preformatted

SELECT fxl.line_extension_id line_extension_id ,fxl.header_extension_id header_extension_id ,fxl.source_id source_id ,fxl.source_table source_table ,fxl.object_version_number object_version_number ,fxl.fa_transaction_id fa_transaction_id ,fxl.asset_id asset_id ,fxl.kle_id kle_id ,fxl.asset_number asset_number ,fxl.contract_line_number contract_line_number ,fxl.asset_book_type_name asset_book_type_name ,fxl.asset_vendor_name asset_vendor_name ,fxl.installed_site_id installed_site_id ,fxl.line_attribute_category line_attribute_category ,fxl.line_attribute1 line_attribute1 ,fxl.line_attribute2 line_attribute2 ,fxl.line_attribute3 line_attribute3 ,fxl.line_attribute4 line_attribute4 ,fxl.line_attribute5 line_attribute5 ,fxl.line_attribute6 line_attribute6 ,fxl.line_attribute7 line_attribute7 ,fxl.line_attribute8 line_attribute8 ,fxl.line_attribute9 line_attribute9 ,fxl.line_attribute10 line_attribute10 ,fxl.line_attribute11 line_attribute11 ,fxl.line_attribute12 line_attribute12 ,fxl.line_attribute13 line_attribute13 ,fxl.line_attribute14 line_attribute14 ,fxl.line_attribute15 line_attribute15 ,fxll.language language ,fxll.inventory_org_name inventory_org_name ,fxll.trans_line_description trans_line_description ,fxl.created_by created_by ,fxl.creation_date creation_date ,fxl.last_updated_by last_updated_by ,fxl.last_update_date last_update_date ,fxl.last_update_login last_update_login ,fxl.inventory_org_code inventory_org_code ,fxl.asset_book_type_code asset_book_type_code ,fxl.period_counter period_counter ,fxl.inventory_item_name_code inventory_item_name_code ,fxll.inventory_item_name inventory_item_name ,FXL.ASSET_VENDOR_ID ASSET_VENDOR_ID FROM OKL_EXT_FA_LINE_SOURCES_B FXL,OKL_EXT_FA_LINE_SOURCES_TL FXLL WHERE fxl.line_extension_id = fxll.line_extension_id

View Text - HTML Formatted

SELECT FXL.LINE_EXTENSION_ID LINE_EXTENSION_ID
, FXL.HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, FXL.SOURCE_ID SOURCE_ID
, FXL.SOURCE_TABLE SOURCE_TABLE
, FXL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, FXL.FA_TRANSACTION_ID FA_TRANSACTION_ID
, FXL.ASSET_ID ASSET_ID
, FXL.KLE_ID KLE_ID
, FXL.ASSET_NUMBER ASSET_NUMBER
, FXL.CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, FXL.ASSET_BOOK_TYPE_NAME ASSET_BOOK_TYPE_NAME
, FXL.ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, FXL.INSTALLED_SITE_ID INSTALLED_SITE_ID
, FXL.LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, FXL.LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, FXL.LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, FXL.LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, FXL.LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, FXL.LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, FXL.LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, FXL.LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, FXL.LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, FXL.LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, FXL.LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, FXL.LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, FXL.LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, FXL.LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, FXL.LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, FXL.LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, FXLL.LANGUAGE LANGUAGE
, FXLL.INVENTORY_ORG_NAME INVENTORY_ORG_NAME
, FXLL.TRANS_LINE_DESCRIPTION TRANS_LINE_DESCRIPTION
, FXL.CREATED_BY CREATED_BY
, FXL.CREATION_DATE CREATION_DATE
, FXL.LAST_UPDATED_BY LAST_UPDATED_BY
, FXL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, FXL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FXL.INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, FXL.ASSET_BOOK_TYPE_CODE ASSET_BOOK_TYPE_CODE
, FXL.PERIOD_COUNTER PERIOD_COUNTER
, FXL.INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, FXLL.INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, FXL.ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM OKL_EXT_FA_LINE_SOURCES_B FXL
, OKL_EXT_FA_LINE_SOURCES_TL FXLL
WHERE FXL.LINE_EXTENSION_ID = FXLL.LINE_EXTENSION_ID