APPS.OE_OE_AVAILABILITY dependencies on QP_LIST_HEADERS_VL

Line 3882: from qp_list_headers_vl

3878:
3879: IF in_price_list_id is not null then
3880: Begin
3881: Select name into l_price_list
3882: from qp_list_headers_vl
3883: where list_header_id = in_price_list_id;
3884: Exception When No_data_found then
3885: l_price_list := in_price_list_id;
3886: End;

Line 3947: from qp_list_headers_vl a,qp_list_lines b where

3943: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3944: END IF;
3945: Begin
3946: Select name into l_price_list
3947: from qp_list_headers_vl a,qp_list_lines b where
3948: b.list_line_id = to_number(substr(in_status_text,1,
3949: instr(in_status_text,',')-1))
3950: and a.list_header_id=b.list_header_id ;
3951: Exception When No_data_found then

Line 3965: from qp_list_headers_vl a,qp_list_lines b where

3961: END IF;
3962: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3963: Begin
3964: Select name into l_price_list
3965: from qp_list_headers_vl a,qp_list_lines b where
3966: b.list_line_id = to_number(substr(in_status_text,
3967: instr(in_status_text,',')+1))
3968: and a.list_header_id=b.list_header_id ;
3969: Exception When No_data_found then

Line 4206: FROM qp_list_headers_vl

4202: out_start_date,
4203: out_currency,
4204: out_ask_for_flag
4205:
4206: FROM qp_list_headers_vl
4207: WHERE list_header_id = in_list_header_id;
4208:
4209:
4210: IF l_debug_level > 0 THEN

Line 4405: FROM qp_list_headers_vl

4401: out_gsa_indicator,
4402: out_currency,
4403: out_freight_terms_code
4404:
4405: FROM qp_list_headers_vl
4406: WHERE list_header_id = p_price_list_id
4407: and list_type_code in ('PRL', 'AGR');
4408:
4409: END IF;