VIEW: APPS.IEX_ASSIGNED_ASSETS_V

Source

View Text - Preformatted

SELECT ida.DEL_ASSET_ID , ida.LAST_UPDATE_DATE , ida.SECURITY_GROUP_ID , ida.LAST_UPDATED_BY , ida.LAST_UPDATE_LOGIN , ida.CREATION_DATE , ida.CREATED_BY , ida.PROGRAM_ID , ida.OBJECT_VERSION_NUMBER, ida.REQUEST_ID , ida.PROGRAM_APPLICATION_ID, ida.PROGRAM_UPDATE_DATE, ida.ASSET_ID , ida.OBJECT_CODE , ida.OBJECT_ID , ida.DISPOSITION_CODE , ida.DISP_REASON_CODE , ida.ACTIVE_YN , ida.DELINQUENCY_ID , oalv.description FROM okx_asset_lines_v oalv, iex_del_Assets ida WHERE oalv.asset_id = ida.asset_id and ida.active_yn = 'Y'

View Text - HTML Formatted

SELECT IDA.DEL_ASSET_ID
, IDA.LAST_UPDATE_DATE
, IDA.SECURITY_GROUP_ID
, IDA.LAST_UPDATED_BY
, IDA.LAST_UPDATE_LOGIN
, IDA.CREATION_DATE
, IDA.CREATED_BY
, IDA.PROGRAM_ID
, IDA.OBJECT_VERSION_NUMBER
, IDA.REQUEST_ID
, IDA.PROGRAM_APPLICATION_ID
, IDA.PROGRAM_UPDATE_DATE
, IDA.ASSET_ID
, IDA.OBJECT_CODE
, IDA.OBJECT_ID
, IDA.DISPOSITION_CODE
, IDA.DISP_REASON_CODE
, IDA.ACTIVE_YN
, IDA.DELINQUENCY_ID
, OALV.DESCRIPTION
FROM OKX_ASSET_LINES_V OALV
, IEX_DEL_ASSETS IDA
WHERE OALV.ASSET_ID = IDA.ASSET_ID
AND IDA.ACTIVE_YN = 'Y'