APPS.OE_OE_AVAILABILITY dependencies on QP_LIST_LINES

Line 3113: QP_LIST_LINES b

3109: b.NUMBER_EXPIRATION_PERIODS,
3110: b.EXPIRATION_PERIOD_UOM,
3111: b.COMMENTS
3112: FROM QP_PREQ_LDETS_TMP a,
3113: QP_LIST_LINES b
3114: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
3115: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
3116:
3117:

Line 3806: , qp_list_lines qpll

3802: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
3803: From
3804: qp_qualifiers qpq
3805: , qp_pricing_attributes qppa
3806: , qp_list_lines qpll
3807: , qp_list_headers_b qplh
3808: , qp_price_req_sources qpprs
3809: where
3810: qpq.qualifier_context='CUSTOMER'

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 4241: FROM qp_list_lines

4237: out_end_date,
4238: out_start_date,
4239: out_modifier_level_code
4240:
4241: FROM qp_list_lines
4242: WHERE list_line_id = in_list_line_id;
4243:
4244:
4245: IF l_debug_level > 0 THEN