DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on AMS_ACT_PRODUCTS

Line 700: FROM ams_act_products oap,

696: AND oap.active_flag = 'Y'
697: GROUP BY NVL(qpl.description, qpl.name)
698: UNION
699: SELECT NVL(qpl.description, qpl.name) offer_name
700: FROM ams_act_products oap,
701: qp_list_headers_all qpl,
702: ozf_offers oo
703: WHERE oap.arc_act_product_used_by ='OFFR'
704: AND oap.inventory_item_id = p_inventory_item_id