VIEW: APPS.FA_FINANCIAL_INQUIRY_UPL_V

Source

View Text - Preformatted

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,fabc.set_of_books_id sob_id FROM FA_TRANSACTION_HEADERS TH, FA_ADJUSTMENTS AD, FA_LOOKUPS LU, FA_BOOK_CONTROLS FABC 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 IN ('ADJUSTMENT','GROUP ADJUSTMENT') AND TH.TRANSACTION_KEY IN ('U', 'UA', 'UE') AND FABC.book_type_code = th.book_type_code GROUP BY set_of_books_id,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 union all 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,ad.set_of_books_id FROM FA_TRANSACTION_HEADERS TH, FA_mc_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 IN ('ADJUSTMENT','GROUP ADJUSTMENT') AND TH.TRANSACTION_KEY IN ('U', 'UA', 'UE') GROUP BY ad.set_of_books_id,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

View Text - HTML Formatted

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
, FABC.SET_OF_BOOKS_ID SOB_ID
FROM FA_TRANSACTION_HEADERS TH
, FA_ADJUSTMENTS AD
, FA_LOOKUPS LU
, FA_BOOK_CONTROLS FABC
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 IN ('ADJUSTMENT'
, 'GROUP ADJUSTMENT')
AND TH.TRANSACTION_KEY IN ('U'
, 'UA'
, 'UE')
AND FABC.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE GROUP BY SET_OF_BOOKS_ID
, 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 UNION ALL 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
, AD.SET_OF_BOOKS_ID
FROM FA_TRANSACTION_HEADERS TH
, FA_MC_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 IN ('ADJUSTMENT'
, 'GROUP ADJUSTMENT')
AND TH.TRANSACTION_KEY IN ('U'
, 'UA'
, 'UE') GROUP BY AD.SET_OF_BOOKS_ID
, 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