APPS.OE_RELATED_ITEMS_PVT dependencies on QP_LIST_LINES

Line 3046: , qp_list_lines qpll

3042: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
3043: From
3044: qp_qualifiers qpq
3045: , qp_pricing_attributes qppa
3046: , qp_list_lines qpll
3047: , qp_list_headers_b qplh
3048: , qp_price_req_sources qpprs
3049: where
3050: qpq.qualifier_context='CUSTOMER'

Line 3170: from qp_list_headers_vl a,qp_list_lines b where

3166: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3167: END IF;
3168: Begin
3169: Select name into l_price_list
3170: from qp_list_headers_vl a,qp_list_lines b where
3171: b.list_line_id = to_number(substr(in_status_text,1,
3172: instr(in_status_text,',')-1))
3173: and a.list_header_id=b.list_header_id ;
3174: Exception When No_data_found then

Line 3188: from qp_list_headers_vl a,qp_list_lines b where

3184: END IF;
3185: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3186: Begin
3187: Select name into l_price_list
3188: from qp_list_headers_vl a,qp_list_lines b where
3189: b.list_line_id = to_number(substr(in_status_text,
3190: instr(in_status_text,',')+1))
3191: and a.list_header_id=b.list_header_id ;
3192: Exception When No_data_found then