VIEW: APPS.OKL_EXT_AP_LINE_SOURCES_V

Source

View Text - Preformatted

SELECT pxl.line_extension_id line_extension_id ,pxl.header_extension_id header_extension_id ,pxl.source_id source_id ,pxl.source_table source_table ,pxl.object_version_number object_version_number ,pxl.kle_id kle_id ,pxl.sty_id sty_id ,pxl.asset_number asset_number ,pxl.contract_line_number contract_line_number ,pxl.asset_vendor_name asset_vendor_name ,pxl.installed_site_id installed_site_id ,pxl.fixed_asset_location_name fixed_asset_location_name ,pxl.accounting_template_name accounting_template_name ,pxl.fee_type_code fee_type_code ,pxl.memo_flag memo_flag ,pxl.contract_line_type contract_line_type ,pxl.line_attribute_category line_attribute_category ,pxl.line_attribute1 line_attribute1 ,pxl.line_attribute2 line_attribute2 ,pxl.line_attribute3 line_attribute3 ,pxl.line_attribute4 line_attribute4 ,pxl.line_attribute5 line_attribute5 ,pxl.line_attribute6 line_attribute6 ,pxl.line_attribute7 line_attribute7 ,pxl.line_attribute8 line_attribute8 ,pxl.line_attribute9 line_attribute9 ,pxl.line_attribute10 line_attribute10 ,pxl.line_attribute11 line_attribute11 ,pxl.line_attribute12 line_attribute12 ,pxl.line_attribute13 line_attribute13 ,pxl.line_attribute14 line_attribute14 ,pxl.line_attribute15 line_attribute15 ,pxl.stream_type_code stream_type_code ,pxl.stream_type_purpose_code stream_type_purpose_code ,pxl.inventory_org_code inventory_org_code ,pxll.language language ,pxll.inventory_org_name inventory_org_name ,pxll.stream_type_name stream_type_name ,pxll.trans_line_description trans_line_description ,pxl.created_by created_by ,pxl.creation_date creation_date ,pxl.last_updated_by last_updated_by ,pxl.last_update_date last_update_date ,pxl.last_update_login last_update_login ,pxl.asset_category_name asset_category_name ,pxl.inventory_item_name_code inventory_item_name_code ,pxll.inventory_item_name inventory_item_name ,PXL.ASSET_VENDOR_ID ASSET_VENDOR_ID FROM OKL_EXT_AP_LINE_SOURCES_B PXL,OKL_EXT_AP_LINE_SOURCES_TL PXLL WHERE pxl.line_extension_id = pxll.line_extension_id

View Text - HTML Formatted

SELECT PXL.LINE_EXTENSION_ID LINE_EXTENSION_ID
, PXL.HEADER_EXTENSION_ID HEADER_EXTENSION_ID
, PXL.SOURCE_ID SOURCE_ID
, PXL.SOURCE_TABLE SOURCE_TABLE
, PXL.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PXL.KLE_ID KLE_ID
, PXL.STY_ID STY_ID
, PXL.ASSET_NUMBER ASSET_NUMBER
, PXL.CONTRACT_LINE_NUMBER CONTRACT_LINE_NUMBER
, PXL.ASSET_VENDOR_NAME ASSET_VENDOR_NAME
, PXL.INSTALLED_SITE_ID INSTALLED_SITE_ID
, PXL.FIXED_ASSET_LOCATION_NAME FIXED_ASSET_LOCATION_NAME
, PXL.ACCOUNTING_TEMPLATE_NAME ACCOUNTING_TEMPLATE_NAME
, PXL.FEE_TYPE_CODE FEE_TYPE_CODE
, PXL.MEMO_FLAG MEMO_FLAG
, PXL.CONTRACT_LINE_TYPE CONTRACT_LINE_TYPE
, PXL.LINE_ATTRIBUTE_CATEGORY LINE_ATTRIBUTE_CATEGORY
, PXL.LINE_ATTRIBUTE1 LINE_ATTRIBUTE1
, PXL.LINE_ATTRIBUTE2 LINE_ATTRIBUTE2
, PXL.LINE_ATTRIBUTE3 LINE_ATTRIBUTE3
, PXL.LINE_ATTRIBUTE4 LINE_ATTRIBUTE4
, PXL.LINE_ATTRIBUTE5 LINE_ATTRIBUTE5
, PXL.LINE_ATTRIBUTE6 LINE_ATTRIBUTE6
, PXL.LINE_ATTRIBUTE7 LINE_ATTRIBUTE7
, PXL.LINE_ATTRIBUTE8 LINE_ATTRIBUTE8
, PXL.LINE_ATTRIBUTE9 LINE_ATTRIBUTE9
, PXL.LINE_ATTRIBUTE10 LINE_ATTRIBUTE10
, PXL.LINE_ATTRIBUTE11 LINE_ATTRIBUTE11
, PXL.LINE_ATTRIBUTE12 LINE_ATTRIBUTE12
, PXL.LINE_ATTRIBUTE13 LINE_ATTRIBUTE13
, PXL.LINE_ATTRIBUTE14 LINE_ATTRIBUTE14
, PXL.LINE_ATTRIBUTE15 LINE_ATTRIBUTE15
, PXL.STREAM_TYPE_CODE STREAM_TYPE_CODE
, PXL.STREAM_TYPE_PURPOSE_CODE STREAM_TYPE_PURPOSE_CODE
, PXL.INVENTORY_ORG_CODE INVENTORY_ORG_CODE
, PXLL.LANGUAGE LANGUAGE
, PXLL.INVENTORY_ORG_NAME INVENTORY_ORG_NAME
, PXLL.STREAM_TYPE_NAME STREAM_TYPE_NAME
, PXLL.TRANS_LINE_DESCRIPTION TRANS_LINE_DESCRIPTION
, PXL.CREATED_BY CREATED_BY
, PXL.CREATION_DATE CREATION_DATE
, PXL.LAST_UPDATED_BY LAST_UPDATED_BY
, PXL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PXL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PXL.ASSET_CATEGORY_NAME ASSET_CATEGORY_NAME
, PXL.INVENTORY_ITEM_NAME_CODE INVENTORY_ITEM_NAME_CODE
, PXLL.INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, PXL.ASSET_VENDOR_ID ASSET_VENDOR_ID
FROM OKL_EXT_AP_LINE_SOURCES_B PXL
, OKL_EXT_AP_LINE_SOURCES_TL PXLL
WHERE PXL.LINE_EXTENSION_ID = PXLL.LINE_EXTENSION_ID