APPS.OE_DEFAULT_LOT_SERIAL SQL Statements

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

Line: 46

    SELECT line_set_id
    INTO l_line_set_id
    FROM OE_ORDER_LINES
    WHERE line_id = g_Lot_Serial_rec.line_id;

Line: 88

    SELECT OE_LOT_SERIAL_S.NEXTVAL INTO l_lot_serial_id FROM DUAL;

Line: 101

		SELECT inventory_item_id,  ship_from_org_id, order_quantity_uom, ordered_quantity_uom2
	        FROM OE_ORDER_LINES
	       	WHERE line_id = p_line_id;

Line: 106

       SELECT item_id
            , lot_ctl
           -- , sublot_ctl INVCONV
            , dualum_ind
       FROM  ic_item_mst
       WHERE delete_mark = 0
       AND   item_no in (SELECT segment1
         	FROM mtl_system_items
     	WHERE organization_id   = discrete_org_id
          AND   inventory_item_id = discrete_item_id); */

Line: 119

                    Select lot_id
			from ic_lots_mst a where a.lot_id <> 0 and a.delete_mark = 0
			and a.item_id = opm_item_id
			and a.lot_no =  lot_number; */

Line: 128

                    Select lot_id
			from ic_lots_mst a where a.lot_id <> 0 and a.delete_mark = 0
			and a.item_id = opm_item_id
			and a.lot_no =  lot_number;

Line: 371

		SELECT inventory_item_id,  ship_from_org_id, order_quantity_uom, ordered_quantity_uom2
	        FROM OE_ORDER_LINES
	       	WHERE line_id = p_line_id;

Line: 377

       SELECT item_id
            , lot_ctl
           --  , sublot_ctl INVCONV
            , dualum_ind
       FROM  ic_item_mst
       WHERE delete_mark = 0
       AND   item_no in (SELECT segment1
         	FROM mtl_system_items
     	WHERE organization_id   = discrete_org_id
          AND   inventory_item_id = discrete_item_id);

Line: 390

                    Select lot_id
			from ic_lots_mst a where a.lot_id <> 0 and a.delete_mark = 0
			and a.item_id = opm_item_id
			and a.lot_no =  lot_number;

Line: 399

                    Select lot_id
			from ic_lots_mst a where a.lot_id <> 0 and a.delete_mark = 0
			and a.item_id = opm_item_id
			and a.lot_no =  lot_number;

Line: 995

    IF g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM THEN

        g_Lot_Serial_rec.last_updated_by := NULL;

Line: 1001

    IF g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE THEN

        g_Lot_Serial_rec.last_update_date := NULL;

Line: 1007

    IF g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM THEN

        g_Lot_Serial_rec.last_update_login := NULL;

Line: 1034

    OR  g_Lot_Serial_rec.last_updated_by = FND_API.G_MISS_NUM
    OR  g_Lot_Serial_rec.last_update_date = FND_API.G_MISS_DATE
    OR  g_Lot_Serial_rec.last_update_login = FND_API.G_MISS_NUM
    OR  g_Lot_Serial_rec.line_id = FND_API.G_MISS_NUM
    OR  g_Lot_Serial_rec.lot_number = FND_API.G_MISS_CHAR
    --OR  ( g_Lot_Serial_rec.sublot_number = FND_API.G_MISS_CHAR and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510') --OPM 2380194 INVCONV
    OR  g_Lot_Serial_rec.lot_serial_id = FND_API.G_MISS_NUM
    OR  g_Lot_Serial_rec.quantity = FND_API.G_MISS_NUM
    OR  ( g_Lot_Serial_rec.quantity2 = FND_API.G_MISS_NUM and OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510')     --OPM 2380194
    OR  g_Lot_Serial_rec.to_serial_number = FND_API.G_MISS_CHAR
    OR  g_Lot_Serial_rec.line_set_id = FND_API.G_MISS_NUM
    THEN

        OE_Default_Lot_Serial.Attributes
        (   p_x_Lot_Serial_rec            => g_Lot_Serial_rec
        ,   p_iteration                   => p_iteration + 1
        );