FA Parent Asset - draft

SELECT
	P_AD.ASSET_NUMBER || ' - ' || P_AD.DESCRIPTION		PARENT_ASSET,
	P_AD.SERIAL_NUMBER					PARENT_SERIAL,
	P_BOOK.COST						PARENT_COST,
	C_AD.ASSET_NUMBER || ' - ' || C_AD.DESCRIPTION		CHILD_ASSET,
	C_AD.SERIAL_NUMBER					CHILD_SERIAL,
	C_BOOK.COST						CHILD_COST
FROM
	FA_BOOKS 		C_BOOK,
	FA_BOOKS		P_BOOK,
	FA_ADDITIONS 		C_AD,
	FA_ADDITIONS 		P_AD
WHERE
	C_AD.PARENT_ASSET_ID IS NOT NULL			
AND
	P_AD.ASSET_ID = C_AD.PARENT_ASSET_ID  			AND (
	P_AD.ASSET_NUMBER BETWEEN NVL(	
	 :P_FROM_ASSET, P_AD.ASSET_NUMBER ) AND
	NVL( :P_TO_ASSET, P_AD.ASSET_NUMBER))	
AND
	C_BOOK.ASSET_ID = C_AD.ASSET_ID		AND
	C_BOOK.BOOK_TYPE_CODE = :P_BOOK 	AND
	C_BOOK.TRANSACTION_HEADER_ID_OUT IS NULL and
	c_book.period_counter_fully_retired is null
AND
	P_BOOK.ASSET_ID = P_AD.ASSET_ID		AND
	P_BOOK.BOOK_TYPE_CODE = :P_BOOK 	AND
	P_BOOK.TRANSACTION_HEADER_ID_OUT IS NULL  and
	P_book.period_counter_fully_retired is null
ORDER BY
	P_AD.ASSET_NUMBER,
	C_AD.ASSET_NUMBER