APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_LIST_HEADERS

Line 5204: , qp_list_headers_b qplh

5200: From
5201: qp_qualifiers qpq
5202: , qp_pricing_attributes qppa
5203: , qp_list_lines qpll
5204: , qp_list_headers_b qplh
5205: , qp_price_req_sources qpprs
5206: where
5207: qpq.qualifier_context='CUSTOMER'
5208: and qpq.qualifier_attribute='QUALIFIER_ATTRIBUTE15'

Line 5262: from qp_list_headers_vl

5258:
5259: IF in_price_list_id is not null then
5260: Begin
5261: Select name into l_price_list
5262: from qp_list_headers_vl
5263: where list_header_id = in_price_list_id;
5264: Exception When No_data_found then
5265: l_price_list := in_price_list_id;
5266: End;

Line 5329: from qp_list_headers_vl a,qp_list_lines b where

5325: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5326: END IF;
5327: Begin
5328: Select name into l_price_list
5329: from qp_list_headers_vl a,qp_list_lines b where
5330: b.list_line_id = to_number(substr(in_status_text,1,
5331: instr(in_status_text,',')-1))
5332: and a.list_header_id=b.list_header_id ;
5333: Exception When No_data_found then

Line 5347: from qp_list_headers_vl a,qp_list_lines b where

5343: END IF;
5344: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
5345: Begin
5346: Select name into l_price_list
5347: from qp_list_headers_vl a,qp_list_lines b where
5348: b.list_line_id = to_number(substr(in_status_text,
5349: instr(in_status_text,',')+1))
5350: and a.list_header_id=b.list_header_id ;
5351: Exception When No_data_found then

Line 5528: from qp_list_headers_b

5524: BEGIN
5525:
5526: select rounding_factor
5527: into l_rounding_factor
5528: from qp_list_headers_b
5529: where list_header_id = p_list_header_id;
5530:
5531: If l_rounding_factor = fnd_api.g_miss_num then
5532: l_rounding_factor:= Null;

Line 5832: FROM qp_list_headers_vl

5828: out_start_date,
5829: out_currency,
5830: out_ask_for_flag
5831:
5832: FROM qp_list_headers_vl
5833: WHERE list_header_id = in_list_header_id;
5834:
5835:
5836: IF l_debug_level > 0 THEN

Line 5884: FROM qp_list_lines l,qp_list_headers h

5880: out_end_date,
5881: out_start_date,
5882: out_modifier_level_code
5883:
5884: FROM qp_list_lines l,qp_list_headers h
5885: WHERE l.list_line_id = in_list_line_id
5886: AND h.list_header_id = l.list_header_id;
5887:
5888:

Line 6032: FROM qp_list_headers_vl

6028: out_gsa_indicator,
6029: out_currency,
6030: out_freight_terms_code
6031:
6032: FROM qp_list_headers_vl
6033: WHERE list_header_id = p_price_list_id
6034: and list_type_code in ('PRL', 'AGR');
6035:
6036: END IF;