APPS.OZF_FUND_UTILIZED_PVT dependencies on AMS_ACT_PRODUCTS

Line 3859: FROM ams_act_products

3855: FROM
3856: (SELECT activity_product_id,level_type_code level_code,
3857: DECODE (level_type_code, 'PRODUCT', inventory_item_id, category_id) product_id
3858: ,scan_value,channel_id
3859: FROM ams_act_products
3860: WHERE act_product_used_by_id = p_offer_id
3861: AND arc_act_product_used_by = 'OFFR'
3862: ) act
3863: WHERE act.level_code = p_product_type