APPS.FA_MASS_RET_PKG dependencies on FA_ADDITIONS_B

Line 1064: l_2nd_asset_number fa_additions_b.asset_number%TYPE;

1060: -- declare 2nd round of allocation
1061:
1062: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1063: l_2nd_asset_id number;
1064: l_2nd_asset_number fa_additions_b.asset_number%TYPE;
1065: l_2nd_cost_retired number;
1066: l_2nd_current_units number;
1067: l_2nd_dpis date;
1068: l_reason_code varchar2(30);

Line 1130: fa_additions_b faa

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

Line 3000: fa_additions_b faa

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
3003: OR G_Asset_Key_Id IS NULL)
3004: AND faa.asset_category_id = nvl(G_Category_Id,faa.asset_category_id)

Line 3153: FROM fa_additions_b

3149: SELECT asset_id,
3150: asset_number,
3151: parent_asset_id,
3152: current_units
3153: FROM fa_additions_b
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

Line 3159: fa_additions_b faa

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

Line 3193: FROM fa_additions_b faa2,

3189: AND fth.book_type_code = fab.book_type_code
3190: AND (fth.transaction_date_entered > G_Retirement_Date and
3191: fth.transaction_type_code not in ('FULL RETIREMENT','REINSTATEMENT')))
3192: AND faa.asset_id in (SELECT faa2.asset_id
3193: FROM fa_additions_b faa2,
3194: gl_code_combinations gcc,
3195: fa_distribution_history fad
3196: WHERE fad.asset_id = faa2.asset_id
3197: AND fad.code_combination_id = gcc.code_combination_id

Line 3300: FROM fa_additions_b faa,

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