DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on QP_LIST_HEADERS_ALL

Line 672: qp_list_headers_all qpl

668: GROUP BY oov.name
669: UNION
670: SELECT NVL(qpl.description, qpl.name) offer_name
671: FROM ozf_activity_products oap,
672: qp_list_headers_all qpl
673: WHERE oap.OBJECT_TYPE IN('SCAN_DATA','LUMPSUM','NET_ACCRUAL','VOLUME_OFFER')
674: AND oap.ITEM = p_inventory_item_id
675: AND oap.object_id = qpl.list_header_id
676: AND g_trunc_sysdate between nvl(oap.start_date,g_trunc_sysdate) AND nvl(oap.end_date,g_trunc_sysdate)

Line 682: qp_list_headers_all qpl,

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