APPS.DPP_PRICING_PVT dependencies on OZF_OFFERS

Line 665: FROM ozf_offers_v oov,

661: l_offer_tbl DPP_PRICING_PVT.dpp_object_name_tbl_type;
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)

Line 677: FROM ozf_offers_v oov,

673: AND oov.active_flag = 'Y'
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)

Line 702: ozf_offers oo

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
705: AND oap.act_product_used_by_id = qpl.list_header_id
706: AND oap.enabled_flag = 'Y'