View: FA_LIFES_V

View Text

SELECT 'NODE' SRC_TYPE
, A.ASSET_HIERARCHY_ID SRC_ID
, A.LEVEL_NUMBER
, B.BOOK_TYPE_CODE
, B.LIFE_END_DATE
, 0 LIFE_IN_MONTHS
, A.PARENT_HIERARCHY_ID
FROM FA_ASSET_HIERARCHY A
, FA_ASSET_HIERARCHY_VALUES B
WHERE B.ASSET_HIERARCHY_ID = A.ASSET_HIERARCHY_ID UNION SELECT 'LEASE' SRC_TYPE
, LEASE_ID --SRC_ID
, 0 --LEVEL_NUMBER
, NULL --BOOK_TYPE_CODE
, FLP.END_DATE -- LIFE_END_DATE
, 0
, 0
FROM FA_LEASE_PAYMENTS FLP
, FA_LEASES FL
WHERE FL.PAYMENT_SCHEDULE_ID = FLP.PAYMENT_SCHEDULE_ID UNION SELECT 'ASSET'
, ASSET_ID
, 0 LEVEL_NUMBER
, BOOK_TYPE_CODE
, PRORATE_DATE --
, FA_CUA_MASS_UPDATE1_PKG.GET_END_DATE( BOOK_TYPE_CODE
, PRORATE_DATE
, LIFE_IN_MONTHS) LIFE_END_DATE
, LIFE_IN_MONTHS
, 0
FROM FA_BOOKS
WHERE DATE_INEFFECTIVE IS NULL UNION SELECT 'CATEGORY'
, CATEGORY_ID
, 0 --LEVEL_NUMBER
, BOOK_TYPE_CODE
, IFA_LIFE_END_DATE
, LIFE_IN_MONTHS
, 0
FROM FA_CATEGORY_BOOK_DEFAULTS
WHERE (TRUNC(SYSDATE) BETWEEN START_DPIS
AND NVL(END_DPIS
, TRUNC(SYSDATE) ) )

Columns