VIEW: APPS.FAFV_ASSET_LEASES

Source

View Text - Preformatted

SELECT LE.LEASE_ID , LE.LEASE_NUMBER , LE.DESCRIPTION , LE.FASB_LEASE_TYPE , LE.COST_CAPITALIZED , LE.TRANSFER_OWNERSHIP , LE.BARGAIN_PURCHASE_OPTION , LE.FAIR_VALUE , LE.PRESENT_VALUE , LE.LEASE_TYPE , LE.ASSET_LIFE , LE.LEASE_TERM , LE.LESSOR_ID , VE.VENDOR_NAME , LE.CURRENCY_CODE , CR.DESCRIPTION , LE.LAST_UPDATE_DATE , LE.LAST_UPDATED_BY , LE.CREATED_BY , LE.CREATION_DATE FROM FA_LEASES LE, FND_CURRENCIES_VL CR, PO_VENDORS VE WHERE LE.CURRENCY_CODE = CR.CURRENCY_CODE (+) AND LE.LESSOR_ID = VE.VENDOR_ID WITH READ ONLY

View Text - HTML Formatted

SELECT LE.LEASE_ID
, LE.LEASE_NUMBER
, LE.DESCRIPTION
, LE.FASB_LEASE_TYPE
, LE.COST_CAPITALIZED
, LE.TRANSFER_OWNERSHIP
, LE.BARGAIN_PURCHASE_OPTION
, LE.FAIR_VALUE
, LE.PRESENT_VALUE
, LE.LEASE_TYPE
, LE.ASSET_LIFE
, LE.LEASE_TERM
, LE.LESSOR_ID
, VE.VENDOR_NAME
, LE.CURRENCY_CODE
, CR.DESCRIPTION
, LE.LAST_UPDATE_DATE
, LE.LAST_UPDATED_BY
, LE.CREATED_BY
, LE.CREATION_DATE
FROM FA_LEASES LE
, FND_CURRENCIES_VL CR
, PO_VENDORS VE
WHERE LE.CURRENCY_CODE = CR.CURRENCY_CODE (+)
AND LE.LESSOR_ID = VE.VENDOR_ID WITH READ ONLY