VIEW: APPS.IEX_REPOS_AVAIL_ASSETS_UV2

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, okhv.contract_number, 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, null delinquency_id, null cas_id FROM okc_k_headers_v okhv, okx_asset_lines_v oalv WHERE okhv.id = oalv.dnz_chr_id AND NOT EXISTS (SELECT 1 FROM iex_repos_objects rep WHERE rep.asset_id = oalv.asset_id)

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
, OKHV.CONTRACT_NUMBER
, 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
, NULL DELINQUENCY_ID
, NULL CAS_ID
FROM OKC_K_HEADERS_V OKHV
, OKX_ASSET_LINES_V OALV
WHERE OKHV.ID = OALV.DNZ_CHR_ID
AND NOT EXISTS (SELECT 1
FROM IEX_REPOS_OBJECTS REP
WHERE REP.ASSET_ID = OALV.ASSET_ID)