The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
MTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
ship_to_site_use_id = p_object_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
QTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
ship_to_site_use_id = p_object_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
YTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
ship_to_site_use_id = p_object_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
BACK_ORDER_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
ship_to_site_use_id = p_object_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
OUTSTAND_ORDER_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
ship_to_site_use_id = p_object_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
MTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
cust_account_id = p_cust_account_id
AND ship_to_site_use_id = p_site_use_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
QTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
cust_account_id = p_cust_account_id
AND ship_to_site_use_id = p_site_use_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
YTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
cust_account_id = p_cust_account_id
AND ship_to_site_use_id = p_site_use_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
BACK_ORDER_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
cust_account_id = p_cust_account_id
AND ship_to_site_use_id = p_site_use_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
OUTSTAND_ORDER_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
cust_account_id = p_cust_account_id
AND ship_to_site_use_id = p_site_use_id
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
MTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
product_attribute = p_product_attribute
AND product_attr_value = p_product_attr_value
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
QTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
product_attribute = p_product_attribute
AND product_attr_value = p_product_attr_value
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
YTD_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
product_attribute = p_product_attribute
AND product_attr_value = p_product_attr_value
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
BACK_ORDER_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
product_attribute = p_product_attribute
AND product_attr_value = p_product_attr_value
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
OUTSTAND_ORDER_ALERT INTO x_return_value
FROM
ozf_quota_alerts
WHERE
product_attribute = p_product_attribute
AND product_attr_value = p_product_attr_value
AND report_date = p_report_date
AND resource_id = p_resource_id
AND alert_for = p_alert_for;
SELECT
NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'),1,10)),-99) from DUAL;
Select p.party_name||' '||d.location into x_return_value
from hz_parties p,
hz_cust_acct_sites c,
hz_cust_site_uses d,
hz_cust_accounts e
where d.site_use_id = p_site_use_id
and d.cust_acct_site_id = c.cust_acct_site_id
and e.cust_account_id = c.cust_account_id
and p.party_id = e.party_id;
SELECT schedule_name
INTO x_return_value
FROM ams_campaign_schedules_tl
WHERE schedule_id = activity_id
AND language = userenv('LANG');
SELECT description
INTO x_return_value
FROM qp_list_headers_tl
WHERE list_header_id = activity_id
AND language = userenv('LANG');
SELECT campaign_name
INTO x_return_value
FROM ams_campaigns_all_tl
WHERE campaign_id = activity_id
AND language = userenv('LANG');
select count(act.object_id) into x_object_count
from ams_act_access_denorm act, qp_list_headers_b qp, ozf_offers off
where act.object_id = p_object_id
and act.object_type = p_object_class
and act.resource_id= p_resource_id
and qp.list_header_id = act.object_id
and off.qp_list_header_id = act.object_id
and qp.source_system_code = FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE')
and NVL(off.budget_offer_yn,'N') = 'N';
select count(act.object_id) into x_object_count
from ams_act_access_denorm act
where act.object_id = p_object_id
and act.object_type = p_object_class
and act.resource_id= p_resource_id;
select inv_convert.inv_um_convert(p_object_id,null,p_qty,p_from_uom,p_to_uom,null,null)
into x_return_value
from dual;
SELECT qualifier_context,
qualifier_attribute,
qualifier_attr_value
FROM ozf_worksheet_qualifiers
WHERE worksheet_header_id = p_obj_id;
IF l_status_code <> 'UPDATED'
THEN
x_return_status := FND_API.G_RET_STS_ERROR;
SELECT NVL(quota_unit,'Q')
FROM ozf_sys_parameters;
SELECT
NVL(d.category_desc, c.description) cat_descr
--NVL(d.concat_cat_parentage, c.description) cat_descr
FROM mtl_default_category_sets a,
mtl_category_sets_b b,
mtl_categories_v c,
ENI_PROD_DEN_HRCHY_PARENTS_V d
WHERE a.functional_area_id IN (7, 11)
AND a.category_set_id = b.category_set_id
AND b.structure_id = c.structure_id
AND c.category_id = d.category_id(+)
AND c.category_id = p_attr_value;
select description into l_item_name
from mtl_system_items_vl
where inventory_item_id = p_inventory_item_id
and organization_id = fnd_profile.value('QP_ORGANIZATION_ID');