VIEW: APPS.OKL_LKE_REQ_ASSET_UV

Source

View Text - Preformatted

SELECT FAD.ASSET_ID REQ_ASSET_ID, FAD.ASSET_NUMBER REQ_ASSET_NUMBER, FAB.BOOK_TYPE_CODE BOOK_TYPE_CODE, FAD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID, FAB.ORIGINAL_COST ORIGINAL_COST, FAR.DATE_RETIRED DATE_RETIRED, FAR.PROCEEDS_OF_SALE PROCEEDS_OF_SALE, FAR.GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT, NVL(OKL_LIKE_KIND_EXCHANGE_PVT.GET_BALANCE_SALE_PROCEEDS(FAD.ASSET_ID, FAB.BOOK_TYPE_CODE), FAR.PROCEEDS_OF_SALE) BALANCE_SALE_PROCEEDS, NVL(OKL_LIKE_KIND_EXCHANGE_PVT.GET_DEFERRED_GAIN(FAD.ASSET_ID, FAB.BOOK_TYPE_CODE), FAR.GAIN_LOSS_AMOUNT) BALANCE_GAIN_LOSS, 0 MATCH_AMOUNT FROM FA_BOOKS FAB,FA_ADDITIONS_B FAD,FA_BOOK_CONTROLS FBC,FA_RETIREMENTS FAR,OKC_K_ITEMS CIM,OKC_K_LINES_B FA_LINE,OKC_LINE_STYLES_B FA_LSE,OKL_ASSET_RETURNS_ALL_B OKLAR,OKL_SYS_ACCT_OPTS OKLSYS WHERE FBC.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE AND FBC.BOOK_CLASS = 'TAX' AND NVL(FBC.DATE_INEFFECTIVE,SYSDATE+1) > SYSDATE AND FAB.ASSET_ID = FAD.ASSET_ID AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL AND FAD.ASSET_ID = FAR.ASSET_ID AND FAR.STATUS = 'PROCESSED' AND FAB.BOOK_TYPE_CODE = FAR.BOOK_TYPE_CODE AND CIM.OBJECT1_ID1 = TO_CHAR(FAR.ASSET_ID) AND CIM.OBJECT1_ID2 = '#' AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET' AND CIM.CLE_ID = FA_LINE.ID AND CIM.DNZ_CHR_ID = FA_LINE.DNZ_CHR_ID AND FA_LINE.LSE_ID = FA_LSE.ID AND FA_LSE.LTY_CODE = 'FIXED_ASSET' AND FA_LINE.CLE_ID = OKLAR.KLE_ID AND OKLAR.LIKE_KIND_YN = 'Y' AND FAR.DATE_RETIRED BETWEEN (SYSDATE-OKLSYS.LKE_HOLD_DAYS) AND SYSDATE

View Text - HTML Formatted

SELECT FAD.ASSET_ID REQ_ASSET_ID
, FAD.ASSET_NUMBER REQ_ASSET_NUMBER
, FAB.BOOK_TYPE_CODE BOOK_TYPE_CODE
, FAD.ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, FAB.ORIGINAL_COST ORIGINAL_COST
, FAR.DATE_RETIRED DATE_RETIRED
, FAR.PROCEEDS_OF_SALE PROCEEDS_OF_SALE
, FAR.GAIN_LOSS_AMOUNT GAIN_LOSS_AMOUNT
, NVL(OKL_LIKE_KIND_EXCHANGE_PVT.GET_BALANCE_SALE_PROCEEDS(FAD.ASSET_ID
, FAB.BOOK_TYPE_CODE)
, FAR.PROCEEDS_OF_SALE) BALANCE_SALE_PROCEEDS
, NVL(OKL_LIKE_KIND_EXCHANGE_PVT.GET_DEFERRED_GAIN(FAD.ASSET_ID
, FAB.BOOK_TYPE_CODE)
, FAR.GAIN_LOSS_AMOUNT) BALANCE_GAIN_LOSS
, 0 MATCH_AMOUNT
FROM FA_BOOKS FAB
, FA_ADDITIONS_B FAD
, FA_BOOK_CONTROLS FBC
, FA_RETIREMENTS FAR
, OKC_K_ITEMS CIM
, OKC_K_LINES_B FA_LINE
, OKC_LINE_STYLES_B FA_LSE
, OKL_ASSET_RETURNS_ALL_B OKLAR
, OKL_SYS_ACCT_OPTS OKLSYS
WHERE FBC.BOOK_TYPE_CODE = FAB.BOOK_TYPE_CODE
AND FBC.BOOK_CLASS = 'TAX'
AND NVL(FBC.DATE_INEFFECTIVE
, SYSDATE+1) > SYSDATE
AND FAB.ASSET_ID = FAD.ASSET_ID
AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FAD.ASSET_ID = FAR.ASSET_ID
AND FAR.STATUS = 'PROCESSED'
AND FAB.BOOK_TYPE_CODE = FAR.BOOK_TYPE_CODE
AND CIM.OBJECT1_ID1 = TO_CHAR(FAR.ASSET_ID)
AND CIM.OBJECT1_ID2 = '#'
AND CIM.JTOT_OBJECT1_CODE = 'OKX_ASSET'
AND CIM.CLE_ID = FA_LINE.ID
AND CIM.DNZ_CHR_ID = FA_LINE.DNZ_CHR_ID
AND FA_LINE.LSE_ID = FA_LSE.ID
AND FA_LSE.LTY_CODE = 'FIXED_ASSET'
AND FA_LINE.CLE_ID = OKLAR.KLE_ID
AND OKLAR.LIKE_KIND_YN = 'Y'
AND FAR.DATE_RETIRED BETWEEN (SYSDATE-OKLSYS.LKE_HOLD_DAYS)
AND SYSDATE