VIEW: APPS.OKL_EXT_AR_LINE_SOURCES_V

Source

View Text - Preformatted

SELECT rxl.line_extension_id line_extension_id ,rxl.header_extension_id header_extension_id ,rxl.source_id source_id ,rxl.source_table source_table ,rxl.object_version_number object_version_number ,rxl.kle_id kle_id ,rxl.sty_id sty_id ,rxl.asset_number asset_number ,rxl.contract_line_number contract_line_number ,rxl.asset_vendor_name asset_vendor_name ,rxl.installed_site_id installed_site_id ,rxl.fixed_asset_location_name fixed_asset_location_name ,rxl.subsidy_name subsidy_name ,rxl.accounting_template_name accounting_template_name ,rxl.subsidy_party_name subsidy_party_name ,rxl.contingency_code contingency_code ,rxl.fee_type_code fee_type_code ,rxl.memo_flag memo_flag ,rxl.contract_line_type contract_line_type ,rxl.line_attribute_category line_attribute_category ,rxl.line_attribute1 line_attribute1 ,rxl.line_attribute2 line_attribute2 ,rxl.line_attribute3 line_attribute3 ,rxl.line_attribute4 line_attribute4 ,rxl.line_attribute5 line_attribute5 ,rxl.line_attribute6 line_attribute6 ,rxl.line_attribute7 line_attribute7 ,rxl.line_attribute8 line_attribute8 ,rxl.line_attribute9 line_attribute9 ,rxl.line_attribute10 line_attribute10 ,rxl.line_attribute11 line_attribute11 ,rxl.line_attribute12 line_attribute12 ,rxl.line_attribute13 line_attribute13 ,rxl.line_attribute14 line_attribute14 ,rxl.line_attribute15 line_attribute15 ,rxl.stream_type_code stream_type_code ,rxl.stream_type_purpose_code stream_type_purpose_code ,rxl.inventory_org_code inventory_org_code ,rxll.language language ,rxll.inventory_org_name inventory_org_name ,rxll.stream_type_name stream_type_name ,rxll.trans_line_description trans_line_description ,rxl.created_by created_by ,rxl.creation_date creation_date ,rxl.last_updated_by last_updated_by ,rxl.last_update_date last_update_date ,rxl.last_update_login last_update_login ,rxl.asset_category_name asset_category_name ,rxl.inventory_item_name_code inventory_item_name_code ,rxll.inventory_item_name inventory_item_name ,RXL.ASSET_VENDOR_ID ASSET_VENDOR_ID ,RXL.SUBSIDY_VENDOR_ID SUBSIDY_VENDOR_ID FROM OKL_EXT_AR_LINE_SOURCES_B RXL,OKL_EXT_AR_LINE_SOURCES_TL RXLL WHERE rxl.line_extension_id = rxll.line_extension_id

View Text - HTML Formatted

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