[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select criteria_code, weight, min_score, max_score
from poa_cm_distributions
where category_id = nvl(p_category_id, -1)
and organization_id = nvl(p_oper_unit_id, -1)
order by criteria_code;
select criteria_code, weight, min_score, max_score
from poa_cm_distributions
where category_id = nvl(p_category_id, -1)
and organization_id is null
order by criteria_code;
select criteria_code, weight, min_score, max_score
from poa_cm_distributions
where organization_id = nvl(p_oper_unit_id, -1)
and category_id is null
order by criteria_code;
select criteria_code, weight, min_score, max_score
from poa_cm_distributions
where organization_id = nvl(p_oper_unit_id, -1)
and category_id is null
order by criteria_code;
select criteria_code, weight, min_score, max_score
from poa_cm_distributions
where category_id = nvl(p_category_id, -1)
and organization_id is null
order by criteria_code;
select criteria_code, weight, min_score, max_score
from poa_cm_distributions
where category_id is null
and organization_id is null
order by criteria_code;
SELECT period_type
INTO l_period_type
FROM gl_period_types
WHERE USER_PERIOD_TYPE = l_user_period_type;
SELECT count(1)
INTO temp_var
FROM gl_periods
WHERE PERIOD_NAME = l_period_name
AND PERIOD_TYPE = l_period_type;
SELECT min(vendor_id)
INTO l_supplier_id
FROM PO_VENDORS
WHERE VENDOR_NAME = l_supplier_name;
SELECT min(vendor_site_id)
INTO l_supplier_site_id
FROM PO_VENDOR_SITES
WHERE VENDOR_SITE_CODE = l_site_name
AND VENDOR_ID = nvl(l_supplier_id,-1);
SELECT min(organization_id)
INTO l_oper_unit_id
FROM HR_OPERATING_UNITS
WHERE name = l_operating_unit AND EXISTS (
SELECT '1' FROM PO_VENDOR_SITES_ALL WHERE
vendor_site_id = nvl(l_supplier_site_id, vendor_site_id));
SELECT min(category_id)
INTO l_category_id
FROM mtl_categories_kfv
WHERE CONCATENATED_SEGMENTS = l_commodity
AND STRUCTURE_ID = x_structure_id;
SELECT inventory_organization_id
INTO x_organization_id
FROM financials_system_parameters;
SELECT min(msi.inventory_item_id)
INTO l_item_id
FROM mtl_system_items_kfv msi,
mtl_item_categories mic
WHERE msi.CONCATENATED_SEGMENTS = l_item
AND msi.organization_id = x_organization_id
AND msi.inventory_item_id = mic.inventory_item_id
AND msi.organization_id = mic.organization_id
AND mic.category_set_id = x_category_set_id
AND nvl(l_category_id, mic.category_id) = mic.category_id;
SELECT CATEGORY_ID
INTO l_category_id
FROM mtl_item_categories
WHERE organization_id = x_organization_id
AND category_set_id = x_category_set_id
AND INVENTORY_ITEM_ID = l_item_id;
SELECT orig_system_id
INTO l_evaluated_by_id
FROM WF_USERS
WHERE NAME = l_evaluated_by;
'Update' ,
POA_CM_EVALUATION_ID );
if (POA_CM_SUBMIT_TYPE = 'Update') then
poa_cm_eval_scores_icx.query_evals(
poa_cm_custom_measure_code ,
poa_cm_custom_measure ,
l_period_type ,
poa_cm_user_period_type ,
poa_cm_period_name ,
l_supplier_id ,
poa_cm_supplier ,
l_supplier_site_id ,
poa_cm_supplier_site ,
l_category_id ,
poa_cm_commodity ,
l_item_id ,
poa_cm_item ,
poa_cm_comments ,
l_evaluated_by_id ,
poa_cm_evaluated_by ,
poa_cm_org_id ,
l_oper_unit_id ,
poa_cm_operating_unit ,
poa_cm_submit_type ,
poa_cm_evaluation_id );
SELECT category_id, oper_unit_id
INTO l_category_id, l_oper_unit_id
FROM poa_cm_evaluation
WHERE evaluation_id = l_evaluation_id;
select criteria_code, weight, min_score, max_score
from poa_cm_eval_scores
where evaluation_id = l_evaluation_id;
SELECT score, comments
FROM poa_cm_eval_scores
WHERE evaluation_id = l_evaluation_id
AND criteria_code = l_criteria_table(v_counter-1).criteria_code;
function updateScores()
{
var f = document.POA_CM_EVAL_SCORES_R;
htp.p('');
SELECT displayed_field
INTO v_Criteria
FROM po_lookup_codes
WHERE lookup_type = 'SATISFACTION CRITERIA'
AND lookup_code = l_criteria_table(v_counter - 1).criteria_code;
v_last_update_date DATE;
Select the survey response that you would like to modify.
Last Update Date
SELECT pce.evaluation_id,
pvs.vendor_site_code,
hr.name,
cat.concatenated_segments,
item.concatenated_segments,
fu.user_name,
pce.creation_date,
pce.last_update_date
FROM poa_cm_evaluation pce,
hr_operating_units hr,
fnd_user fu,
mtl_categories_kfv cat,
mtl_system_items_kfv item,
po_vendor_sites pvs
WHERE pce.supplier_id = l_supplier_id
AND pce.period_type = l_period_type
AND pce.period_name = l_period_name
AND hr.organization_id (+)= pce.oper_unit_id
AND fu.user_id (+)= pce.evaluated_by
AND cat.category_id (+)= pce.category_id
AND item.inventory_item_id (+)= pce.item_id
AND item.organization_id (+)= pce.org_id
AND pvs.vendor_site_id (+)= pce.supplier_site_id
AND pce.oper_unit_id = l_oper_unit_id
ORDER BY pce.evaluation_id;
SELECT pce.evaluation_id,
pvs.vendor_site_code,
hr.name,
cat.concatenated_segments,
item.concatenated_segments,
fu.user_name,
pce.creation_date,
pce.last_update_date
FROM poa_cm_evaluation pce,
hr_operating_units hr,
fnd_user fu,
mtl_categories_kfv cat,
mtl_system_items_kfv item,
po_vendor_sites pvs
WHERE pce.supplier_id = l_supplier_id
AND pce.period_type = l_period_type
AND pce.period_name = l_period_name
AND hr.organization_id (+)= pce.oper_unit_id
AND fu.user_id (+)= pce.evaluated_by
AND cat.category_id (+)= pce.category_id
AND item.inventory_item_id (+)= pce.item_id
AND item.organization_id (+)= pce.org_id
AND pvs.vendor_site_id (+)= pce.supplier_site_id
AND pce.category_id = l_category_id
ORDER BY pce.evaluation_id;
SELECT pce.evaluation_id,
pvs.vendor_site_code,
hr.name,
cat.concatenated_segments,
item.concatenated_segments,
fu.user_name,
pce.creation_date,
pce.last_update_date
FROM poa_cm_evaluation pce,
hr_operating_units hr,
fnd_user fu,
mtl_categories_kfv cat,
mtl_system_items_kfv item,
po_vendor_sites pvs
WHERE pce.supplier_id = l_supplier_id
AND pce.period_type = l_period_type
AND pce.period_name = l_period_name
AND hr.organization_id (+)= pce.oper_unit_id
AND fu.user_id (+)= pce.evaluated_by
AND cat.category_id (+)= pce.category_id
AND item.inventory_item_id (+)= pce.item_id
AND item.organization_id (+)= pce.org_id
AND pvs.vendor_site_id (+)= pce.supplier_site_id
AND pce.oper_unit_id = l_oper_unit_id
AND pce.category_id = l_category_id
ORDER BY pce.evaluation_id;
SELECT pce.evaluation_id,
pvs.vendor_site_code,
hr.name,
cat.concatenated_segments,
item.concatenated_segments,
fu.user_name,
pce.creation_date,
pce.last_update_date
FROM poa_cm_evaluation pce,
hr_operating_units hr,
fnd_user fu,
mtl_categories_kfv cat,
mtl_system_items_kfv item,
po_vendor_sites pvs
WHERE pce.supplier_id = l_supplier_id
AND pce.period_type = l_period_type
AND pce.period_name = l_period_name
AND hr.organization_id (+)= pce.oper_unit_id
AND fu.user_id (+)= pce.evaluated_by
AND cat.category_id (+)= pce.category_id
AND item.inventory_item_id (+)= pce.item_id
AND item.organization_id (+)= pce.org_id
AND pvs.vendor_site_id (+)= pce.supplier_site_id
ORDER BY pce.evaluation_id;
FETCH c_evaluation into v_eval_id, v_supplier_site, v_oper_unit, v_commodity, v_item, v_evaluator, v_creation_date, v_last_update_date;
' || v_last_update_date || '
');