DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 1340: ,fa_massadd_distributions fmd

1336: SELECT SUM(NVL(fma.fixed_assets_cost,0)) cost ,
1337: SUM(fma.fixed_assets_units) total_units ,
1338: fma.mass_addition_id
1339: FROM fa_mass_additions fma
1340: ,fa_massadd_distributions fmd
1341: WHERE fmd.mass_addition_id = fma.mass_addition_id
1342: AND fma.posting_status = 'POST'
1343: AND fma.book_type_code = p_asset_query_rec.book_type_code
1344: AND fma.add_to_asset_id = p_asset_query_rec.asset_id

Line 1350: FROM fa_massadd_distributions

1346:
1347: CURSOR adj_units_cur (c_mass_addition_id IN NUMBER)
1348: IS
1349: SELECT units location_units
1350: FROM fa_massadd_distributions
1351: WHERE NVL(deprn_expense_ccid, -1)=
1352: NVL(p_asset_query_rec.deprn_expense_ccid,NVL(deprn_expense_ccid,-1))
1353: AND NVL(employee_id, -1)=
1354: NVL(p_asset_query_rec.employee_id,NVL(employee_id,-1))