APPS.DPP_PRICING_PVT dependencies on OZF_OFFERS

Line 646: FROM ozf_offers_v oov,

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

Line 658: FROM ozf_offers_v oov,

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

Line 683: ozf_offers oo

679: UNION
680: SELECT NVL(qpl.description, qpl.name) offer_name
681: FROM ams_act_products oap,
682: qp_list_headers_all qpl,
683: ozf_offers oo
684: WHERE oap.arc_act_product_used_by ='OFFR'
685: AND oap.inventory_item_id = p_inventory_item_id
686: AND oap.act_product_used_by_id = qpl.list_header_id
687: AND oap.enabled_flag = 'Y'