eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DPP_PRICING_PVT dependencies on QP_MODIFIER_SUMMARY_V

Line 666: qp_modifier_summary_v qmsv

662:
663: CURSOR get_offers_csr(p_inventory_item_id IN NUMBER) IS
664: SELECT oov.name offer_name
665: FROM ozf_offers_v oov,
666: qp_modifier_summary_v qmsv
667: WHERE qmsv.list_header_id = oov.list_header_id
668: AND g_trunc_sysdate between nvl(oov.start_date_active,g_trunc_sysdate) AND nvl(oov.end_date_active,g_trunc_sysdate)
669: AND g_trunc_sysdate between nvl(qmsv.start_date_active,g_trunc_sysdate) AND nvl(qmsv.end_date_active,g_trunc_sysdate)
670: AND product_attribute_context = 'ITEM'

Line 678: qp_modifier_summary_v qmsv,

674: GROUP BY oov.name
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'