APPS.FA_MASS_RET_PKG dependencies on FA_BOOKS

Line 868: fa_books bk

864:
865: CURSOR check_processed_retirement is
866: select 'FA_REC_RETIRED'
867: from fa_retirements frt,
868: fa_books bk
869: where frt.asset_id = p_Asset_Id
870: AND bk.asset_id = frt.asset_id
871: AND bk.period_counter_fully_retired is NOT NULL
872: AND bk.transaction_header_id_in =

Line 997: from fa_books bk,

993: RETURN BOOLEAN IS
994:
995: CURSOR check_asset_life_complete IS
996: select 'EXTENDED LIFE'
997: from fa_books bk,
998: fa_deprn_periods dp
999: where bk.asset_id = X_Asset_Id
1000: AND bk.book_type_code = G_Book_Type_Code
1001: AND nvl(period_Counter_fully_reserved,99) <> bk.period_counter_life_complete

Line 1087: fa_books bk,

1083: mer.code_combination_id,
1084: mer.location_id,
1085: mer.assigned_to
1086: From fa_mass_ext_retirements mer,
1087: fa_books bk,
1088: fa_additions ad
1089: Where mer.batch_name = G_batch_name -- current batch
1090: And mer.asset_id = bk.asset_id
1091: And mer.book_type_code = bk.book_type_code

Line 1129: fa_books fab,

1125: fab.date_placed_in_service,
1126: fab.cost,
1127: faa.current_units
1128: FROM fa_book_controls fbc,
1129: fa_books fab,
1130: fa_additions_b faa
1131: WHERE faa.asset_id = fab.asset_id
1132: AND (faa.asset_key_ccid = G_Asset_Key_Id
1133: OR G_Asset_Key_Id IS NULL)

Line 2866: l_SC_Cost_Retired fa_books.cost%TYPE;

2862:
2863: -- Local Variables holding Asset Subcomponent Information
2864: l_SC_Asset_Id num_tbl;
2865: l_SC_Asset_Number v30_tbl;
2866: l_SC_Cost_Retired fa_books.cost%TYPE;
2867:
2868: -- used for bulk fetch
2869: l_batch_size NUMBER;
2870: l_loop_count NUMBER;

Line 2993: SELECT /* ORDERED INDEX (FAB FA_BOOKS_N2) */

2989: AND fbc.set_of_books_id = sob.set_of_books_id;
2990:
2991:
2992: CURSOR qual_ass_by_asset_number IS
2993: SELECT /* ORDERED INDEX (FAB FA_BOOKS_N2) */
2994: faa.asset_id,
2995: faa.asset_number,
2996: fab.cost,
2997: faa.current_units

Line 2998: FROM fa_books fab,

2994: faa.asset_id,
2995: faa.asset_number,
2996: fab.cost,
2997: faa.current_units
2998: FROM fa_books fab,
2999: fa_book_controls fbc,
3000: fa_additions_b faa
3001: WHERE faa.asset_id = fab.asset_id
3002: AND (faa.asset_key_ccid = G_Asset_Key_Id

Line 3137: -- YYOON 12/13/01: Performance Bug#2134816: Changed driving table from fa_books to fa_book_controls

3133: AND G_Segment30_High
3134: OR G_segment30_Low IS NULL))
3135: AND (faa.asset_type = G_Asset_Type OR G_Asset_Type IS NULL)
3136: AND faa.asset_type IN ('CIP','CAPITALIZED','EXPENSED')
3137: -- YYOON 12/13/01: Performance Bug#2134816: Changed driving table from fa_books to fa_book_controls
3138: AND fbc.book_type_code = G_Book_Type_Code
3139: --AND fab.date_ineffective IS NULL
3140: AND fab.TRANSACTION_HEADER_ID_OUT IS NULL --bug 8264324
3141: ORDER BY fab.date_placed_in_service, faa.asset_number;

Line 3158: FROM fa_books fab,

3154: WHERE parent_asset_id is not null
3155: AND parent_asset_id = p_parent_asset_id
3156: MINUS
3157: SELECT faa.asset_id, faa.asset_number, faa.parent_asset_id, faa.current_units
3158: FROM fa_books fab,
3159: fa_additions_b faa
3160: WHERE faa.parent_asset_id is not null
3161: AND faa.parent_asset_id = p_parent_asset_id
3162: AND faa.asset_id = fab.asset_id

Line 3301: fa_books fab

3297:
3298: CURSOR subcomponent_detail (p_asset_id NUMBER) IS
3299: SELECT fab.cost
3300: FROM fa_additions_b faa,
3301: fa_books fab
3302: WHERE faa.asset_id = fab.asset_id
3303: AND faa.asset_id = p_asset_id
3304: AND fab.period_counter_fully_retired IS NULL
3305: AND faa.asset_type IN ('CIP','CAPITALIZED','EXPENSED')

Line 3320: FROM fa_books fab1, fa_books fab2

3316: /* Bug 8647381 - Starts */
3317: -- Bug 9694294 : Changed date_ineffective to trx_hdr_id_out
3318: CURSOR c_recognize_gain_loss(p_asset_id NUMBER) IS
3319: SELECT fab2.recognize_gain_loss
3320: FROM fa_books fab1, fa_books fab2
3321: WHERE fab1.book_type_code = G_Book_Type_Code
3322: AND fab1.asset_id = p_asset_id
3323: AND fab1.transaction_header_id_out IS NULL
3324: AND fab2.asset_id = fab1.group_asset_id