APPS.OE_VALIDATE_LOT_SERIAL SQL Statements

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

Line: 30

		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: 36

       SELECT lot_control_code,
              tracking_quantity_ind,
              secondary_uom_code,
              serial_number_control_code,
              secondary_default_ind
         	FROM mtl_system_items
     		WHERE organization_id   = discrete_org_id
         	AND   inventory_item_id = discrete_item_id;

Line: 47

       SELECT item_id
       	    , item_no
            , lot_ctl
            --, sublot_ctl INVCONV
            , dualum_ind
            , item_um2
       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: 64

      Select lot_number
      from mtl_lot_numbers
			where inventory_item_id = p_inventory_item_id
			and lot_number =  p_lot_number
			and organization_id = p_organization_id;

Line: 72

                    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: 78

            SELECT enforce_rma_lot_num
            FROM rcv_parameters
     	    WHERE organization_id   = org_id;

Line: 85

                    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: 217

	       SELECT NVL(SUM(ORDERED_QUANTITY),0)
	       INTO l_ordered_qty
	       FROM OE_ORDER_LINES
	       WHERE line_set_id = p_Lot_Serial_rec.line_set_id;

Line: 222

	       SELECT NVL(SUM(quantity),0)
	       INTO l_total_qty
	       FROM OE_LOT_SERIAL_NUMBERS
	       WHERE line_set_id = p_Lot_Serial_rec.line_set_id
	       AND lot_serial_id <> p_Lot_Serial_rec.lot_serial_id;

Line: 231

	       SELECT NVL(ORDERED_QUANTITY,0)
	       INTO l_ordered_qty
	       FROM OE_ORDER_LINES
	       WHERE line_id = p_Lot_Serial_rec.line_id;

Line: 236

	       SELECT NVL(SUM(quantity),0)
	       INTO l_total_qty
	       FROM OE_LOT_SERIAL_NUMBERS
	       WHERE line_id = p_Lot_Serial_rec.line_id
	       AND lot_serial_id <> p_Lot_Serial_rec.lot_serial_id;

Line: 827

    IF  p_Lot_Serial_rec.last_updated_by IS NOT NULL AND
        (   p_Lot_Serial_rec.last_updated_by <>
            p_old_Lot_Serial_rec.last_updated_by OR
            p_old_Lot_Serial_rec.last_updated_by IS NULL )
    THEN
        IF NOT OE_Validate.Last_Updated_By(p_Lot_Serial_rec.last_updated_by) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 837

    IF  p_Lot_Serial_rec.last_update_date IS NOT NULL AND
        (   p_Lot_Serial_rec.last_update_date <>
            p_old_Lot_Serial_rec.last_update_date OR
            p_old_Lot_Serial_rec.last_update_date IS NULL )
    THEN
        IF NOT OE_Validate.Last_Update_Date(p_Lot_Serial_rec.last_update_date) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 847

    IF  p_Lot_Serial_rec.last_update_login IS NOT NULL AND
        (   p_Lot_Serial_rec.last_update_login <>
            p_old_Lot_Serial_rec.last_update_login OR
            p_old_Lot_Serial_rec.last_update_login IS NULL )
    THEN
        IF NOT OE_Validate.Last_Update_Login(p_Lot_Serial_rec.last_update_login) THEN
            x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1122

PROCEDURE Entity_Delete
( x_return_status OUT NOCOPY VARCHAR2

,   p_Lot_Serial_rec                IN  OE_Order_PUB.Lot_Serial_Rec_Type
)
IS
l_return_status               VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 1160

            ,   'Entity_Delete'
            );

Line: 1164

END Entity_Delete;

Line: 1195

            ,   'Entity_Delete'
            );