VIEW: APPS.OKL_AM_SALVAGE_VALUE_WD_UV

Source

View Text - Preformatted

SELECT CLE.ID KLE_ID, TL.NAME NAME, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION, CLE.STS_CODE LINE_STS_CODE, CLE.CHR_ID CHR_ID, CLE.START_DATE START_DATE, CLE.END_DATE END_DATE, DECODE(SIGN(trunc(sysdate)-NVL(CLE.start_date,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate)-NVL(CLE.end_date,trunc(sysdate))), 1,'I','A')) STATUS, FA.ASSET_ID ASSET_ID, FA.CURRENT_UNITS QUANTITY, FA.ASSET_NUMBER FIXED_ASSET_NUMBER, FA.CORPORATE_BOOK CORPORATE_BOOK, FABKC.BOOK_TYPE_NAME CORPORATE_BOOK_NAME, FA.LIFE_IN_MONTHS LIFE_IN_MONTHS, FA.ORIGINAL_COST ORIGINAL_COST, FA.COST COST, FA.ADJUSTED_COST ADJUSTED_COST, FA.CURRENT_UNITS CURRENT_UNITS, FA.SERIAL_NUMBER SERIAL_NUMBER, FA.NEW_USED NEW_USED, FA.IN_SERVICE_DATE IN_SERVICE_DATE, FA.SALVAGE_VALUE SALVAGE_VALUE, FA.DEPRECIATION_CATEGORY CATEGORY_ID, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION, FA.DEPRN_START_DATE DEPRN_START_DATE, FA.DEPRN_METHOD_CODE DEPRN_METHOD_CODE, KHR.ID KHR_ID, KHR.CONTRACT_NUMBER CONTRACT_NUMBER, KHR.STS_CODE CONTRACT_STS_CODE, PDT.ID PDT_ID, PDT.NAME PRODUCT_NAME, KHR.AUTHORING_ORG_ID ORG_ID FROM OKX_ASSETS_V FA,OKC_K_LINES_B CLE,OKC_K_LINES_B ASSET_CLE,OKC_K_LINES_TL TL,OKC_LINE_STYLES_B LS,OKC_K_ITEMS CIM,FA_CATEGORIES_VL FACAT,FA_BOOK_CONTROLS FABKC,OKL_K_HEADERS_FULL_V KHR,OKL_PRODUCTS_V PDT WHERE CLE.ID = ASSET_CLE.CLE_ID AND TL.ID = CLE.ID AND TL.LANGUAGE = USERENV('LANG') AND LS.ID = ASSET_CLE.LSE_ID AND LS.LTY_CODE = 'FIXED_ASSET' AND CIM.CLE_ID = ASSET_CLE.ID AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET' AND FA.ID1 = CIM.OBJECT1_ID1 AND FA.ID2 = CIM.OBJECT1_ID2 AND FA.CORPORATE_BOOK = FABKC.BOOK_TYPE_CODE (+) AND FA.DEPRECIATION_CATEGORY = FACAT.CATEGORY_ID (+) AND CLE.CHR_ID = KHR.ID AND KHR.PDT_ID = PDT.ID (+) AND FA.SALVAGE_VALUE > 0

View Text - HTML Formatted

SELECT CLE.ID KLE_ID
, TL.NAME NAME
, TL.ITEM_DESCRIPTION ITEM_DESCRIPTION
, CLE.STS_CODE LINE_STS_CODE
, CLE.CHR_ID CHR_ID
, CLE.START_DATE START_DATE
, CLE.END_DATE END_DATE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CLE.START_DATE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CLE.END_DATE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, FA.ASSET_ID ASSET_ID
, FA.CURRENT_UNITS QUANTITY
, FA.ASSET_NUMBER FIXED_ASSET_NUMBER
, FA.CORPORATE_BOOK CORPORATE_BOOK
, FABKC.BOOK_TYPE_NAME CORPORATE_BOOK_NAME
, FA.LIFE_IN_MONTHS LIFE_IN_MONTHS
, FA.ORIGINAL_COST ORIGINAL_COST
, FA.COST COST
, FA.ADJUSTED_COST ADJUSTED_COST
, FA.CURRENT_UNITS CURRENT_UNITS
, FA.SERIAL_NUMBER SERIAL_NUMBER
, FA.NEW_USED NEW_USED
, FA.IN_SERVICE_DATE IN_SERVICE_DATE
, FA.SALVAGE_VALUE SALVAGE_VALUE
, FA.DEPRECIATION_CATEGORY CATEGORY_ID
, FACAT.DESCRIPTION FA_CATEGORY_DESCRIPTION
, FA.DEPRN_START_DATE DEPRN_START_DATE
, FA.DEPRN_METHOD_CODE DEPRN_METHOD_CODE
, KHR.ID KHR_ID
, KHR.CONTRACT_NUMBER CONTRACT_NUMBER
, KHR.STS_CODE CONTRACT_STS_CODE
, PDT.ID PDT_ID
, PDT.NAME PRODUCT_NAME
, KHR.AUTHORING_ORG_ID ORG_ID
FROM OKX_ASSETS_V FA
, OKC_K_LINES_B CLE
, OKC_K_LINES_B ASSET_CLE
, OKC_K_LINES_TL TL
, OKC_LINE_STYLES_B LS
, OKC_K_ITEMS CIM
, FA_CATEGORIES_VL FACAT
, FA_BOOK_CONTROLS FABKC
, OKL_K_HEADERS_FULL_V KHR
, OKL_PRODUCTS_V PDT
WHERE CLE.ID = ASSET_CLE.CLE_ID
AND TL.ID = CLE.ID
AND TL.LANGUAGE = USERENV('LANG')
AND LS.ID = ASSET_CLE.LSE_ID
AND LS.LTY_CODE = 'FIXED_ASSET'
AND CIM.CLE_ID = ASSET_CLE.ID
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND FA.ID1 = CIM.OBJECT1_ID1
AND FA.ID2 = CIM.OBJECT1_ID2
AND FA.CORPORATE_BOOK = FABKC.BOOK_TYPE_CODE (+)
AND FA.DEPRECIATION_CATEGORY = FACAT.CATEGORY_ID (+)
AND CLE.CHR_ID = KHR.ID
AND KHR.PDT_ID = PDT.ID (+)
AND FA.SALVAGE_VALUE > 0