[Home] [Help]
View: FA_FINANCIAL_INQUIRY_UPL_V
View Text
SELECT TH.TRANSACTION_HEADER_ID TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE BOOK_TYPE_CODE
, TH.ASSET_ID ASSET_ID
, TH.TRANSACTION_TYPE_CODE TRANSACTION_TYPE_CODE
, TH.TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
, LU.MEANING MEANING
, AD.CODE_COMBINATION_ID CODE_COMBINATION_ID
, NVL( SUM(DECODE(AD.ADJUSTMENT_TYPE
, 'EXPENSE'
, DECODE(AD.DEBIT_CREDIT_FLAG
, 'DR'
, AD.ADJUSTMENT_AMOUNT
, 'CR'
, -1 * AD.ADJUSTMENT_AMOUNT)))
, 0) ADJUSTMENT_AMOUNT
FROM FA_TRANSACTION_HEADERS TH
, FA_ADJUSTMENTS AD
, FA_LOOKUPS LU
WHERE LU.LOOKUP_TYPE(+)='UNPLANNED DEPRN'
AND TH.TRANSACTION_SUBTYPE=LU.LOOKUP_CODE(+)
AND TH.TRANSACTION_HEADER_ID=AD.TRANSACTION_HEADER_ID
AND TH.TRANSACTION_TYPE_CODE='ADJUSTMENT'
AND TH.TRANSACTION_KEY IN ('U'
, 'UA'
, 'UE') GROUP BY TH.TRANSACTION_HEADER_ID
, TH.BOOK_TYPE_CODE
, TH.ASSET_ID
, TH.TRANSACTION_TYPE_CODE
, TH.SOURCE_TRANSACTION_HEADER_ID
, TH.TRANSACTION_SUBTYPE
, LU.MEANING
, AD.CODE_COMBINATION_ID
Columns
Name |
TRANSACTION_HEADER_ID |
BOOK_TYPE_CODE |
ASSET_ID |
TRANSACTION_TYPE_CODE |
TRANSACTION_SUBTYPE |
MEANING |
CODE_COMBINATION_ID |
ADJUSTMENT_AMOUNT |