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.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on QP_MODIFIER_SUMMARY_V

Line 2046: FROM qp_modifier_summary_v

2042: IS
2043:
2044: CURSOR c_list_lines IS
2045: SELECT DISTINCT list_line_id
2046: FROM qp_modifier_summary_v
2047: WHERE list_header_id = p_list_header_id
2048: AND list_line_id = NVL(p_lline_id , list_line_id)
2049: AND (end_date_active IS NULL
2050: OR end_date_active >= SYSDATE);

Line 2074: FROM qp_modifier_summary_v

2070: WHERE offer_id = p_list_header_id;
2071:
2072: CURSOR c_no_products IS
2073: SELECT COUNT(DISTINCT list_line_id)
2074: FROM qp_modifier_summary_v
2075: WHERE list_header_id = p_list_header_id
2076: and list_line_id = nvl(p_lline_id, list_line_id)
2077: AND (end_date_active IS NULL
2078: OR end_date_active >= SYSDATE);

Line 2538: FROM qp_modifier_summary_v a, ozf_offers b

2534:
2535:
2536: CURSOR c_list_lines(ll_list_header_id NUMBER) IS
2537: SELECT DISTINCT list_line_id lline_id
2538: FROM qp_modifier_summary_v a, ozf_offers b
2539: WHERE a.list_header_id = ll_list_header_id
2540: AND b.qp_list_header_id = a.list_header_id
2541: AND b.offer_type <> 'VOLUME_OFFER'
2542: AND (a.end_date_active IS NULL

Line 2572: FROM qp_modifier_summary_v

2568: ;
2569:
2570: CURSOR c_no_products(ll_list_header_id NUMBER) IS
2571: SELECT COUNT(DISTINCT list_line_id)
2572: FROM qp_modifier_summary_v
2573: WHERE list_header_id = ll_list_header_id
2574: AND (end_date_active IS NULL
2575: OR end_date_active >= SYSDATE);
2576: