FA Financial Adjustments - draft

SELECT AD.ASSET_NUMBER                   	ASSET_NO,
      TH.TRANSACTION_HEADER_ID            	THID,
       LU_SUB.MEANING	                	TYPE,
       DECODE (TH.TRANSACTION_HEADER_ID,
               BK.TRANSACTION_HEADER_ID_OUT,
               0, 1) 	                  	FROM_TO,
       BK.DEPRN_METHOD_CODE                 	METHOD,
	BK.LIFE_IN_MONTHS			LIFE,
	BK.ADJUSTED_RATE			ADJUSTED_RATE,
	NVL(DS.BONUS_RATE, 0)			BONUS_RATE,
	BK.PRODUCTION_CAPACITY			PRODUCTION,
       BK.BONUS_RULE                      	BONUS_RULE,
       BK.CEILING_NAME                   	CEIL_NAME,
       BK.SALVAGE_VALUE                   	SAL_VAL,
       BK.COST                            	COST,
       LU.MEANING                         	DEPR, 
	FA_FASFIADJ_XMLP_PKG.d_lifeformula(BK.LIFE_IN_MONTHS, BK.ADJUSTED_RATE, NVL(DS.BONUS_RATE, 0), BK.PRODUCTION_CAPACITY) D_LIFE
	--COMMENTED AS THE QUERY IS REPEATED
/* FROM_TO,
       BK.DEPRN_METHOD_CODE                 	METHOD,
	BK.LIFE_IN_MONTHS			LIFE,
	BK.ADJUSTED_RATE			ADJUSTED_RATE,
	NVL(DS.BONUS_RATE, 0)			BONUS_RATE,
	BK.PRODUCTION_CAPACITY			PRODUCTION,
       BK.BONUS_RULE                      	BONUS_RULE,
       BK.CEILING_NAME                   	CEIL_NAME,
       BK.SALVAGE_VALUE                   	SAL_VAL,
       BK.COST                            	COST,
       LU.MEANING                         	DEPR */
FROM
       FA_ADDITIONS           AD,
       FA_BOOKS               BK,
       FA_LOOKUPS             LU,
	FA_LOOKUPS		LU_SUB,
       FA_TRANSACTION_HEADERS TH,
       FA_DEPRN_SUMMARY       DS
WHERE
       TH.DATE_EFFECTIVE BETWEEN :PERIOD1_POD AND 
	   :PERIOD1_PCD AND 
	   TH.BOOK_TYPE_CODE = :P_BOOK AND
	   TH.TRANSACTION_TYPE_CODE = 'ADJUSTMENT'
AND
	LU_SUB.LOOKUP_TYPE = 'TRANSACTION SUBTYPE' AND
	LU_SUB.LOOKUP_CODE = NVL(TH.TRANSACTION_SUBTYPE,'EXPENSED')
AND
       AD.ASSET_ID              = TH.ASSET_ID
AND
       TH.TRANSACTION_HEADER_ID IN (BK.TRANSACTION_HEADER_ID_IN,
                     BK.TRANSACTION_HEADER_ID_OUT)
AND
	BK.BOOK_TYPE_CODE =:P_BOOK AND
	BK.ASSET_ID = TH.ASSET_ID
AND
       LU.LOOKUP_TYPE           = 'YESNO'          AND
       LU.LOOKUP_CODE           = BK.DEPRECIATE_FLAG
AND
       DS.BOOK_TYPE_CODE(+) = :P_BOOK AND
	   DS.ASSET_ID(+)              = TH.ASSET_ID      AND
       DS.PERIOD_COUNTER(+) = :PERIOD1_PC
	   ORDER BY 1,2,3,4