[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select period_name, start_date, end_date
from gl_periods
where period_name like decode(l_period_name, NULL, '%',
FND_API.G_MISS_CHAR, '%',
l_period_name)
and start_date >= decode(l_period_start_date, NULL, to_date('01/01/1000',
'DD/MM/YYYY'),
FND_API.G_MISS_CHAR, to_date('01/01/1000',
'DD/MM/YYYY'),
l_period_start_date)
and end_date <= decode(l_period_end_date, NULL, to_date('01/01/9999',
'DD/MM/YYYY'),
FND_API.G_MISS_CHAR, to_date('01/01/9999',
'DD/MM/YYYY'),
l_period_end_date)
and (period_set_name = l_period_set_name or period_set_name is NULL);
select meaning
from as_lookups
where lookup_code = l_lookup_code
and lookup_type = l_lookup_type;
select meaning
from ar_lookups
where lookup_code = l_lookup_code
and lookup_type = l_lookup_type;
select meaning
from aso_lookups
where lookup_code = l_lookup_code
and lookup_type = l_lookup_type;
select meaning
from hr_lookups
where lookup_code = l_lookup_code
and lookup_type = l_lookup_type;
select meaning
from cs_lookups
where lookup_code = l_lookup_code
and lookup_type = l_lookup_type;
select meaning
from fnd_common_lookups
where lookup_code = l_lookup_code
and lookup_type = l_lookup_type;
select unit_of_measure
from mtl_units_of_measure
where uom_code = l_uom_code;
select uom_code
from mtl_units_of_measure
where unit_of_measure = l_uom;
Select inventory_item_id,
organization_id ,
enabled_flag,
start_date_active,
end_date_active,
description,
concatenated_segments,
inventory_item_flag,
item_catalog_group_id,
Collateral_flag,
Primary_UOM_Code,
Primary_Unit_of_Measure,
inventory_item_status_code,
product_family_item_id,
bom_item_type
From mtl_system_items_kfv
Where inventory_item_id = p_inventory_item_id
And (description like NVL(p_description, '%')
Or description is NULL)
And (concatenated_segments like NVL(p_concatenated_segments, '%')
Or concatenated_segments is NULL)
And organization_id = p_organization_id
And (collateral_flag like NVL(p_collateral_flag, '%')
Or collateral_flag is NULL)
And bom_item_type = NVL(p_bom_item_type, bom_item_type); -- Bom_item_type is not indexed
Select inventory_item_id,
organization_id ,
enabled_flag,
start_date_active,
end_date_active,
description,
concatenated_segments,
inventory_item_flag,
item_catalog_group_id,
Collateral_flag,
Primary_UOM_Code,
Primary_Unit_of_Measure,
inventory_item_status_code,
product_family_item_id,
bom_item_type
From mtl_system_items_kfv
Where (description like p_description)
And (concatenated_segments like NVL(p_concatenated_segments, '%')
Or concatenated_segments is NULL)
And organization_id = p_organization_id
And (collateral_flag like NVL(p_collateral_flag, '%')
Or collateral_flag is NULL)
And bom_item_type = NVL(p_bom_item_type, bom_item_type) -- Bom_item_type is not indexed
UNION
Select inventory_item_id,
organization_id ,
enabled_flag,
start_date_active,
end_date_active,
description,
concatenated_segments,
inventory_item_flag,
item_catalog_group_id,
Collateral_flag,
Primary_UOM_Code,
Primary_Unit_of_Measure,
inventory_item_status_code,
product_family_item_id,
bom_item_type
From mtl_system_items_kfv
Where (description is NULL)
And (concatenated_segments like NVL(p_concatenated_segments, '%')
Or concatenated_segments is NULL)
And organization_id = p_organization_id
And (collateral_flag like NVL(p_collateral_flag, '%')
Or collateral_flag is NULL)
And bom_item_type = NVL(p_bom_item_type, bom_item_type); -- Bom_item_type is not indexed
Select Concatenated_Segments
From mtl_system_items_kfv
Where inventory_item_id = p_inventory_item_id And
organization_id = p_organization_id;
Select pr_line.list_price,
pr_head.currency_code
From aso_i_price_lists_v pr_head, aso_i_price_list_lines_v pr_line
Where pr_head.price_list_id = p_price_list_id
And pr_line.inventory_item_id = p_inventory_item_id
And pr_line.uom_code = p_unit_code
And pr_head.price_list_id = pr_line.price_list_id
And trunc(sysdate) between nvl(pr_head.start_date_active, trunc(sysdate))
And nvl(pr_head.end_date_active, trunc(sysdate))
And trunc(sysdate) between nvl(pr_line.start_date_active, trunc(sysdate))
And nvl(pr_line.end_date_active, trunc(sysdate))
And rownum = 1;
Select pr_line.list_price,
pr_head.currency_code
--From oe_price_lists pr_head, oe_price_list_lines pr_line
From qp_price_lists_v pr_head, qp_price_list_lines_v pr_line
Where pr_head.price_list_id = p_price_list_id
And pr_line.inventory_item_id = p_inventory_item_id
And pr_line.unit_code = p_unit_code
And pr_head.secondary_price_list_id = pr_line.price_list_id
And trunc(sysdate) between nvl(pr_head.start_date_active, trunc(sysdate))
And nvl(pr_head.end_date_active, trunc(sysdate))
And trunc(sysdate) between nvl(pr_line.start_date_active, trunc(sysdate))
And nvl(pr_line.end_date_active, trunc(sysdate))
And rownum = 1;
SELECT apl.price_list_id
--FROM as_price_lists apl, oe_price_lists spl
FROM as_price_lists apl, qp_price_lists_v spl
WHERE apl.group_id = c_group_id
AND apl.price_list_id = spl.price_list_id
AND spl.currency_code = c_currency_code;
SELECT icm.price
FROM AS_INTEREST_CODES_MC icm
WHERE icm.interest_code_id = c_secondary_code_id
AND icm.currency_code = c_currency_code;
SELECT application_id
FROM fnd_application_vl
WHERE application_short_name = x_short_name;
SELECT msg.message_number
FROM fnd_new_messages msg, fnd_languages_vl lng
WHERE msg.message_name = x_msg
and msg.application_id = x_id
and lng.LANGUAGE_CODE = msg.language_code
and lng.language_id = x_lang_id;