APPS.OE_RELATED_ITEMS_PVT dependencies on QP_LIST_HEADERS_VL

Line 3105: from qp_list_headers_vl

3101:
3102: IF in_price_list_id is not null then
3103: Begin
3104: Select name into l_price_list
3105: from qp_list_headers_vl
3106: where list_header_id = in_price_list_id;
3107: Exception When No_data_found then
3108: l_price_list := in_price_list_id;
3109: End;

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

Line 3432: FROM qp_list_headers_vl

3428: out_gsa_indicator,
3429: out_currency,
3430: out_freight_terms_code
3431:
3432: FROM qp_list_headers_vl
3433: WHERE list_header_id = p_price_list_id
3434: and list_type_code in ('PRL', 'AGR');
3435:
3436: END IF;