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.DPP_PRICING_PVT dependencies on QP_SECU_LIST_HEADERS_V

Line 75: qp_secu_list_headers_v qlh,

71:
72: SELECT
73: qlh.name Pricelist_Name
74: FROM
75: qp_secu_list_headers_v qlh,
76: qp_list_lines_v qll
77: WHERE
78: qlh.active_flag = 'Y' AND
79: g_trunc_sysdate BETWEEN nvl(qlh.start_date_active, g_trunc_sysdate) AND

Line 360: FROM qp_secu_list_headers_v qlh,

356:
357: CURSOR get_pricelist_csr(p_inventory_item_id IN NUMBER, p_vendor_id IN NUMBER,p_vendor_site_id IN NUMBER, p_org_id IN NUMBER)
358: IS
359: SELECT qlh.name Pricelist_Name
360: FROM qp_secu_list_headers_v qlh,
361: qp_qualifiers_v qqv,
362: qp_list_lines_v qll
363: WHERE qlh.active_flag='Y'
364: and g_trunc_sysdate between nvl(qlh.start_date_active,g_trunc_sysdate)

Line 379: FROM qp_secu_list_headers_v qlh,

375: and nvl(qll.end_date_active,g_trunc_sysdate)
376: AND (qlh.orig_org_id = p_org_id OR NVL(qlh.global_flag,'N') = 'Y')
377: UNION
378: SELECT qlh.name Pricelist_Name
379: FROM qp_secu_list_headers_v qlh,
380: qp_qualifiers_v qqv,
381: qp_list_lines_v qll
382: WHERE qlh.active_flag='Y'
383: and g_trunc_sysdate between nvl(qlh.start_date_active,g_trunc_sysdate)