APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_LIST_HEADERS_VL

Line 5237: from qp_list_headers_vl

5233:
5234: IF in_price_list_id is not null then
5235: Begin
5236: Select name into l_price_list
5237: from qp_list_headers_vl
5238: where list_header_id = in_price_list_id;
5239: Exception When No_data_found then
5240: l_price_list := in_price_list_id;
5241: End;

Line 5304: from qp_list_headers_vl a,qp_list_lines b where

5300: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5301: END IF;
5302: Begin
5303: Select name into l_price_list
5304: from qp_list_headers_vl a,qp_list_lines b where
5305: b.list_line_id = to_number(substr(in_status_text,1,
5306: instr(in_status_text,',')-1))
5307: and a.list_header_id=b.list_header_id ;
5308: Exception When No_data_found then

Line 5322: from qp_list_headers_vl a,qp_list_lines b where

5318: END IF;
5319: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
5320: Begin
5321: Select name into l_price_list
5322: from qp_list_headers_vl a,qp_list_lines b where
5323: b.list_line_id = to_number(substr(in_status_text,
5324: instr(in_status_text,',')+1))
5325: and a.list_header_id=b.list_header_id ;
5326: Exception When No_data_found then

Line 5807: FROM qp_list_headers_vl

5803: out_start_date,
5804: out_currency,
5805: out_ask_for_flag
5806:
5807: FROM qp_list_headers_vl
5808: WHERE list_header_id = in_list_header_id;
5809:
5810:
5811: IF l_debug_level > 0 THEN

Line 6007: FROM qp_list_headers_vl

6003: out_gsa_indicator,
6004: out_currency,
6005: out_freight_terms_code
6006:
6007: FROM qp_list_headers_vl
6008: WHERE list_header_id = p_price_list_id
6009: and list_type_code in ('PRL', 'AGR');
6010:
6011: END IF;