Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_AM_ASSET_CNDTN_FULL_UV |
SELECT ACDB.ROWID ROW_ID
, ACDB.ID ID
, ACDB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACDB.CDN_CODE CDN_CODE
, ACDB.ILN_ID ILN_ID
, ACDB.ISP_ID ISP_ID
, ACDB.CLM_ID CLM_ID
, ACDB.KLE_ID KLE_ID
, ACDB.DATE_REPORT DATE_REPORT
, ACDB.ORG_ID ORG_ID
, ACDB.REQUEST_ID REQUEST_ID
, ACDB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, ACDB.PROGRAM_ID PROGRAM_ID
, ACDB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ACDB.CREATED_BY CREATED_BY
, ACDB.CREATION_DATE CREATION_DATE
, ACDB.LAST_UPDATED_BY LAST_UPDATED_BY
, ACDB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, ACDB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LOC.SEGMENT1||'-'||LOC.SEGMENT2||'-'||LOC.SEGMENT3||'-'||LOC.SEGMENT4 LOCATION_DESC
, VEN.NAME INSPECTOR_NAME
FROM OKL_ASSET_CNDTNS ACDB
, FA_LOCATIONS LOC
, OKX_VENDORS_V VEN
WHERE ACDB.ISP_ID = VEN.ID1
AND ACDB.ILN_ID = LOC.LOCATION_ID (+)