DBA Data[Home] [Help]

APPS.DPP_PRICING_PVT dependencies on QP_LIST_LINES_V

Line 76: qp_list_lines_v qll

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
80: nvl(qlh.end_date_active, g_trunc_sysdate) AND

Line 362: qp_list_lines_v qll

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)
365: and nvl(qlh.end_date_active,g_trunc_sysdate)
366: and qlh.list_header_id=qqv.list_header_id

Line 381: qp_list_lines_v qll

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)
384: and nvl(qlh.end_date_active,g_trunc_sysdate)
385: and qlh.list_header_id=qqv.list_header_id