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.FA_ASSET_VAL_PVT dependencies on FA_ADDITIONS

Line 280: from fa_additions_b

276:
277: -- Asset number must be unique.
278: select count(*)
279: into l_count
280: from fa_additions_b
281: where asset_number = upper(p_asset_number);
282:
283: if (l_count > 0) then
284: fa_srvr_msg.add_message(

Line 2212: -- Make sure that tag_number does not already exist in fa_additions.

2208: BEGIN
2209:
2210: if (p_tag_number is not null) then
2211:
2212: -- Make sure that tag_number does not already exist in fa_additions.
2213: select count(*)
2214: into l_tag_number_count
2215: from fa_additions_b
2216: where tag_number = p_tag_number;

Line 2215: from fa_additions_b

2211:
2212: -- Make sure that tag_number does not already exist in fa_additions.
2213: select count(*)
2214: into l_tag_number_count
2215: from fa_additions_b
2216: where tag_number = p_tag_number;
2217:
2218: if (l_tag_number_count > 0) then
2219: fa_srvr_msg.add_message(

Line 2545: from fa_additions

2541: BEGIN
2542:
2543: select count(*)
2544: into l_count
2545: from fa_additions
2546: where asset_id = p_asset_id
2547: and rownum < 2;
2548:
2549: if (l_count <> 0) then

Line 2840: from fa_additions_b

2836: CURSOR get_cat_type IS
2837: select category_type
2838: from fa_categories_b
2839: where category_id = ( select asset_category_id
2840: from fa_additions_b
2841: where asset_id = p_asset_id );
2842: CURSOR C1 IS
2843: select currency_code
2844: from gl_sets_of_books sob,