VIEW: APPS.IEX_REPOS_AVAIL_ASSETS_UV

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 , ID.DELINQUENCY_ID , ICO.CAS_ID FROM IEX_DELINQUENCIES ID,IEX_CASE_OBJECTS ICO,OKC_K_HEADERS_V OKHV,OKX_ASSET_LINES_V OALV,OKL_CNSLD_AR_STRMS_B STREAM WHERE ID.transaction_id=STREAM.receivables_invoice_id AND STREAM.khr_id=ICO.object_id AND ICO.OBJECT_CODE = 'CONTRACTS' AND ICO.OBJECT_ID = OKHV.ID AND ICO.OBJECT_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
, ID.DELINQUENCY_ID
, ICO.CAS_ID
FROM IEX_DELINQUENCIES ID
, IEX_CASE_OBJECTS ICO
, OKC_K_HEADERS_V OKHV
, OKX_ASSET_LINES_V OALV
, OKL_CNSLD_AR_STRMS_B STREAM
WHERE ID.TRANSACTION_ID=STREAM.RECEIVABLES_INVOICE_ID
AND STREAM.KHR_ID=ICO.OBJECT_ID
AND ICO.OBJECT_CODE = 'CONTRACTS'
AND ICO.OBJECT_ID = OKHV.ID
AND ICO.OBJECT_ID = OALV.DNZ_CHR_ID
AND NOT EXISTS (SELECT 1
FROM IEX_REPOS_OBJECTS REP
WHERE REP.ASSET_ID = OALV.ASSET_ID )