APPS.OE_RELATED_ITEMS_PVT dependencies on QP_LIST_HEADERS_VL

Line 3139: from qp_list_headers_vl

3135:
3136: IF in_price_list_id is not null then
3137: Begin
3138: Select name into l_price_list
3139: from qp_list_headers_vl
3140: where list_header_id = in_price_list_id;
3141: Exception When No_data_found then
3142: l_price_list := in_price_list_id;
3143: End;

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

Line 3466: FROM qp_list_headers_vl

3462: out_gsa_indicator,
3463: out_currency,
3464: out_freight_terms_code
3465:
3466: FROM qp_list_headers_vl
3467: WHERE list_header_id = p_price_list_id
3468: and list_type_code in ('PRL', 'AGR');
3469:
3470: END IF;