APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_LIST_HEADERS

Line 5179: , qp_list_headers_b qplh

5175: From
5176: qp_qualifiers qpq
5177: , qp_pricing_attributes qppa
5178: , qp_list_lines qpll
5179: , qp_list_headers_b qplh
5180: , qp_price_req_sources qpprs
5181: where
5182: qpq.qualifier_context='CUSTOMER'
5183: and qpq.qualifier_attribute='QUALIFIER_ATTRIBUTE15'

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 5503: from qp_list_headers_b

5499: BEGIN
5500:
5501: select rounding_factor
5502: into l_rounding_factor
5503: from qp_list_headers_b
5504: where list_header_id = p_list_header_id;
5505:
5506: If l_rounding_factor = fnd_api.g_miss_num then
5507: l_rounding_factor:= Null;

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 5859: FROM qp_list_lines l,qp_list_headers h

5855: out_end_date,
5856: out_start_date,
5857: out_modifier_level_code
5858:
5859: FROM qp_list_lines l,qp_list_headers h
5860: WHERE l.list_line_id = in_list_line_id
5861: AND h.list_header_id = l.list_header_id;
5862:
5863:

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;