[Home] [Help]
SELECT CLE.ID ID1, '#' ID2, FA.NAME NAME, FA.DESCRIPTION DESCRIPTION, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION, TL.COMMENTS COMMENTS, CLE.CHR_ID CHR_ID, CLE.DNZ_CHR_ID DNZ_CHR_ID, LS.LTY_CODE LTY_CODE, LS.LSE_TYPE LSE_TYPE, LS.LSE_PARENT_ID LSE_PARENT_ID, CLE.CLE_ID PARENT_LINE_ID, CLE.LINE_NUMBER LINE_NUMBER, CLE.DATE_TERMINATED DATE_TERMINATED, CLE.START_DATE START_DATE_ACTIVE, CLE.END_DATE END_DATE_ACTIVE, DECODE(SIGN(trunc(sysdate)-NVL(trunc(CLE.start_date),trunc(sysdate))),-1,'I',DECODE(SIGN(trunc(sysdate) - NVL(trunc(CLE.end_date),trunc(sysdate))), 1,'I','A')) STATUS, FA.ASSET_ID ASSET_ID, FA.CURRENT_UNITS QUANTITY, CIM.UOM_CODE UNIT_OF_MEASURE_CODE, FA.ASSET_NUMBER ASSET_NUMBER, FA.CORPORATE_BOOK CORPORATE_BOOK, FA.LIFE_IN_MONTHS LIFE_IN_MONTHS, TOP_KLE.OEC ORIGINAL_COST, FA.COST COST, FA.ADJUSTED_COST ADJUSTED_COST, FA.TAG_NUMBER TAG_NUMBER, FA.CURRENT_UNITS CURRENT_UNITS, FA.SERIAL_NUMBER SERIAL_NUMBER, FA.REVAL_CEILING REVAL_CEILING, FA.NEW_USED NEW_USED, FA.IN_SERVICE_DATE IN_SERVICE_DATE, FA.MANUFACTURER_NAME MANUFACTURER_NAME, FA.MODEL_NUMBER MODEL_NUMBER, FA.ASSET_TYPE ASSET_TYPE, FA.SALVAGE_VALUE SALVAGE_VALUE, FA.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE, FA.DEPRECIATION_CATEGORY DEPRECIATION_CATEGORY, FA.DEPRN_START_DATE DEPRN_START_DATE, FA.DEPRN_METHOD_CODE DEPRN_METHOD_CODE, FA.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR, FA.BASIC_RATE BASIC_RATE, FA.ADJUSTED_RATE ADJUSTED_RATE, FA.RECOVERABLE_COST RECOVERABLE_COST, FA.ORG_ID ORG_ID, FA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FA.property_type_code PROPERTY_TYPE_CODE, FA.property_1245_1250_code PROPERTY_1245_1250_CODE, FA.in_use_flag IN_USE_FLAG, FA.owned_leased OWNED_LEASED, FA.inventorial INVENTORIAL, CLE.STS_CODE LINE_STATUS, KLE.YEAR_BUILT YEAR_BUILT FROM OKX_ASSETS_V FA,OKL_K_HEADERS KHR,OKL_K_LINES TOP_KLE,OKL_K_LINES KLE,OKC_K_LINES_B CLE,OKC_K_LINES_TL TL,OKC_LINE_STYLES_B LS,OKC_K_ITEMS CIM WHERE KHR.ID = CLE.DNZ_CHR_ID AND TOP_KLE.ID = CLE.CLE_ID AND KLE.ID = CLE.ID AND TL.ID = CLE.ID AND TL.LANGUAGE = USERENV('LANG') AND LS.ID = CLE.LSE_ID AND LS.LTY_CODE = 'FIXED_ASSET' AND CIM.DNZ_CHR_ID = CLE.DNZ_CHR_ID AND CIM.CLE_ID = CLE.ID AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET' AND FA.ID1 = CIM.OBJECT1_ID1 AND FA.ID2 = CIM.OBJECT1_ID2 AND CLE.STS_CODE <> 'ABANDONED'
SELECT CLE.ID ID1
, '#' ID2
, FA.NAME NAME
, FA.DESCRIPTION DESCRIPTION
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, TL.COMMENTS COMMENTS
, CLE.CHR_ID CHR_ID
, CLE.DNZ_CHR_ID DNZ_CHR_ID
, LS.LTY_CODE LTY_CODE
, LS.LSE_TYPE LSE_TYPE
, LS.LSE_PARENT_ID LSE_PARENT_ID
, CLE.CLE_ID PARENT_LINE_ID
, CLE.LINE_NUMBER LINE_NUMBER
, CLE.DATE_TERMINATED DATE_TERMINATED
, CLE.START_DATE START_DATE_ACTIVE
, CLE.END_DATE END_DATE_ACTIVE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(TRUNC(CLE.START_DATE)
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(TRUNC(CLE.END_DATE)
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, FA.ASSET_ID ASSET_ID
, FA.CURRENT_UNITS QUANTITY
, CIM.UOM_CODE UNIT_OF_MEASURE_CODE
, FA.ASSET_NUMBER ASSET_NUMBER
, FA.CORPORATE_BOOK CORPORATE_BOOK
, FA.LIFE_IN_MONTHS LIFE_IN_MONTHS
, TOP_KLE.OEC ORIGINAL_COST
, FA.COST COST
, FA.ADJUSTED_COST ADJUSTED_COST
, FA.TAG_NUMBER TAG_NUMBER
, FA.CURRENT_UNITS CURRENT_UNITS
, FA.SERIAL_NUMBER SERIAL_NUMBER
, FA.REVAL_CEILING REVAL_CEILING
, FA.NEW_USED NEW_USED
, FA.IN_SERVICE_DATE IN_SERVICE_DATE
, FA.MANUFACTURER_NAME MANUFACTURER_NAME
, FA.MODEL_NUMBER MODEL_NUMBER
, FA.ASSET_TYPE ASSET_TYPE
, FA.SALVAGE_VALUE SALVAGE_VALUE
, FA.PERCENT_SALVAGE_VALUE PERCENT_SALVAGE_VALUE
, FA.DEPRECIATION_CATEGORY DEPRECIATION_CATEGORY
, FA.DEPRN_START_DATE DEPRN_START_DATE
, FA.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, FA.RATE_ADJUSTMENT_FACTOR RATE_ADJUSTMENT_FACTOR
, FA.BASIC_RATE BASIC_RATE
, FA.ADJUSTED_RATE ADJUSTED_RATE
, FA.RECOVERABLE_COST RECOVERABLE_COST
, FA.ORG_ID ORG_ID
, FA.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FA.PROPERTY_TYPE_CODE PROPERTY_TYPE_CODE
, FA.PROPERTY_1245_1250_CODE PROPERTY_1245_1250_CODE
, FA.IN_USE_FLAG IN_USE_FLAG
, FA.OWNED_LEASED OWNED_LEASED
, FA.INVENTORIAL INVENTORIAL
, CLE.STS_CODE LINE_STATUS
, KLE.YEAR_BUILT YEAR_BUILT
FROM OKX_ASSETS_V FA
, OKL_K_HEADERS KHR
, OKL_K_LINES TOP_KLE
, OKL_K_LINES KLE
, OKC_K_LINES_B CLE
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LS
, OKC_K_ITEMS CIM
WHERE KHR.ID = CLE.DNZ_CHR_ID
AND TOP_KLE.ID = CLE.CLE_ID
AND KLE.ID = CLE.ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND LS.ID = CLE.LSE_ID
AND LS.LTY_CODE = 'FIXED_ASSET'
AND CIM.DNZ_CHR_ID = CLE.DNZ_CHR_ID
AND CIM.CLE_ID = CLE.ID
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND FA.ID1 = CIM.OBJECT1_ID1
AND FA.ID2 = CIM.OBJECT1_ID2
AND CLE.STS_CODE <> 'ABANDONED'
|
|
|
|