APPS.OE_OE_AVAILABILITY dependencies on QP_LIST_LINES

Line 3118: QP_LIST_LINES b

3114: b.NUMBER_EXPIRATION_PERIODS,
3115: b.EXPIRATION_PERIOD_UOM,
3116: b.COMMENTS
3117: FROM QP_PREQ_LDETS_TMP a,
3118: QP_LIST_LINES b
3119: WHERE a.CREATED_FROM_LIST_LINE_ID = b.LIST_LINE_ID
3120: AND a.PRICING_STATUS_CODE = QP_PREQ_GRP.G_STATUS_NEW;
3121:
3122:

Line 3823: , qp_list_lines qpll

3819: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
3820: From
3821: qp_qualifiers qpq
3822: , qp_pricing_attributes qppa
3823: , qp_list_lines qpll
3824: , qp_list_headers_b qplh
3825: , qp_price_req_sources qpprs
3826: where
3827: qpq.qualifier_context='CUSTOMER'

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

4254: out_end_date,
4255: out_start_date,
4256: out_modifier_level_code
4257:
4258: FROM qp_list_lines
4259: WHERE list_line_id = in_list_line_id;
4260:
4261:
4262: IF l_debug_level > 0 THEN