View: FA_GROUP_COST_INQUIRY_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_GROUP_COST_INQUIRY_V

View Text

SELECT BG.TRANSACTION_HEADER_ID_IN
, BG.GROUP_ASSET_ID
, TR.ASSET_ID
, TO_CHAR(TR.ASSET_ID) ASSET_NUMBER
, TR.BOOK_TYPE_CODE
, TR.TRANSACTION_TYPE_CODE TRANSACTION_TYPE
, BG.PERIOD_COUNTER PERIOD_ENTERED
, BG.COST CURRENT_COST
, DP.PERIOD_NAME
FROM FA_TRANSACTION_HEADERS TR
, FA_BOOKS_GROUPS BG
, FA_DEPRN_PERIODS DP
WHERE BG.TRANSACTION_HEADER_ID_IN = TR.TRANSACTION_HEADER_ID
AND DP.PERIOD_COUNTER = BG.PERIOD_COUNTER
AND DP.BOOK_TYPE_CODE = BG.BOOK_TYPE_CODE

Columns