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 647: qp_modifier_summary_v qmsv

643:
644: CURSOR get_offers_csr(p_inventory_item_id IN NUMBER) IS
645: SELECT oov.name offer_name
646: FROM ozf_offers_v oov,
647: qp_modifier_summary_v qmsv
648: WHERE qmsv.list_header_id = oov.list_header_id
649: AND g_trunc_sysdate between nvl(oov.start_date_active,g_trunc_sysdate) AND nvl(oov.end_date_active,g_trunc_sysdate)
650: AND g_trunc_sysdate between nvl(qmsv.start_date_active,g_trunc_sysdate) AND nvl(qmsv.end_date_active,g_trunc_sysdate)
651: AND product_attribute_context = 'ITEM'

Line 659: qp_modifier_summary_v qmsv,

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