APPS.FA_MASS_RET_PKG dependencies on FA_ADDITIONS_B

Line 1093: l_2nd_asset_number fa_additions_b.asset_number%TYPE;

1089: -- declare 2nd round of allocation
1090:
1091: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1092: l_2nd_asset_id number;
1093: l_2nd_asset_number fa_additions_b.asset_number%TYPE;
1094: l_2nd_cost_retired number;
1095: l_2nd_current_units number;
1096: l_2nd_dpis date;
1097: l_reason_code varchar2(30);

Line 1159: fa_additions_b faa

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)
1163: AND faa.asset_category_id = nvl(G_Category_Id,faa.asset_category_id)

Line 3170: fa_additions_b faa

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)
3174: AND faa.asset_category_id = nvl(G_Category_Id,faa.asset_category_id)

Line 3322: FROM fa_additions_b

3318: SELECT asset_id,
3319: asset_number,
3320: parent_asset_id,
3321: current_units
3322: FROM fa_additions_b
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

Line 3328: fa_additions_b faa

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
3332: AND (faa.asset_key_ccid = G_Asset_Key_Id OR G_Asset_Key_Id IS NULL)

Line 3362: FROM fa_additions_b faa2,

3358: AND fth.book_type_code = fab.book_type_code
3359: AND (fth.transaction_date_entered > G_Retirement_Date and
3360: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))
3361: AND faa.asset_id in (SELECT faa2.asset_id
3362: FROM fa_additions_b faa2,
3363: gl_code_combinations gcc,
3364: fa_distribution_history fad
3365: WHERE fad.asset_id = faa2.asset_id
3366: AND fad.code_combination_id = gcc.code_combination_id

Line 3469: FROM fa_additions_b faa,

3465: AND fab.date_ineffective IS NULL;
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