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 2080: FROM qp_modifier_summary_v

2076: IS
2077:
2078: CURSOR c_list_lines IS
2079: SELECT DISTINCT list_line_id
2080: FROM qp_modifier_summary_v
2081: WHERE list_header_id = p_list_header_id
2082: AND list_line_id = NVL(p_lline_id , list_line_id)
2083: AND (end_date_active IS NULL
2084: OR end_date_active >= SYSDATE);

Line 2108: FROM qp_modifier_summary_v

2104: WHERE offer_id = p_list_header_id;
2105:
2106: CURSOR c_no_products IS
2107: SELECT COUNT(DISTINCT list_line_id)
2108: FROM qp_modifier_summary_v
2109: WHERE list_header_id = p_list_header_id
2110: and list_line_id = nvl(p_lline_id, list_line_id)
2111: AND (end_date_active IS NULL
2112: OR end_date_active >= SYSDATE);

Line 2595: FROM qp_modifier_summary_v a, ozf_offers b

2591:
2592:
2593: CURSOR c_list_lines(ll_list_header_id NUMBER) IS
2594: SELECT DISTINCT list_line_id lline_id
2595: FROM qp_modifier_summary_v a, ozf_offers b
2596: WHERE a.list_header_id = ll_list_header_id
2597: AND b.qp_list_header_id = a.list_header_id
2598: AND b.offer_type <> 'VOLUME_OFFER'
2599: AND (a.end_date_active IS NULL

Line 2629: FROM qp_modifier_summary_v

2625: ;
2626:
2627: CURSOR c_no_products(ll_list_header_id NUMBER) IS
2628: SELECT COUNT(DISTINCT list_line_id)
2629: FROM qp_modifier_summary_v
2630: WHERE list_header_id = ll_list_header_id
2631: AND (end_date_active IS NULL
2632: OR end_date_active >= SYSDATE);
2633: