APPS.OE_RELATED_ITEMS_PVT dependencies on QP_LIST_LINES

Line 3080: , qp_list_lines qpll

3076: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
3077: From
3078: qp_qualifiers qpq
3079: , qp_pricing_attributes qppa
3080: , qp_list_lines qpll
3081: , qp_list_headers_b qplh
3082: , qp_price_req_sources qpprs
3083: where
3084: qpq.qualifier_context='CUSTOMER'

Line 3204: from qp_list_headers_vl a,qp_list_lines b where

3200: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3201: END IF;
3202: Begin
3203: Select name into l_price_list
3204: from qp_list_headers_vl a,qp_list_lines b where
3205: b.list_line_id = to_number(substr(in_status_text,1,
3206: instr(in_status_text,',')-1))
3207: and a.list_header_id=b.list_header_id ;
3208: Exception When No_data_found then

Line 3222: from qp_list_headers_vl a,qp_list_lines b where

3218: END IF;
3219: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3220: Begin
3221: Select name into l_price_list
3222: from qp_list_headers_vl a,qp_list_lines b where
3223: b.list_line_id = to_number(substr(in_status_text,
3224: instr(in_status_text,',')+1))
3225: and a.list_header_id=b.list_header_id ;
3226: Exception When No_data_found then