DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on MTL_ITEM_CATEGORIES

Line 679: mtl_item_categories mic

675: UNION
676: SELECT oov.name offer_name
677: FROM ozf_offers_v oov,
678: qp_modifier_summary_v qmsv,
679: mtl_item_categories mic
680: WHERE qmsv.list_header_id = oov.list_header_id
681: AND g_trunc_sysdate between nvl(oov.start_date_active,g_trunc_sysdate) AND nvl(oov.end_date_active,g_trunc_sysdate)
682: AND product_attribute_context = 'ITEM'
683: AND qmsv.prod_attr_segment_name = 'PRODUCT_CATEGORY'