APPS.GMD_FETCH_VALIDITY_RULES SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 71

    SELECT recipe_validity_rule_id, recipe_id , organization_id, inventory_item_id ,revision, recipe_use,
           preference, start_date, end_date , min_qty, max_qty , std_qty, detail_uom,
           inv_min_qty, inv_max_qty, delete_mark, validity_rule_status
    FROM   gmd_recipe_validity_rules
    WHERE  recipe_id = p_recipe_id
           AND ((validity_rule_status BETWEEN 700 AND 799) OR (validity_rule_status BETWEEN 400 AND 499) )
           AND (p_recipe_use IS NULL OR recipe_use = p_recipe_use)
           AND ( organization_id = v_orgn_id OR v_orgn_id IS NULL)
           AND (TRUNC(SYSDATE) BETWEEN TRUNC(start_date) AND nvl(TRUNC(end_date),SYSDATE+1))
    ORDER BY preference;

Line: 84

    SELECT recipe_validity_rule_id, recipe_id , organization_id, inventory_item_id ,revision, recipe_use,
           preference, start_date, end_date , min_qty, max_qty , std_qty, detail_uom,
           inv_min_qty, inv_max_qty, delete_mark, validity_rule_status
    FROM   gmd_recipe_validity_rules
    WHERE  (inventory_item_id = p_item_id)
           AND ((validity_rule_status BETWEEN 700 AND 799) OR (validity_rule_status BETWEEN 400 AND 499 ))
           AND (inv_min_qty <= l_quantity AND inv_max_qty >= l_quantity )
           AND ((organization_id = v_orgn_id) OR (v_orgn_id IS NULL))
           AND ((recipe_use = p_recipe_use) OR (p_recipe_use IS NULL))
    ORDER BY preference;

Line: 96

    SELECT primary_uom_code
    FROM   mtl_system_items
    WHERE  inventory_item_id = p_item_id;

Line: 101

    SELECT uom_code
    FROM   mtl_units_of_measure
    WHERE  uom_class = v_yield_type
    AND    base_uom_flag = 'Y';

Line: 107

    SELECT qty, scale_type, detail_uom
    FROM   fm_matl_dtl
    WHERE  formula_id = l_formula_id
           AND inventory_item_id = V_item_id
           AND line_type = 1
    ORDER BY line_no;

Line: 436

    SELECT inventory_item_id, qty, detail_uom, scale_type
    FROM   fm_matl_dtl
    WHERE  formula_id = p_formula_id
           AND line_type IN (1,2);

Line: 503

    SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
    FROM   fm_matl_dtl
    WHERE  formula_id = p_formula_id
           AND line_type = V_line_type;

Line: 591

    SELECT inventory_item_id, qty, detail_uom, scale_type
    FROM   fm_matl_dtl
    WHERE  formula_id = p_formula_id
           AND line_type = -1;

Line: 596

    SELECT total_input_qty, yield_uom
    FROM   fm_form_mst
    WHERE  formula_id = p_formula_id;

Line: 663

    SELECT inventory_item_id, qty, detail_uom, scale_type, contribute_yield_ind
    FROM   fm_matl_dtl
    WHERE  formula_id = p_formula_id
           AND line_type = -1;

Line: 756

    SELECT inventory_item_id, qty, detail_uom, scale_type
    FROM   fm_matl_dtl
    WHERE  formula_id = p_formula_id
           AND line_type = 1;

Line: 818

    SELECT concatenated_segments
    FROM   mtl_system_items_kfv
    WHERE  inventory_item_id = p_item_id;