[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT concatenated_segments,description,item_type
INTO out_inv_item_name,out_inv_desc,out_inv_item_type
FROM mtl_system_items_kfv
WHERE inventory_item_id = l_inv_item_id
AND organization_id = l_org_id;
l_atp_rec.Insert_Flag(I) := 1; -- it can be 0 or 1
SELECT mrp_atp_schedule_temp_s.nextval
INTO l_session_id
FROM dual;
select meaning
into l_explanation
from mfg_lookups
where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
and lookup_code = 80;
select meaning
into l_explanation
from mfg_lookups
where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
and lookup_code = p_atp_rec.error_code(J) ;
select meaning
into l_explanation
from mfg_lookups
where lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
and lookup_code = p_atp_rec.error_code(J) ;
SELECT organization_code,
name
INTO out_code,
out_name
FROM oe_ship_from_orgs_v
WHERE organization_id = in_org_id;
SELECT concatenated_segments
INTO oe_order_pub.g_line.ordered_item
FROM mtl_system_items_kfv
WHERE inventory_item_id = g_related_item_id
AND organization_id = l_org_id;
SELECT concatenated_segments
INTO oe_order_pub.g_line.ordered_item
FROM mtl_system_items_kfv
WHERE inventory_item_id = g_inventory_item_id
AND organization_id = l_org_id;
oe_debug_pub.add( 'UPDATED_ADJUSTED_UNIT_PRICE ='|| OUT_REQ_LINE_TBL ( I ) .UPDATED_ADJUSTED_UNIT_PRICE ) ;
Select/*+ ordered use_nl(qpq qppa qpll qplh) */ min(qpll.operand)
From
qp_qualifiers qpq
, qp_pricing_attributes qppa
, qp_list_lines qpll
, qp_list_headers_b qplh
, qp_price_req_sources qpprs
where
qpq.qualifier_context='CUSTOMER'
and qpq.qualifier_attribute='QUALIFIER_ATTRIBUTE15'
and qpq.qualifier_attr_value='Y'
and qppa.list_header_id=qplh.list_header_id
and qplh.Active_flag='Y'
and qpprs.request_type_code = 'ONT'
and qpprs.source_system_code=qplh.source_system_code
and qppa.pricing_phase_id = 2
and qppa.qualification_ind = 6
and qppa.product_attribute_context ='ITEM'
and qppa.product_attribute='PRICING_ATTRIBUTE1'
and qppa.product_attr_value= g_related_item_id
and qppa.excluder_flag = 'N'
and qppa.list_header_id=qpq.list_header_id
and qppa.list_line_id=qpll.list_line_id
and g_pricing_date between nvl(trunc(qplh.start_date_active),g_pricing_date)
and nvl(trunc(qplh.End_date_active),g_pricing_date);
Select name into l_price_list
from qp_list_headers_vl
where list_header_id = in_price_list_id;
Select name into l_price_list
from qp_list_headers_vl a,qp_list_lines b where
b.list_line_id = to_number(substr(in_status_text,1,
instr(in_status_text,',')-1))
and a.list_header_id=b.list_header_id ;
Select name into l_price_list
from qp_list_headers_vl a,qp_list_lines b where
b.list_line_id = to_number(substr(in_status_text,
instr(in_status_text,',')+1))
and a.list_header_id=b.list_header_id ;
oe_debug_pub.add('After select OE_PRICING_ERROR 2');
SELECT concatenated_segments
INTO l_msg_text
FROM mtl_system_items_kfv
WHERE inventory_item_id = g_related_item_id
AND organization_id = l_org_id;
(in_status_code in ( QP_PREQ_GRP.G_STATUS_UPDATED ,
QP_PREQ_GRP.G_STATUS_GSA_VIOLATION)
--In this case even engine doesn't update the order (status = UNCHANGED)
--because of one of the lined is frozen,
--there can be some order level adjustments in database which
--need to be pulled out by append_adjustment_lines routine
or (in_status_code = QP_PREQ_GRP.G_STATUS_UNCHANGED))
Then
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'OE_PRICING_ERROR 3' ) ;
ELSIF in_line_Type_code ='LINE' and in_status_code = 'UPDATED' then
IF l_debug_level > 0 THEN
oe_debug_pub.add( 'STATUS = UPDATED' ) ;
select rounding_factor
into l_rounding_factor
from qp_list_headers_b
where list_header_id = p_list_header_id;
SELECT NAME,
end_date_active,
start_date_active,
automatic_flag,
rounding_factor,
terms_id,
gsa_indicator,
currency_code,
freight_terms_code
INTO out_name,
out_end_date,
out_start_date,
out_automatic_flag,
out_rounding_factor,
out_terms_id,
out_gsa_indicator,
out_currency,
out_freight_terms_code
FROM qp_list_headers_vl
WHERE list_header_id = p_price_list_id
and list_type_code in ('PRL', 'AGR');
SELECT primary_uom_code
FROM mtl_system_items_b
WHERE organization_id = in_org_id
AND inventory_item_id = g_Inventory_item_id;
SELECT uom_Class
FROM mtl_units_of_measure_tl
WHERE uom_code = in_ordered_uom;
SELECT uom_code
FROM mtl_units_of_measure_tl
WHERE uom_class = in_class
AND base_uom_flag = 'Y';
SELECT round(1/conversion_rate,6)
FROM mtl_uom_conversions
WHERE uom_code = in_uom_code
AND inventory_item_id = g_inventory_item_id;
SELECT round(1/conversion_rate,6)
FROM mtl_uom_conversions
WHERE uom_Code = in_uom_code
AND inventory_item_id = 0;
SELECT round(1/conversion_rate,6)
FROM mtl_uom_class_conversions
WHERE to_uom_code = in_uom_code
AND from_uom_code = in_base_uom
AND inventory_item_id = g_inventory_item_id;
select hsecs
from v$timer;
select hsecs
from v$timer;