APPS.CSP_VALIDATE_PUB SQL Statements

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

Line: 86

                select organization_id into l_check_existence
                from mtl_parameters
                where organization_id = p_organization_id;

Line: 112

                    select inventory_item_id into l_check_existence
                    from mtl_system_items_kfv
                    where inventory_item_id = p_inventory_item_id
                    and organization_id = P_organization_id;

Line: 132

        select serial_number_control_code into l_serial_control_code
        from mtl_system_items
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 142

        select revision_qty_control_code into l_revision_control_code
        from mtl_system_items
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 152

        select lot_control_code into l_lot_control_code
        from mtl_system_items
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 219

        select nvl(current_status, 1) into l_serial_status
        from mtl_serial_numbers
        where inventory_item_id = p_inventory_item_id
        and serial_number = p_serial_number
        and current_organization_id = p_organization_id;

Line: 229

            select count(inventory_item_id) into l_count_qty
            from mtl_reservations
            where inventory_item_id = p_inventory_item_id
            and organization_id = p_organization_id
            and serial_number = p_serial_number;

Line: 346

        select count(organization_id) into l_count_qty
        from mtl_system_items_kfv
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 359

        select serial_number_control_code into l_serial_control_code
        from mtl_system_items
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 369

        select revision_qty_control_code into l_revision_control_code
        from mtl_system_items
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 379

        select lot_control_code into l_lot_control_code
        from mtl_system_items
        where organization_id = p_organization_id
        and inventory_item_id = p_inventory_item_id;

Line: 490

        select  serial_number_control_code,
                lot_control_code,
                revision_qty_control_code
        into    l_serial_control_code,
                l_lot_control_code,
                l_revision_control_code
        from    mtl_system_items
        where   organization_id   = p_organization_id
        and     inventory_item_id = p_inventory_item_id;

Line: 614

        select  serial_number_control_code,
                lot_control_code,
                revision_qty_control_code
        into    l_serial_control_code,
                l_lot_control_code,
                l_revision_control_code
        from    mtl_system_items
        where   organization_id   = p_organization_id
        and     inventory_item_id = p_inventory_item_id;