VIEW: APPS.IEX_AVAILABLE_ASSETS_V

Source

View Text - Preformatted

SELECT OALV.id1, OALV.id2, OALV.name, OALV.description, OALV.item_description, OALV.comments, OALV.chr_id, OALV.dnz_chr_id, OALV.lty_code, OALV.lse_type, OALV.lse_parent_id, OALV.parent_line_id, OALV.line_number, OALV.date_terminated, OALV.start_date_active, OALV.end_date_active, OALV.status, OALV.asset_id, OALV.quantity, OALV.unit_of_measure_code, OALV.asset_number, OALV.corporate_book, OALV.life_in_months, OALV.original_cost, OALV.cost, OALV.adjusted_cost, OALV.tag_number, OALV.current_units, OALV.serial_number, OALV.reval_ceiling, OALV.new_used, OALV.in_service_date, OALV.manufacturer_name, OALV.model_number, OALV.asset_type, OALV.salvage_value, OALV.percent_salvage_value, OALV.depreciation_category, OALV.deprn_start_date, OALV.deprn_method_code, OALV.rate_adjustment_factor, OALV.basic_rate, OALV.adjusted_rate, OALV.recoverable_cost, OALV.org_id , OALV.set_of_books_id, OALV.property_type_code, OALV.property_1245_1250_code, OALV.in_use_flag , OALV.owned_leased , OALV.inventorial , OALV.line_status , ID.delinquency_id , ID.case_id from okx_asset_lines_v oalv , IEX_DELINQUENCIES ID , IEX_CASE_OBJECTS ICO WHERE OALV.chr_id = ICO.object_id AND ICO.object_code = 'CONTRACTS' AND ICO.cas_id = ID.case_id AND NOT EXISTS (Select 1 from iex_del_assets where asset_id = oalv.asset_id and active_yn = 'Y')

View Text - HTML Formatted

SELECT OALV.ID1
, OALV.ID2
, OALV.NAME
, OALV.DESCRIPTION
, OALV.ITEM_DESCRIPTION
, OALV.COMMENTS
, OALV.CHR_ID
, OALV.DNZ_CHR_ID
, OALV.LTY_CODE
, OALV.LSE_TYPE
, OALV.LSE_PARENT_ID
, OALV.PARENT_LINE_ID
, OALV.LINE_NUMBER
, OALV.DATE_TERMINATED
, OALV.START_DATE_ACTIVE
, OALV.END_DATE_ACTIVE
, OALV.STATUS
, OALV.ASSET_ID
, OALV.QUANTITY
, OALV.UNIT_OF_MEASURE_CODE
, OALV.ASSET_NUMBER
, OALV.CORPORATE_BOOK
, OALV.LIFE_IN_MONTHS
, OALV.ORIGINAL_COST
, OALV.COST
, OALV.ADJUSTED_COST
, OALV.TAG_NUMBER
, OALV.CURRENT_UNITS
, OALV.SERIAL_NUMBER
, OALV.REVAL_CEILING
, OALV.NEW_USED
, OALV.IN_SERVICE_DATE
, OALV.MANUFACTURER_NAME
, OALV.MODEL_NUMBER
, OALV.ASSET_TYPE
, OALV.SALVAGE_VALUE
, OALV.PERCENT_SALVAGE_VALUE
, OALV.DEPRECIATION_CATEGORY
, OALV.DEPRN_START_DATE
, OALV.DEPRN_METHOD_CODE
, OALV.RATE_ADJUSTMENT_FACTOR
, OALV.BASIC_RATE
, OALV.ADJUSTED_RATE
, OALV.RECOVERABLE_COST
, OALV.ORG_ID
, OALV.SET_OF_BOOKS_ID
, OALV.PROPERTY_TYPE_CODE
, OALV.PROPERTY_1245_1250_CODE
, OALV.IN_USE_FLAG
, OALV.OWNED_LEASED
, OALV.INVENTORIAL
, OALV.LINE_STATUS
, ID.DELINQUENCY_ID
, ID.CASE_ID
FROM OKX_ASSET_LINES_V OALV
, IEX_DELINQUENCIES ID
, IEX_CASE_OBJECTS ICO
WHERE OALV.CHR_ID = ICO.OBJECT_ID
AND ICO.OBJECT_CODE = 'CONTRACTS'
AND ICO.CAS_ID = ID.CASE_ID
AND NOT EXISTS (SELECT 1
FROM IEX_DEL_ASSETS
WHERE ASSET_ID = OALV.ASSET_ID
AND ACTIVE_YN = 'Y')