Product: | OFA - Assets |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.FAFV_ASSET_LEASES |
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