VIEW: APPS.OKL_AM_ASSET_DETAILS_UV

Source

View Text - Preformatted

SELECT CLEV.ID ID , CLEV.NAME NAME , CLEV.ITEM_DESCRIPTION ITEM_DESCRIPTION , CLEV.CHR_ID CHR_ID , OKHV.CONTRACT_NUMBER CONTRACT_NUMBER , OKHV.STS_CODE CONTRACT_STATUS, CLEV.START_DATE START_DATE, CLEV.END_DATE END_DATE, CLEV.STS_CODE LINE_STATUS, OALV.COST ORIGINAL_COST, OALV.SERIAL_NUMBER SERIAL_NUMBER, OALV.IN_SERVICE_DATE IN_SERVICE_DATE, OALV.MANUFACTURER_NAME MANUFACTURER_NAME, OALV.MODEL_NUMBER MODEL_NUMBER, OALV.ASSET_TYPE ASSET_TYPE, OALV.LIFE_IN_MONTHS LIFE_IN_MONTHS, OALV.NEW_USED NEW_USED, OALV.SALVAGE_VALUE SALVAGE_VALUE, OALV.DEPRECIATION_CATEGORY DEPRECIATION_CATEGORY, OALV.DEPRN_START_DATE DEPRN_START_DATE, FAC.DESCRIPTION DEPRN_CATEGORY_DESC FROM OKL_K_LINES_FULL_V CLEV,OKX_ASSET_LINES_V OALV,OKC_K_HEADERS_B OKHV,OKC_LINE_STYLES_V LSEV,FA_CATEGORIES_VL FAC WHERE CLEV.ID = OALV.PARENT_LINE_ID(+) AND CLEV.CHR_ID = OKHV.ID AND CLEV.LSE_ID = LSEV.ID AND LSEV.LTY_CODE = 'FREE_FORM1' AND FAC.CATEGORY_ID (+) = OALV.DEPRECIATION_CATEGORY

View Text - HTML Formatted

SELECT CLEV.ID ID
, CLEV.NAME NAME
, CLEV.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLEV.CHR_ID CHR_ID
, OKHV.CONTRACT_NUMBER CONTRACT_NUMBER
, OKHV.STS_CODE CONTRACT_STATUS
, CLEV.START_DATE START_DATE
, CLEV.END_DATE END_DATE
, CLEV.STS_CODE LINE_STATUS
, OALV.COST ORIGINAL_COST
, OALV.SERIAL_NUMBER SERIAL_NUMBER
, OALV.IN_SERVICE_DATE IN_SERVICE_DATE
, OALV.MANUFACTURER_NAME MANUFACTURER_NAME
, OALV.MODEL_NUMBER MODEL_NUMBER
, OALV.ASSET_TYPE ASSET_TYPE
, OALV.LIFE_IN_MONTHS LIFE_IN_MONTHS
, OALV.NEW_USED NEW_USED
, OALV.SALVAGE_VALUE SALVAGE_VALUE
, OALV.DEPRECIATION_CATEGORY DEPRECIATION_CATEGORY
, OALV.DEPRN_START_DATE DEPRN_START_DATE
, FAC.DESCRIPTION DEPRN_CATEGORY_DESC
FROM OKL_K_LINES_FULL_V CLEV
, OKX_ASSET_LINES_V OALV
, OKC_K_HEADERS_B OKHV
, OKC_LINE_STYLES_V LSEV
, FA_CATEGORIES_VL FAC
WHERE CLEV.ID = OALV.PARENT_LINE_ID(+)
AND CLEV.CHR_ID = OKHV.ID
AND CLEV.LSE_ID = LSEV.ID
AND LSEV.LTY_CODE = 'FREE_FORM1'
AND FAC.CATEGORY_ID (+) = OALV.DEPRECIATION_CATEGORY