APPS.OE_OE_AVAILABILITY dependencies on QP_LIST_HEADERS_VL

Line 3865: from qp_list_headers_vl

3861:
3862: IF in_price_list_id is not null then
3863: Begin
3864: Select name into l_price_list
3865: from qp_list_headers_vl
3866: where list_header_id = in_price_list_id;
3867: Exception When No_data_found then
3868: l_price_list := in_price_list_id;
3869: End;

Line 3930: from qp_list_headers_vl a,qp_list_lines b where

3926: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
3927: END IF;
3928: Begin
3929: Select name into l_price_list
3930: from qp_list_headers_vl a,qp_list_lines b where
3931: b.list_line_id = to_number(substr(in_status_text,1,
3932: instr(in_status_text,',')-1))
3933: and a.list_header_id=b.list_header_id ;
3934: Exception When No_data_found then

Line 3948: from qp_list_headers_vl a,qp_list_lines b where

3944: END IF;
3945: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
3946: Begin
3947: Select name into l_price_list
3948: from qp_list_headers_vl a,qp_list_lines b where
3949: b.list_line_id = to_number(substr(in_status_text,
3950: instr(in_status_text,',')+1))
3951: and a.list_header_id=b.list_header_id ;
3952: Exception When No_data_found then

Line 4189: FROM qp_list_headers_vl

4185: out_start_date,
4186: out_currency,
4187: out_ask_for_flag
4188:
4189: FROM qp_list_headers_vl
4190: WHERE list_header_id = in_list_header_id;
4191:
4192:
4193: IF l_debug_level > 0 THEN

Line 4388: FROM qp_list_headers_vl

4384: out_gsa_indicator,
4385: out_currency,
4386: out_freight_terms_code
4387:
4388: FROM qp_list_headers_vl
4389: WHERE list_header_id = p_price_list_id
4390: and list_type_code in ('PRL', 'AGR');
4391:
4392: END IF;