VIEW: APPS.JAI_FA_ASSETS_V

Source

View Text - Preformatted

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 )

View Text - HTML Formatted

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 )