DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on QP_LIST_HEADERS_ALL

Line 691: qp_list_headers_all qpl

687: GROUP BY oov.name
688: UNION
689: SELECT NVL(qpl.description, qpl.name) offer_name
690: FROM ozf_activity_products oap,
691: qp_list_headers_all qpl
692: WHERE oap.OBJECT_TYPE IN('SCAN_DATA','LUMPSUM','NET_ACCRUAL','VOLUME_OFFER')
693: AND oap.ITEM = p_inventory_item_id
694: AND oap.object_id = qpl.list_header_id
695: AND g_trunc_sysdate between nvl(oap.start_date,g_trunc_sysdate) AND nvl(oap.end_date,g_trunc_sysdate)

Line 701: qp_list_headers_all qpl,

697: GROUP BY NVL(qpl.description, qpl.name)
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