APPS.OE_VALIDATE_LINE dependencies on QP_LIST_HEADERS_VL

Line 6022: from qp_list_headers_vl

6018: BEGIN
6019: BEGIN
6020: select list_type_code
6021: into l_list_type_code
6022: from qp_list_headers_vl
6023: where list_header_id = p_line_rec.price_list_id;
6024: EXCEPTION WHEN NO_DATA_FOUND THEN
6025: null;
6026: END;

Line 6053: FROM qp_List_headers_vl

6049: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
6050: BEGIN
6051: SELECT name
6052: INTO l_price_list_name
6053: FROM qp_List_headers_vl
6054: WHERE list_header_id = p_line_rec.price_list_id
6055: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6056: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6057: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

Line 6067: FROM QP_List_headers_vl

6063: BEGIN
6064:
6065: SELECT name
6066: INTO l_price_list_name
6067: FROM QP_List_headers_vl
6068: WHERE list_header_id = l_price_list_id
6069: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6070: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6071: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000)));

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

6236:
6237: -- Modified 09-DEC-2001
6238: -- Blankets: modified select to select list_type_code instead
6239: -- of selecting only PRL price list
6240: -- modified by lkxu: to select from qp_list_headers_vl instead
6241: -- of from qp_price_lists_v to select only PRL type list headers.
6242:
6243: --use cache instead of sql for bug 4200055
6244: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_line_rec.price_list_id) ;

Line 6262: FROM qp_list_headers_vl

6258: RAISE NO_DATA_FOUND ;
6259: END IF ;
6260: /*SELECT name, list_type_code
6261: INTO l_price_list_name, l_list_type_code
6262: FROM qp_list_headers_vl
6263: WHERE list_header_id = p_line_rec.price_list_id
6264: AND trunc(nvl(p_line_rec.pricing_date,sysdate)) BETWEEN
6265: trunc(nvl(START_DATE_ACTIVE,add_months(sysdate,-10000)))
6266: AND trunc(nvl(END_DATE_ACTIVE,add_months(sysdate,+10000))); */