APPS.FA_MASS_RET_PKG dependencies on FA_BOOKS

Line 881: fa_books bk

877:
878: CURSOR check_processed_retirement is
879: select 'FA_REC_RETIRED'
880: from fa_retirements frt,
881: fa_books bk
882: where frt.asset_id = p_Asset_Id
883: AND bk.asset_id = frt.asset_id
884: AND bk.period_counter_fully_retired is NOT NULL
885: AND bk.transaction_header_id_in =

Line 913: from FA_BOOKS fab,

909: */
910: /* Excluded due to SLA
911: CURSOR check_current_period_cap is
912: select 'FA_RET_CANT_RET_NONDEPRN'
913: from FA_BOOKS fab,
914: FA_DEPRN_PERIODS dp,
915: FA_TRANSACTION_HEADERS th
916: where
917: fab.transaction_header_id_in = th.transaction_header_id

Line 1025: from fa_books bk,

1021: RETURN BOOLEAN IS
1022:
1023: CURSOR check_asset_life_complete IS
1024: select 'EXTENDED LIFE'
1025: from fa_books bk,
1026: fa_deprn_periods dp
1027: where bk.asset_id = X_Asset_Id
1028: AND bk.book_type_code = G_Book_Type_Code
1029: AND nvl(period_Counter_fully_reserved,99) <> bk.period_counter_life_complete

Line 1116: fa_books bk,

1112: mer.code_combination_id,
1113: mer.location_id,
1114: mer.assigned_to
1115: From fa_mass_ext_retirements mer,
1116: fa_books bk,
1117: fa_additions ad
1118: Where mer.batch_name = G_batch_name -- current batch
1119: And mer.asset_id = bk.asset_id
1120: And mer.book_type_code = bk.book_type_code

Line 1158: fa_books fab,

1154: fab.date_placed_in_service,
1155: fab.cost,
1156: faa.current_units
1157: FROM fa_book_controls fbc,
1158: fa_books fab,
1159: fa_additions_b faa
1160: WHERE faa.asset_id = fab.asset_id
1161: AND (faa.asset_key_ccid = G_Asset_Key_Id
1162: OR G_Asset_Key_Id IS NULL)

Line 3036: l_SC_Cost_Retired fa_books.cost%TYPE;

3032:
3033: -- Local Variables holding Asset Subcomponent Information
3034: l_SC_Asset_Id num_tbl;
3035: l_SC_Asset_Number v30_tbl;
3036: l_SC_Cost_Retired fa_books.cost%TYPE;
3037:
3038: -- used for bulk fetch
3039: l_batch_size NUMBER;
3040: l_loop_count NUMBER;

Line 3169: fa_books fab,

3165: faa.asset_number,
3166: fab.cost,
3167: faa.current_units
3168: FROM fa_book_controls fbc,
3169: fa_books fab,
3170: fa_additions_b faa
3171: WHERE faa.asset_id = fab.asset_id
3172: AND (faa.asset_key_ccid = G_Asset_Key_Id
3173: OR G_Asset_Key_Id IS NULL)

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

3303: AND G_Segment30_High
3304: OR G_segment30_Low IS NULL))
3305: AND (faa.asset_type = G_Asset_Type OR G_Asset_Type IS NULL)
3306: AND faa.asset_type IN ('CIP','CAPITALIZED','EXPENSED')
3307: -- YYOON 12/13/01: Performance Bug#2134816: Changed driving table from fa_books to fa_book_controls
3308: AND fbc.book_type_code = G_Book_Type_Code
3309: AND fab.date_ineffective IS NULL
3310: ORDER BY fab.date_placed_in_service, faa.asset_number;
3311:

Line 3327: FROM fa_books fab,

3323: WHERE parent_asset_id is not null
3324: AND parent_asset_id = p_parent_asset_id
3325: MINUS
3326: SELECT faa.asset_id, faa.asset_number, faa.parent_asset_id, faa.current_units
3327: FROM fa_books fab,
3328: fa_additions_b faa
3329: WHERE faa.parent_asset_id is not null
3330: AND faa.parent_asset_id = p_parent_asset_id
3331: AND faa.asset_id = fab.asset_id

Line 3470: fa_books fab

3466:
3467: CURSOR subcomponent_detail (p_asset_id NUMBER) IS
3468: SELECT fab.cost
3469: FROM fa_additions_b faa,
3470: fa_books fab
3471: WHERE faa.asset_id = fab.asset_id
3472: AND faa.asset_id = p_asset_id
3473: AND fab.period_counter_fully_retired IS NULL
3474: AND faa.asset_type IN ('CIP','CAPITALIZED','EXPENSED')