eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_BOOKS

Line 151: fa_books ab,

147: dr.deprn_reserve,
148: ab.date_placed_in_service
149: FROM jl_co_fa_asset_apprs ap,
150: fa_additions ad,
151: fa_books ab,
152: fa_deprn_summary dr
153: WHERE ap.asset_number = ad.asset_number
154: AND ap.appraisal_id = p_appr_id
155: AND ad.asset_id = ab.asset_id

Line 1237: fnd_file.put_line( 1, 'Updating FA_BOOKS');

1233: -- Update fa_book for each asset --
1234: ---------------------------------------------------------
1235:
1236: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1237: fnd_file.put_line( 1, 'Updating FA_BOOKS');
1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating FA_BOOKS');
1239: END IF;
1240:
1241: UPDATE fa_books SET

Line 1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating FA_BOOKS');

1234: ---------------------------------------------------------
1235:
1236: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1237: fnd_file.put_line( 1, 'Updating FA_BOOKS');
1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating FA_BOOKS');
1239: END IF;
1240:
1241: UPDATE fa_books SET
1242: global_attribute2 = fnd_number.number_to_canonical(x_appr_revaluation),

Line 1241: UPDATE fa_books SET

1237: fnd_file.put_line( 1, 'Updating FA_BOOKS');
1238: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updating FA_BOOKS');
1239: END IF;
1240:
1241: UPDATE fa_books SET
1242: global_attribute2 = fnd_number.number_to_canonical(x_appr_revaluation),
1243: global_attribute3 = fnd_number.number_to_canonical(x_prev_revaluation),
1244: global_attribute4 = rec_appraisal.appraisal_id,
1245: global_attribute5 = fnd_date.date_to_canonical(rec_appraisal.appraisal_date),

Line 1256: fnd_file.put_line( 1, 'Updated FA_BOOKS');

1252: AND transaction_header_id_out IS NULL
1253: AND date_ineffective IS NULL ;
1254:
1255: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1256: fnd_file.put_line( 1, 'Updated FA_BOOKS');
1257: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated FA_BOOKS');
1258: END IF;
1259:
1260: ---------------------------------------------------------

Line 1257: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated FA_BOOKS');

1253: AND date_ineffective IS NULL ;
1254:
1255: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1256: fnd_file.put_line( 1, 'Updated FA_BOOKS');
1257: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Updated FA_BOOKS');
1258: END IF;
1259:
1260: ---------------------------------------------------------
1261: -- Initialize parameters to zero --

Line 1730: fa_books ab

1726: WHERE appraisal_id = p_appraisal_id
1727: AND asset_number NOT IN (SELECT ap.asset_number
1728: FROM jl_co_fa_asset_apprs ap,
1729: fa_additions ad,
1730: fa_books ab
1731: WHERE ap.asset_number = ad.asset_number
1732: AND ap.appraisal_id = p_appraisal_id
1733: AND ad.asset_id = ab.asset_id
1734: AND ab.book_type_code = p_book_type_code