eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on FA_MASSADD_DISTRIBUTIONS

Line 1465: ,fa_massadd_distributions fmd

1461: SELECT SUM(NVL(fma.fixed_assets_cost,0)) cost ,
1462: SUM(fma.fixed_assets_units) total_units ,
1463: fma.mass_addition_id
1464: FROM fa_mass_additions fma
1465: ,fa_massadd_distributions fmd
1466: WHERE fmd.mass_addition_id = fma.mass_addition_id
1467: AND fma.posting_status = 'POST'
1468: AND fma.book_type_code = p_asset_query_rec.book_type_code
1469: AND fma.add_to_asset_id = p_asset_query_rec.asset_id

Line 1475: FROM fa_massadd_distributions

1471:
1472: CURSOR adj_units_cur (c_mass_addition_id IN NUMBER)
1473: IS
1474: SELECT units location_units
1475: FROM fa_massadd_distributions
1476: WHERE NVL(deprn_expense_ccid, -1)=
1477: NVL(p_asset_query_rec.deprn_expense_ccid,NVL(deprn_expense_ccid,-1))
1478: AND NVL(employee_id, -1)=
1479: NVL(p_asset_query_rec.employee_id,NVL(employee_id,-1))