APPS.OE_OE_PRICING_AVAILABILITY dependencies on QP_LIST_LINES

Line 3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b

3842: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
3843: b.proration_type_code, b.include_on_returns_flag,
3844: b.rebate_transaction_type_code, b.number_expiration_periods,
3845: b.expiration_period_uom, b.comments
3846: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3847: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3848: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3849: AND qpt.created_from_list_line_id = b.list_line_id
3850: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW

Line 3873: FROM qp_int_ldets_t qpt, qp_list_lines b

3869: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
3870: b.proration_type_code, b.include_on_returns_flag,
3871: b.rebate_transaction_type_code, b.number_expiration_periods,
3872: b.expiration_period_uom, b.comments
3873: FROM qp_int_ldets_t qpt, qp_list_lines b
3874: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3875: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), -9999)
3876: AND qpt.created_from_list_line_id = b.list_line_id
3877: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;

Line 5178: , qp_list_lines qpll

5174: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5175: From
5176: qp_qualifiers qpq
5177: , qp_pricing_attributes qppa
5178: , qp_list_lines qpll
5179: , qp_list_headers_b qplh
5180: , qp_price_req_sources qpprs
5181: where
5182: qpq.qualifier_context='CUSTOMER'

Line 5304: from qp_list_headers_vl a,qp_list_lines b where

5300: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5301: END IF;
5302: Begin
5303: Select name into l_price_list
5304: from qp_list_headers_vl a,qp_list_lines b where
5305: b.list_line_id = to_number(substr(in_status_text,1,
5306: instr(in_status_text,',')-1))
5307: and a.list_header_id=b.list_header_id ;
5308: Exception When No_data_found then

Line 5322: from qp_list_headers_vl a,qp_list_lines b where

5318: END IF;
5319: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
5320: Begin
5321: Select name into l_price_list
5322: from qp_list_headers_vl a,qp_list_lines b where
5323: b.list_line_id = to_number(substr(in_status_text,
5324: instr(in_status_text,',')+1))
5325: and a.list_header_id=b.list_header_id ;
5326: Exception When No_data_found then

Line 5657: from qp_list_lines where list_line_id=l_list_line_no;

5653: select list_line_type_code,
5654: arithmetic_operator,
5655: operand into
5656: l_code,l_operator,l_operand
5657: from qp_list_lines where list_line_id=l_list_line_no;
5658:
5659: oe_debug_pub.add('after fetching the line details ');
5660:
5661: out_benefit:= get_qp_lookup_meaning(in_lookup_type=>'LIST_LINE_TYPE_CODE',

Line 5859: FROM qp_list_lines l,qp_list_headers h

5855: out_end_date,
5856: out_start_date,
5857: out_modifier_level_code
5858:
5859: FROM qp_list_lines l,qp_list_headers h
5860: WHERE l.list_line_id = in_list_line_id
5861: AND h.list_header_id = l.list_header_id;
5862:
5863: