APPS.OZF_FUND_UTILIZED_PVT dependencies on AMS_ACT_PRODUCTS

Line 4354: FROM ams_act_products

4350: FROM
4351: (SELECT activity_product_id,level_type_code level_code,
4352: DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
4353: ,scan_value,channel_id
4354: FROM ams_act_products
4355: WHERE act_product_used_by_id = p_offer_id
4356: AND arc_act_product_used_by = 'OFFR'
4357: ) act
4358: WHERE act.level_code = p_product_type