APPS.GMIUTILS SQL Statements

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

Line: 89

    SELECT inventory_item_id
    FROM   mtl_system_items_b
    WHERE  segment1 = P_item_no and
    ROWNUM = 1;

Line: 119

 |    Can be called from ICCNVED before batch update gme api.              |
 |                                                                         |
 | PARAMETERS                                                              |
 |    None                                                                 |
 |                                                                         |
 | RETURNS                                                                 |
 |    global var updated                                                   |
 |                                                                         |
 | HISTORY                                                                 |
 |    Teresa Wong 6/2/2004 B3415691                                        |
 |                         Enhancement for Serono.                         |
 +=========================================================================+
*/
PROCEDURE set_allow_neg_inv
IS
BEGIN

  G_ALLOW_NEG_INV := 1;

Line: 146

 |    IC$ALLOWNEGINV.  Can be called from ICCNVED after batch update.      |
 |                                                                         |
 | DESCRIPTION                                                             |
 |    Used to restore global variable G_allow_neg_inv to the profile       |
 |    IC$ALLOWNEGINV.							   |
 |                                                                         |
 | PARAMETERS                                                              |
 |    None                                                                 |
 |                                                                         |
 | RETURNS                                                                 |
 |    global var updated                                                   |
 |                                                                         |
 | HISTORY                                                                 |
 |    Teresa Wong 6/2/2004 B3415691                                        |
 |                         Enhancement for Serono.                         |
 +=========================================================================+
*/
PROCEDURE restore_allow_neg_inv
IS
BEGIN

  G_ALLOW_NEG_INV := NVL(fnd_profile.value('IC$ALLOWNEGINV'), 0);

Line: 213

SELECT loct_onhand, loct_onhand2
FROM ic_loct_inv
WHERE item_id = v_item_id
AND whse_code = v_whse
AND lot_id = v_lot_id
AND location = v_location;

Line: 308

SELECT
	nettable_ind, order_proc_ind, shipping_ind, prod_ind, rejected_ind
FROM
	ic_lots_sts
WHERE
	lot_status = V_lot_sts;

Line: 316

SELECT
	lot_no, sublot_no
FROM
	ic_lots_mst
WHERE
	lot_id = V_lot_id;

Line: 326

 IF NOT gmivdbl.ic_item_mst_select (
	p_ic_item_mst_row     => l_item_mst_rec,
	x_ic_item_mst_row     => l_item_mst_rec
 ) THEN
	RETURN FALSE;