VIEW: APPS.OKL_AM_ASSET_CNDTN_FULL_UV

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)