[Home] [Help]
| Product: | OKL - Leasing and Finance Management |
|---|---|
| Description: | Open interface asset details for report to credit bureau/transfer to external agency |
| Implementation/DBA Data: | Not implemented in this database |
SELECT OIA.ROWID ROW_ID
, OIA.ID
, OIA.KHR_ID
, OIA.INSTANCE_NUMBER
, OIA.ASSET_ID
, OIA.ASSET_NUMBER
, OIA.DESCRIPTION
, OIA.ASSET_TYPE
, OIA.MANUFACTURER_NAME
, OIA.MODEL_NUMBER
, OIA.SERIAL_NUMBER
, OIA.TAG_NUMBER
, OIA.ORIGINAL_COST
, OIA.QUANTITY
, OIA.COUNTRY
, OIA.ADDRESS1
, OIA.ADDRESS2
, OIA.ADDRESS3
, OIA.ADDRESS4
, OIA.CITY
, OIA.POSTAL_CODE
, OIA.STATE
, OIA.PROVINCE
, OIA.COUNTY
, OIA.PO_BOX_NUMBER
, OIA.HOUSE_NUMBER
, OIA.STREET_SUFFIX
, OIA.APARTMENT_NUMBER
, OIA.STREET
, OIA.RURAL_ROUTE_NUMBER
, OIA.STREET_NUMBER
, OIA.BUILDING
, OIA.FLOOR
, OIA.SUITE
, OIA.ROOM
, OIA.POSTAL_PLUS4_CODE
, OIA.OBJECT_VERSION_NUMBER
, OIA.ORG_ID
, OIA.REQUEST_ID
, OIA.PROGRAM_APPLICATION_ID
, OIA.PROGRAM_ID
, OIA.PROGRAM_UPDATE_DATE
, OIA.ATTRIBUTE_CATEGORY
, OIA.ATTRIBUTE1
, OIA.ATTRIBUTE2
, OIA.ATTRIBUTE3
, OIA.ATTRIBUTE4
, OIA.ATTRIBUTE5
, OIA.ATTRIBUTE6
, OIA.ATTRIBUTE7
, OIA.ATTRIBUTE8
, OIA.ATTRIBUTE9
, OIA.ATTRIBUTE10
, OIA.ATTRIBUTE11
, OIA.ATTRIBUTE12
, OIA.ATTRIBUTE13
, OIA.ATTRIBUTE14
, OIA.ATTRIBUTE15
, OIA.CREATED_BY
, OIA.CREATION_DATE
, OIA.LAST_UPDATED_BY
, OIA.LAST_UPDATE_DATE
, OIA.LAST_UPDATE_LOGIN
FROM OKL_OPEN_INT_ASST OIA