DBA Data[Home] [Help]

APPS.GMISYUM SQL Statements

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

Line: 24

    SELECT um_type,std_factor
    FROM   sy_uoms_mst
    WHERE  um_code = V_uom
           AND delete_mark = 0;
Line: 59

    SELECT type_factor
    FROM   ic_item_cnv
    WHERE  item_id = V_item_id
           AND lot_id = V_lot_id
	   AND um_type = V_um_type;
Line: 84

*	the proper selection of the conversion factor.
*
*	Lab type is a passed parameter from the call lm_uomcv. It
*	populates the global variable 'lab_type' which is needed
*	for the select criteria in determining the conversion factor.
*
*	This is because the lab module allows for different
*	conversion factors based on density the standard item conversion
*	table is not used here.
*
* Parameters
* 	none
*
* Return Values
* 	 1	Success
* 	-1	Failure
*************************************************************************/
  X_density VARCHAR2(40);
Line: 103

    SELECT num_data
    FROM   lm_item_dat
    WHERE  lab_type = V_lab_type
           AND item_id = V_item_id
	   AND formula_id = V_lot_id
           AND tech_parm_name = X_density;
Line: 176

    SELECT item_um
    FROM   ic_item_mst
    WHERE  item_id = V_item_id;
Line: 207

update the new quantity and return
to caller.
================================== */
  IF (V_cur_uom =  V_new_uom) THEN
    V_new_qty := V_cur_qty;