DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on MTL_ITEM_CATEGORIES

Line 660: mtl_item_categories mic

656: UNION
657: SELECT oov.name offer_name
658: FROM ozf_offers_v oov,
659: qp_modifier_summary_v qmsv,
660: mtl_item_categories mic
661: WHERE qmsv.list_header_id = oov.list_header_id
662: AND g_trunc_sysdate between nvl(oov.start_date_active,g_trunc_sysdate) AND nvl(oov.end_date_active,g_trunc_sysdate)
663: AND product_attribute_context = 'ITEM'
664: AND qmsv.prod_attr_segment_name = 'PRODUCT_CATEGORY'