APPS.OE_VALIDATE_LINE dependencies on QP_LIST_HEADERS_VL

Line 6394: from qp_list_headers_vl

6390: BEGIN
6391: BEGIN
6392: select list_type_code
6393: into l_list_type_code
6394: from qp_list_headers_vl
6395: where list_header_id = p_line_rec.price_list_id;
6396: EXCEPTION WHEN NO_DATA_FOUND THEN
6397: null;
6398: END;

Line 6425: FROM qp_List_headers_vl

6421: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6422: BEGIN
6423: SELECT name
6424: INTO l_price_list_name
6425: FROM qp_List_headers_vl
6426: WHERE list_header_id = p_line_rec.price_list_id
6427: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6428: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6429: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 6439: FROM QP_List_headers_vl

6435: BEGIN
6436:
6437: SELECT name
6438: INTO l_price_list_name
6439: FROM QP_List_headers_vl
6440: WHERE list_header_id = l_price_list_id
6441: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6442: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6443: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 6612: -- modified by lkxu: to select from qp_list_headers_vl instead

6608:
6609: -- Modified 09-DEC-2001
6610: -- Blankets: modified select to select list_type_code instead
6611: -- of selecting only PRL price list
6612: -- modified by lkxu: to select from qp_list_headers_vl instead
6613: -- of from qp_price_lists_v to select only PRL type list headers.
6614:
6615: --use cache instead of sql for bug 4200055
6616: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_line_rec.price_list_id) ;

Line 6634: FROM qp_list_headers_vl

6630: RAISE NO_DATA_FOUND ;
6631: END IF ;
6632: /*SELECT name, list_type_code
6633: INTO l_price_list_name, l_list_type_code
6634: FROM qp_list_headers_vl
6635: WHERE list_header_id = p_line_rec.price_list_id
6636: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6637: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6638: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000))); */