DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on AMS_ACT_PRODUCTS

Line 681: FROM ams_act_products oap,

677: AND oap.active_flag = 'Y'
678: GROUP BY NVL(qpl.description, qpl.name)
679: UNION
680: SELECT NVL(qpl.description, qpl.name) offer_name
681: FROM ams_act_products oap,
682: qp_list_headers_all qpl,
683: ozf_offers oo
684: WHERE oap.arc_act_product_used_by ='OFFR'
685: AND oap.inventory_item_id = p_inventory_item_id