[Home] [Help]
3867: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
3868: b.proration_type_code, b.include_on_returns_flag,
3869: b.rebate_transaction_type_code, b.number_expiration_periods,
3870: b.expiration_period_uom, b.comments
3871: FROM qp_preq_ldets_tmp_t qpt, qp_list_lines b
3872: WHERE qp_java_engine_util_pub.java_engine_running = 'N'
3873: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), 1)
3874: AND qpt.created_from_list_line_id = b.list_line_id
3875: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW
3894: b.charge_subtype_code, b.benefit_qty, b.benefit_uom_code,
3895: b.proration_type_code, b.include_on_returns_flag,
3896: b.rebate_transaction_type_code, b.number_expiration_periods,
3897: b.expiration_period_uom, b.comments
3898: FROM qp_int_ldets_t qpt, qp_list_lines b
3899: WHERE qp_java_engine_util_pub.java_engine_running = 'Y'
3900: AND qpt.request_id = NVL (SYS_CONTEXT ('QP_CONTEXT', 'REQUEST_ID'), -9999)
3901: AND qpt.created_from_list_line_id = b.list_line_id
3902: AND qpt.pricing_status_code = QP_PREQ_GRP.G_STATUS_NEW;
5199: Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
5200: From
5201: qp_qualifiers qpq
5202: , qp_pricing_attributes qppa
5203: , qp_list_lines qpll
5204: , qp_list_headers_b qplh
5205: , qp_price_req_sources qpprs
5206: where
5207: qpq.qualifier_context='CUSTOMER'
5325: oe_debug_pub.add( 'DUPLICATE PRICE LIST ERROR' ) ;
5326: END IF;
5327: Begin
5328: Select name into l_price_list
5329: from qp_list_headers_vl a,qp_list_lines b where
5330: b.list_line_id = to_number(substr(in_status_text,1,
5331: instr(in_status_text,',')-1))
5332: and a.list_header_id=b.list_header_id ;
5333: Exception When No_data_found then
5343: END IF;
5344: FND_MESSAGE.SET_TOKEN('PRICE_LIST1','( '||in_Ordered_Item||' ) '|| l_price_list);
5345: Begin
5346: Select name into l_price_list
5347: from qp_list_headers_vl a,qp_list_lines b where
5348: b.list_line_id = to_number(substr(in_status_text,
5349: instr(in_status_text,',')+1))
5350: and a.list_header_id=b.list_header_id ;
5351: Exception When No_data_found then
5678: select list_line_type_code,
5679: arithmetic_operator,
5680: operand into
5681: l_code,l_operator,l_operand
5682: from qp_list_lines where list_line_id=l_list_line_no;
5683:
5684: oe_debug_pub.add('after fetching the line details ');
5685:
5686: out_benefit:= get_qp_lookup_meaning(in_lookup_type=>'LIST_LINE_TYPE_CODE',
5880: out_end_date,
5881: out_start_date,
5882: out_modifier_level_code
5883:
5884: FROM qp_list_lines l,qp_list_headers h
5885: WHERE l.list_line_id = in_list_line_id
5886: AND h.list_header_id = l.list_header_id;
5887:
5888: