View: JAI_FA_ASSETS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_FA_ASSETS_V

View Text

SELECT FB.ROWID ROW_ID
, FB.BOOK_TYPE_CODE
, FA.ASSET_CATEGORY_ID
, FA.ASSET_TYPE
, FA.ASSET_ID
, FA.ASSET_NUMBER
, FB.COST
, FB.DATE_PLACED_IN_SERVICE
, TO_DATE(NULL) DATE_OF_ACQUISITION
, TO_NUMBER(NULL) BLOCK_ID
FROM FA_ADDITIONS_B FA
, FA_BOOKS FB
WHERE FA.ASSET_ID = FB.ASSET_ID
AND FB.TRANSACTION_HEADER_ID_OUT IS NULL
AND FA.ASSET_TYPE IN ('CAPITALIZED'
, 'EXPENSED')
AND NOT EXISTS ( SELECT 1
FROM JAI_FA_AST_BLOCK_DTLS
WHERE ASSET_ID = FA.ASSET_ID )

Columns