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 353: qp_list_lines_v qll

349: IS
350: SELECT qlh.name Pricelist_Name
351: FROM qp_secu_list_headers_v qlh,
352: qp_qualifiers_v qqv,
353: qp_list_lines_v qll
354: WHERE qlh.active_flag='Y'
355: and g_trunc_sysdate between nvl(qlh.start_date_active,g_trunc_sysdate)
356: and nvl(qlh.end_date_active,g_trunc_sysdate)
357: and qlh.list_header_id=qqv.list_header_id

Line 372: qp_list_lines_v qll

368: UNION
369: SELECT qlh.name Pricelist_Name
370: FROM qp_secu_list_headers_v qlh,
371: qp_qualifiers_v qqv,
372: qp_list_lines_v qll
373: WHERE qlh.active_flag='Y'
374: and g_trunc_sysdate between nvl(qlh.start_date_active,g_trunc_sysdate)
375: and nvl(qlh.end_date_active,g_trunc_sysdate)
376: and qlh.list_header_id=qqv.list_header_id