DBA Data[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on FA_ASSET_INVOICES

Line 3198: FROM fa_asset_invoices

3194: SELECT DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,SUM(fixed_assets_cost),0)
3195: Material_cost ,
3196: DECODE(attribute15,cse_asset_util_pkg.G_MTL_INDICATOR,0,SUM(fixed_assets_cost))
3197: Non_Material_cost
3198: FROM fa_asset_invoices
3199: WHERE date_ineffective IS NULL
3200: AND asset_id = p_asset_query_rec.asset_id
3201: GROUP BY attribute15 ;
3202: