[Home] [Help]
View: 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
Name |
TRANSACTION_HEADER_ID_IN |
GROUP_ASSET_ID |
ASSET_ID |
ASSET_NUMBER |
BOOK_TYPE_CODE |
TRANSACTION_TYPE |
PERIOD_ENTERED |
CURRENT_COST |
PERIOD_NAME |