VIEW: APPS.FA_FIN_INQRY_COST_WEB_V

Source

View Text - Preformatted

SELECT BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN , BK.ASSET_ID , AD.ASSET_NUMBER , BK.BOOK_TYPE_CODE , LO.MEANING TRANSACTION_TYPE , DP.PERIOD_NAME PERIOD_ENTERED , TO_CHAR(BK.COST, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE,30)) CURRENT_COST , DP.PERIOD_NAME , DP.PERIOD_COUNTER , DP.PERIOD_OPEN_DATE , DP.PERIOD_CLOSE_DATE , DP.CALENDAR_PERIOD_OPEN_DATE , DP.CALENDAR_PERIOD_CLOSE_DATE , DP.FISCAL_YEAR , TH.TRANSACTION_TYPE_CODE , TH.TRANSACTION_DATE_ENTERED , TH.TRANSACTION_NAME , TH.DATE_EFFECTIVE , TH.TRANSACTION_KEY , GLSB.CURRENCY_CODE FROM FA_ADDITIONS_B AD, FA_DEPRN_PERIODS DP, FA_LOOKUPS LO, FA_BOOK_CONTROLS BC, GL_SETS_OF_BOOKS GLSB, FA_TRANSACTION_HEADERS TH, FA_BOOKS BKPREV, FA_BOOKS BK WHERE (BKPREV.TRANSACTION_HEADER_ID_OUT(+) = BK.TRANSACTION_HEADER_ID_IN AND NVL(BKPREV.COST,BK.COST-1) != BK.COST) AND (LO.LOOKUP_TYPE = 'FAXOLTRX' AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE) AND (TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE AND NVL(DP.PERIOD_CLOSE_DATE,SYSDATE) AND DP.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE) AND AD.ASSET_ID = BK.ASSET_ID AND TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID AND TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN

View Text - HTML Formatted

SELECT BK.TRANSACTION_HEADER_ID_IN TRANSACTION_HEADER_ID_IN
, BK.ASSET_ID
, AD.ASSET_NUMBER
, BK.BOOK_TYPE_CODE
, LO.MEANING TRANSACTION_TYPE
, DP.PERIOD_NAME PERIOD_ENTERED
, TO_CHAR(BK.COST
, FND_CURRENCY.SAFE_GET_FORMAT_MASK(GLSB.CURRENCY_CODE
, 30)) CURRENT_COST
, DP.PERIOD_NAME
, DP.PERIOD_COUNTER
, DP.PERIOD_OPEN_DATE
, DP.PERIOD_CLOSE_DATE
, DP.CALENDAR_PERIOD_OPEN_DATE
, DP.CALENDAR_PERIOD_CLOSE_DATE
, DP.FISCAL_YEAR
, TH.TRANSACTION_TYPE_CODE
, TH.TRANSACTION_DATE_ENTERED
, TH.TRANSACTION_NAME
, TH.DATE_EFFECTIVE
, TH.TRANSACTION_KEY
, GLSB.CURRENCY_CODE
FROM FA_ADDITIONS_B AD
, FA_DEPRN_PERIODS DP
, FA_LOOKUPS LO
, FA_BOOK_CONTROLS BC
, GL_SETS_OF_BOOKS GLSB
, FA_TRANSACTION_HEADERS TH
, FA_BOOKS BKPREV
, FA_BOOKS BK
WHERE (BKPREV.TRANSACTION_HEADER_ID_OUT(+) = BK.TRANSACTION_HEADER_ID_IN
AND NVL(BKPREV.COST
, BK.COST-1) != BK.COST)
AND (LO.LOOKUP_TYPE = 'FAXOLTRX'
AND LO.LOOKUP_CODE = TH.TRANSACTION_TYPE_CODE)
AND (TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, SYSDATE)
AND DP.BOOK_TYPE_CODE = TH.BOOK_TYPE_CODE)
AND AD.ASSET_ID = BK.ASSET_ID
AND TH.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.SET_OF_BOOKS_ID = GLSB.SET_OF_BOOKS_ID
AND TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_IN