[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT uom_code
FROM mtl_units_of_measure
WHERE uom_class = V_type
AND base_uom_flag = 'Y';
SELECT d.inventory_item_id, d.qty, d.detail_uom, i.concatenated_segments
FROM fm_matl_dtl d, mtl_system_items_kfv i
WHERE formula_id = p_formula_id
AND line_type <> -1
AND i.inventory_item_id = d.inventory_item_id;
P_form_tab.delete;
DELETE FROM gmd_formula_analysis_dtl
WHERE formula_id = p_formula_id
AND organization_id = p_organization_id
AND laboratory_id = p_laboratory_id;
DELETE FROM gmd_formula_analysis_hdr
WHERE formula_id = p_formula_id
AND organization_id = p_organization_id
AND laboratory_id = p_laboratory_id;
/* Insert records into tables. */
INSERT INTO gmd_formula_analysis_hdr
(formula_id, organization_id, laboratory_id, explosion_rule, created_by, creation_date,
last_updated_by, last_update_date, last_update_login, analysis_qty, analysis_hdr_uom)
VALUES (p_formula_id, p_organization_id, p_laboratory_id, p_explosion_rule, X_user, SYSDATE,
X_user, SYSDATE, X_login_id, p_analysis_qty, p_rep_um);
INSERT INTO gmd_formula_analysis_dtl
(formula_id, organization_id, laboratory_id, inventory_item_id, technical_class, technical_sub_class,
direct_weight, direct_weight_percent, indirect_weight, indirect_weight_percent,
direct_volume, direct_volume_percent, indirect_volume, indirect_volume_percent)
VALUES (p_formula_id, p_organization_id, p_laboratory_id, P_dtl_tab(i).inventory_item_id, P_dtl_tab(i).technical_class,
P_dtl_tab(i).technical_sub_class, ROUND(P_dtl_tab(i).direct_weight,6),
ROUND(P_dtl_tab(i).direct_weight_percent,6), ROUND(P_dtl_tab(i).indirect_weight,6),
ROUND(P_dtl_tab(i).indirect_weight_percent,6), ROUND(P_dtl_tab(i).direct_volume,6),
ROUND(P_dtl_tab(i).direct_volume_percent,6), ROUND(P_dtl_tab(i).indirect_volume,6),
ROUND(P_dtl_tab(i).indirect_volume_percent,6));
SELECT mc.segment1 technical_class, mc.segment2 technical_sub_class
FROM mtl_category_sets mcs, mtl_default_category_sets mdc, mtl_item_categories mic,
mtl_categories_b mc
WHERE mdc.functional_area_id = 16
AND mic.inventory_item_id = V_item_id
AND mic.organization_id = V_orgn_id
AND mic.category_set_id = mdc.category_set_id
AND mic.category_id = mc.category_id
AND mdc.category_set_id = mcs.category_set_id;
SELECT concatenated_segments
FROM mtl_system_items_kfv
WHERE inventory_item_id = V_item_id;
SELECT qty
FROM fm_matl_dtl
WHERE inventory_item_id = V_item_id and
line_no = V_line_no and
formula_id = V_formulaid ;
SELECT qty, detail_uom
FROM fm_matl_dtl
WHERE formula_id = V_formula_id
AND line_type = 1
AND inventory_item_id = V_item_id;
SELECT formula_no, formula_vers
FROM fm_form_mst
WHERE formula_id = V_formula_id;
SELECT organization_code
FROM org_access_view
WHERE organization_id = p_organization_id;
X_vrules_tab1.delete;
X_vrules_tab.delete(i);
/* Processing over for this ingredient add/update it to final table if it is not being exploded */
IF (X_expl_fm_id IS NULL) THEN
/* Calculate the equivalent mass and volume qtys */
calc_mass_vol_qty(p_rec => p_rec,
p_organization_id => p_organization_id,
p_laboratory_id => p_laboratory_id,
x_return_status => X_status);
/* Check in final table if this item exists and update direct qtys */
IF (p_rec.item_id = P_dtl_tab(j).item_id) THEN
IF (p_rec.formula_id = p_formula_id) THEN
P_dtl_tab(j).direct_weight := P_dtl_tab(j).direct_weight + p_rec.mass_qty;
IF (INSTR(p_status,SUBSTR(X_recipe_rec.recipe_status,1,1)) > 0 AND X_recipe_rec.delete_mark = 0) THEN
get_formula(p_recipe_id => P_vrules_tab(i).recipe_id,
x_form_mst_rec => X_formula_rec);
IF (INSTR(p_status,SUBSTR(X_formula_rec.formula_status,1,1)) > 0 AND X_formula_rec.delete_mark = 0) THEN
x_found := 1;
SELECT line_no, line_type, inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind,
scale_multiple, scale_rounding_variance
FROM fm_matl_dtl
WHERE formula_id = p_formula_id
ORDER BY line_type, line_no;
SELECT d.inventory_item_id, d.line_no, i.concatenated_segments, d.qty, d.detail_uom,
d.iaformula_id, i.eng_item_flag, d.formula_id, d.tpformula_id
FROM fm_matl_dtl d, mtl_system_items_kfv i
WHERE d.formula_id = p_formula_id
AND d.line_type = -1
AND i.inventory_item_id = d.inventory_item_id
AND d.organization_id = i.organization_id
ORDER BY d.line_no;
SELECT uom_class
FROM mtl_units_of_measure
WHERE uom_code = V_um_code;
SELECT *
FROM fm_form_mst
WHERE formula_id = (SELECT formula_id
FROM gmd_recipes
WHERE recipe_id = p_recipe_id);
SELECT *
FROM gmd_recipes
WHERE recipe_id = p_recipe_id;
SELECT 1
FROM org_access_view o, gmd_parameters_hdr p
WHERE o.organization_id = p_organization_id
AND o.organization_id = p.organization_id
AND p.lab_ind = 1;
SELECT num_data
FROM lm_item_dat
WHERE organization_id = vOrgn_id
AND tech_parm_name = p_tech_parm_name
AND formula_id = p_ing_rec.tpformula_id
AND inventory_item_id = p_ing_rec.item_id;
SELECT num_data
FROM lm_item_dat
WHERE organization_id = vOrgn_id
AND tech_parm_name = p_tech_parm_name
AND inventory_item_id = p_ing_rec.item_id;
SELECT organization_code
FROM org_access_view
WHERE organization_id = p_organization_id;